91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

資源簡介

基于winform開發的電影售票系統,數據庫用的SqlService2008有登陸,影片管理,售票界面,和學生票,贈票,會員購票,和會員增加修改刪除查詢和模糊查詢,還有會員金額的充值,可以通過會員進行購票,有多種購票模式,和對應于已購票的統計,對于購買的票還可以進行退票操作。 這個有點不好用啊,比較簡單,有復雜需求的可以單獨跟我聯系,有現成JAVA影城售票系統源碼,功能齊全。

資源截圖

代碼片段和文件信息

using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.SqlClient;
using?System.Configuration;
using?System.Data;

namespace?Movie
{
????public?class?DBHelper
????{

????????public?static?readonly?string?connString?=?“Data?Source=.;Initial?Catalog=Ticket;User?ID=sa;Password=123@qwe“;

????????private?static?SqlConnection?conn;
????????public?static?SqlConnection?Conn
????????{
????????????get
????????????{
????????????????if?(conn?==?null)
????????????????{
????????????????????conn?=?new?SqlConnection(connString);
????????????????????conn.Open();
????????????????}
????????????????else?if?(conn.State?==?System.Data.ConnectionState.Closed)
????????????????{
????????????????????conn.Open();
????????????????}
????????????????else?if?(conn.State?==?System.Data.ConnectionState.Broken)
????????????????{
????????????????????conn.Close();
????????????????????conn.Open();
????????????????}
????????????????return?conn;
????????????}
????????}

????????public?static?int?GetCommand(string?safeSql)
????????{
????????????SqlCommand?cmd?=?new?SqlCommand(safeSql?Conn);
????????????int?result?=?cmd.ExecuteNonQuery();
????????????return?result;
????????}

????????public?static?int?GetCommand(string?sql?params?SqlParameter[]?values)
????????{
????????????SqlCommand?cmd?=?new?SqlCommand(sql?Conn);
????????????cmd.Parameters.AddRange(values);
????????????return?cmd.ExecuteNonQuery();
????????}
????????public?static?object?GetScalar(string?safeSql)
????????{
????????????SqlCommand?cmd?=?new?SqlCommand(safeSql?Conn);
????????????return?cmd.ExecuteScalar();
????????}

????????public?static?int?GetScalar(string?sql?params?SqlParameter[]?values)
????????{
????????????SqlCommand?cmd?=?new?SqlCommand(sql?Conn);
????????????cmd.Parameters.AddRange(values);
????????????int?result?=?Convert.ToInt32(cmd.ExecuteScalar());
????????????return?result;
????????}

????????public?static?SqlDataReader?GetReader(string?safeSql)
????????{
????????????SqlCommand?cmd?=?new?SqlCommand(safeSql?Conn);
????????????SqlDataReader?reader?=?cmd.ExecuteReader();
????????????return?reader;
????????}

????????public?static?SqlDataReader?GetReader(string?sql?params?SqlParameter[]?values)
????????{
????????????SqlCommand?cmd?=?new?SqlCommand(sql?Conn);
????????????cmd.Parameters.AddRange(values);
????????????SqlDataReader?reader?=?cmd.ExecuteReader();
????????????return?reader;
????????}

????????public?static?DataTable?GetDataSet(string?safeSql)
????????{
????????????DataSet?ds?=?new?DataSet();
????????????SqlCommand?cmd?=?new?SqlCommand(safeSql?Conn);
????????????SqlDataAdapter?da?=?new?SqlDataAdapter(cmd);
????????????da.Fill(ds);
????????????return?ds.Tables[0];
????????}

????????public?static?DataTable?GetDataSet(string?safeSql?params?SqlParameter[]?values)
????????{
????????????DataSet?ds?=?new?DataSet();
????????????SqlCommand?cmd?=?new?SqlCommand(safeSql?Conn);
??

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-07-07?17:49??Movie\
?????目錄???????????0??2018-07-07?17:49??Movie\Movie\
?????目錄???????????0??2018-06-19?14:29??Movie\Movie\obj\
?????目錄???????????0??2018-06-26?13:06??Movie\Movie\obj\Debug\
?????文件????????1811??2018-06-26?13:07??Movie\Movie\obj\Debug\Movie.application
?????目錄???????????0??2018-07-07?17:52??__MACOSX\
?????目錄???????????0??2018-07-07?17:52??__MACOSX\Movie\
?????目錄???????????0??2018-07-07?17:52??__MACOSX\Movie\Movie\
?????目錄???????????0??2018-07-07?17:52??__MACOSX\Movie\Movie\obj\
?????目錄???????????0??2018-07-07?17:52??__MACOSX\Movie\Movie\obj\Debug\
?????文件?????????223??2018-06-26?13:07??__MACOSX\Movie\Movie\obj\Debug\._Movie.application
?????文件????????3394??2018-06-26?13:07??Movie\Movie\obj\Debug\Movie.exe.manifest
?????文件?????????223??2018-06-26?13:07??__MACOSX\Movie\Movie\obj\Debug\._Movie.exe.manifest
?????文件????????1453??2018-06-26?13:05??Movie\Movie\obj\Debug\Movie.csproj.FileListAbsolute.txt
?????文件?????????223??2018-06-26?13:05??__MACOSX\Movie\Movie\obj\Debug\._Movie.csproj.FileListAbsolute.txt
?????文件???????????0??2018-06-19?14:29??Movie\Movie\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件?????????223??2018-06-19?14:29??__MACOSX\Movie\Movie\obj\Debug\._TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件?????????180??2018-06-26?12:57??Movie\Movie\obj\Debug\Movie.Properties.Resources.resources
?????文件?????????223??2018-06-26?12:57??__MACOSX\Movie\Movie\obj\Debug\._Movie.Properties.Resources.resources
?????文件?????????180??2018-06-26?12:57??Movie\Movie\obj\Debug\Movie.Login.resources
?????文件?????????223??2018-06-26?12:57??__MACOSX\Movie\Movie\obj\Debug\._Movie.Login.resources
?????文件?????????180??2018-06-26?12:57??Movie\Movie\obj\Debug\Movie.FormMain.resources
?????文件?????????223??2018-06-26?12:57??__MACOSX\Movie\Movie\obj\Debug\._Movie.FormMain.resources
?????文件????????2384??2018-06-26?12:00??Movie\Movie\obj\Debug\Movie.csprojResolveAssemblyReference.cache
?????文件?????????223??2018-06-26?12:00??__MACOSX\Movie\Movie\obj\Debug\._Movie.csprojResolveAssemblyReference.cache
?????文件?????????180??2018-06-26?12:57??Movie\Movie\obj\Debug\Movie.FormExtMerBer.resources
?????文件?????????223??2018-06-26?12:57??__MACOSX\Movie\Movie\obj\Debug\._Movie.FormExtMerBer.resources
?????文件?????????180??2018-06-26?12:57??Movie\Movie\obj\Debug\Movie.FormMerBer.resources
?????文件?????????223??2018-06-26?12:57??__MACOSX\Movie\Movie\obj\Debug\._Movie.FormMerBer.resources
?????文件?????????180??2018-06-26?12:57??Movie\Movie\obj\Debug\Movie.FormAddMerBer.resources
?????文件?????????223??2018-06-26?12:57??__MACOSX\Movie\Movie\obj\Debug\._Movie.FormAddMerBer.resources
............此處省略222個文件信息

評論

共有 條評論