/// <summary> /// 获得代用券信息 /// </summary> /// <param name="voucherbatchid"></param> /// <returns></returns> public static Flamingo.Entity.Para_Voucher GetVoucherSubstitute(string voucherbatchid) { MySqlParameter[] parameters = { new MySqlParameter("@_VoucherBatchId", MySqlDbType.VarChar, 10) }; parameters[0].Value = voucherbatchid; DataTable dt = DbHelperMySQL.RunProcedure("proc_voucherbatch_getByVoucherBatchId", parameters, "getByVoucherBatchId").Tables[0]; Flamingo.Entity.Para_Voucher model = new Entity.Para_Voucher(); if (dt.Rows.Count > 0) { model.VoucherBatchId = dt.Rows[0]["VoucherBatchId"].ToString(); model.VoucherName = dt.Rows[0]["VoucherName"].ToString(); model.VoucherTypeId = Int32.Parse(dt.Rows[0]["VoucherTypeId"].ToString()); model.VoucherType = dt.Rows[0]["VoucherTypeName"].ToString(); model.BeginDate = DateTime.Parse(dt.Rows[0]["ReleaseDate"].ToString()); model.EndDate = DateTime.Parse(dt.Rows[0]["ExpireDate"].ToString()); model.Price = float.Parse(dt.Rows[0]["UnitPrice"].ToString()); model.SerialScope = dt.Rows[0]["SerialScope"].ToString(); model.VoucherPrice = float.Parse(dt.Rows[0]["VoucherPrice"].ToString()); model.VoucherSubTypeId = Int32.Parse(dt.Rows[0]["VoucherSubTypeId"].ToString()); model.VoucherSubType = dt.Rows[0]["VoucherSubTypeName"].ToString(); model.AllowUse = true; model.ErrorMsg = string.Empty; } return(model); }
/// <summary> /// 获得影厅 /// </summary> /// <param name="theaterid"></param> /// <returns></returns> public static DataTable GetHall(string theaterid) { MySqlParameter[] parameters = { new MySqlParameter("@_TheaterId", MySqlDbType.VarChar, 8) }; parameters[0].Value = theaterid; return(DbHelperMySQL.RunProcedure("proc_hall_sel", parameters, "hall_sel").Tables[0]); }
/// <summary> /// 获得客户列表 模糊customername /// </summary> /// <param name="customername"></param> /// <returns></returns> public static DataTable GetCustomer(string customername) { MySqlParameter[] parameters = { new MySqlParameter("@_CustomerName", MySqlDbType.VarChar, 16) }; parameters[0].Value = customername; DataTable dt = DbHelperMySQL.RunProcedure("proc_customer_getByNameLike", parameters, "getByNameLike").Tables[0]; return(dt); }
/// <summary> /// 获得场次信息-补登Combox /// </summary> /// <param name="dailyplanid"></param> /// <param name="hallid"></param> /// <returns></returns> public static DataTable GetShowPlanInfo(string dailyplanid, string hallid) { MySqlParameter[] parameters = { new MySqlParameter("@_DailyPlanId", MySqlDbType.VarChar, 8), new MySqlParameter("@_HallId", MySqlDbType.VarChar, 2) }; parameters[0].Value = dailyplanid; parameters[1].Value = hallid; return(DbHelperMySQL.RunProcedure("proc_showplan_selFillUp", parameters, "showplan_selFillUp").Tables[0]); }
/// <summary> /// 获得服务器动作结果 /// </summary> /// <param name="serverdirectionid"></param> /// <returns></returns> public static int GetServerDirectionResult(int serverdirectionid) { MySqlParameter[] parameters = { new MySqlParameter("@_ServerDirectionId", MySqlDbType.Int32, 4), new MySqlParameter("@_Result", MySqlDbType.Int32, 4) }; parameters[0].Value = serverdirectionid; parameters[1].Direction = ParameterDirection.Output; DbHelperMySQL.RunProcedure("proc_serverdirection_selResult", parameters, "serverdirection_selResult"); return(int.Parse(parameters[1].Value.ToString())); }
/// <summary> /// 添加立即备份动作 /// </summary> /// <param name="userid"></param> public static int AddServerDirection(int userid) { MySqlParameter[] parameters = { new MySqlParameter("@_UserId", MySqlDbType.Int32, 4), new MySqlParameter("@_ServerDirectionId", MySqlDbType.Int32, 4) }; parameters[0].Value = userid; parameters[1].Direction = ParameterDirection.Output; DbHelperMySQL.RunProcedure("proc_serverdirection_add", parameters, "serverdirection_add"); return(Int32.Parse(parameters[1].Value.ToString())); }
/// <summary> /// 获得用户列表 /// </summary> /// <returns></returns> public static DataTable GetList() { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from user limit 0,100 "); //MySqlParameter[] parameters = { // new MySqlParameter("@UserId", MySqlDbType.VarChar,16)}; //parameters[0].Value = UserId; //return DbHelperMySQL.Query(strSql.ToString()).Tables[0]; return(DbHelperMySQL.RunProcedure("proc_User_GetList", null, "User_GetList").Tables[0]); }
/// <summary> /// 添加备份日志 /// </summary> /// <param name="_ServerDirectionId"></param> /// <param name="_BackupDate"></param> /// <param name="_Result"></param> public static void AddBackUpLog(int _ServerDirectionId, DateTime _BackupDate, int _Result) { MySqlParameter[] parameters = { new MySqlParameter("@_ServerDirectionId", MySqlDbType.Int32, 4), new MySqlParameter("@_BackupDate", MySqlDbType.DateTime), new MySqlParameter("@_Result", MySqlDbType.Int32, 4) }; parameters[0].Value = _ServerDirectionId; parameters[1].Value = _BackupDate; parameters[2].Value = _Result; int outint; DbHelperMySQL.RunProcedure("server_backuplog_add", parameters, out outint); }
/// <summary> /// 锁定多个座位状态 /// </summary> /// <param name="seatids">座位状态ID集合 |</param> /// <param name="showplanid">场次ID</param> /// <param name="lockedby">锁定人</param> /// <returns>座位状态集合</returns> public static DataTable Lock(StringBuilder seatstatusids, string showplanid, int lockedby) { MySqlParameter[] parameters = { new MySqlParameter("@seatstatusids", MySqlDbType.Text), new MySqlParameter("@slid", MySqlDbType.VarChar,12), new MySqlParameter("@lkid", MySqlDbType.Int32, 4) }; parameters[0].Value = seatstatusids.ToString(); parameters[1].Value = showplanid; parameters[2].Value = lockedby; DataSet ds = DbHelperMySQL.RunProcedure("proc_seatstatus_lockALot", parameters, "lockALot"); return(ds.Tables[ds.Tables.Count - 1]); }
/// <summary> /// 获取可用日计划的ID和日期 /// </summary> /// <param name="pageindex">第几页</param> /// <param name="pagecount">每页数量</param> /// <param name="totalpage">总页数</param> /// <returns></returns> public static DataSet GetDateChoose(int pageindex, int pagecount, out int totalpage) { MySqlParameter[] parameters = { new MySqlParameter("@pageindex", MySqlDbType.Int32, 4), new MySqlParameter("@pagecount", MySqlDbType.Int32, 4), new MySqlParameter("@totalpage", MySqlDbType.Int32, 4) }; parameters[0].Value = pageindex; parameters[1].Value = pagecount; parameters[2].Direction = ParameterDirection.Output; DataSet ds = DbHelperMySQL.RunProcedure("proc_dailyplan_getDateChoose", parameters, "getDateChoose"); totalpage = Int32.Parse(parameters[2].Value.ToString()); return(ds); }
/// <summary> /// 编辑备份设置信息 /// </summary> /// <param name="BackupSettingId"></param> /// <param name="BackupTime"></param> /// <param name="RepeatDay"></param> /// <param name="DatabasePath"></param> /// <param name="BackupPath"></param> public static void EditBackUpSetting(int BackupSettingId, string BackupTime, int RepeatDay, string DatabasePath, string BackupPath) { MySqlParameter[] parameters = { new MySqlParameter("@_BackupSettingId", MySqlDbType.Int32, 4), new MySqlParameter("@_BackupTime", MySqlDbType.VarChar, 8), new MySqlParameter("@_RepeatDay", MySqlDbType.Int32, 4), new MySqlParameter("@_DatabasePath", MySqlDbType.VarChar, 255), new MySqlParameter("@_BackupPath", MySqlDbType.VarChar, 255) }; parameters[0].Value = BackupSettingId; parameters[1].Value = BackupTime; parameters[2].Value = RepeatDay; parameters[3].Value = DatabasePath; parameters[4].Value = BackupPath; DbHelperMySQL.RunProcedure("proc_backupsetting_edit", parameters, "backupsetting_edit"); }
/// <summary> /// 取消多个座位的锁定状态 /// </summary> /// <param name="seatstatusids">座位状态ID集合 |</param> /// <param name="lockedby">锁定人</param> /// <returns></returns> public static bool CancelLock(string seatstatusids, string lockedby) { bool tf = false; MySqlParameter[] parameters = { new MySqlParameter("@seatstatusids", MySqlDbType.Text), new MySqlParameter("@lkid", MySqlDbType.VarChar,16), new MySqlParameter("@_isTrue", MySqlDbType.Int16) }; parameters[0].Value = seatstatusids; parameters[1].Value = lockedby; parameters[2].Direction = ParameterDirection.Output; DbHelperMySQL.RunProcedure("proc_seatstatus_cancelLockALot", parameters, "cancelLockALot"); tf = parameters[2].Value.ToString() == "1" ? true : false; return(tf); }
/// <summary> /// 取消一个座位的锁定状态 /// </summary> /// <param name="showplanid">场计划ID</param> /// <param name="seatid">座位ID</param> /// <param name="lockedby">锁定人</param> /// <returns>座位状态</returns> public static int CancelLock(string showplanid, string seatid, int lockedby) { int status = 0; MySqlParameter[] parameters = { new MySqlParameter("@slid", MySqlDbType.VarChar, 8), new MySqlParameter("@stid", MySqlDbType.VarChar, 12), new MySqlParameter("@lkid", MySqlDbType.Int32, 4), new MySqlParameter("@revalue", MySqlDbType.Int32, 4) }; parameters[0].Value = showplanid; parameters[1].Value = seatid; parameters[2].Value = lockedby; parameters[3].Direction = ParameterDirection.Output; DbHelperMySQL.RunProcedure("proc_seatstatus_cancelLock", parameters, "lock"); status = Int32.Parse(parameters[3].Value.ToString()); return(status); }
/// <summary> /// 获得在日计划中的影片ID和影片名称 /// </summary> /// <param name="pageindex">第几页</param> /// <param name="pagecount">每页数量</param> /// <param name="totalpage">总页数(output)</param> /// <param name="dailyplanid">日计划ID</param> /// <returns></returns> public static DataSet GetFilmChoose(int pageindex, int pagecount, out int totalpage, string dailyplanid, string theaterid) { MySqlParameter[] parameters = { new MySqlParameter("@pageindex", MySqlDbType.Int32, 4), new MySqlParameter("@pagecount", MySqlDbType.Int32, 4), new MySqlParameter("@totalpage", MySqlDbType.Int32, 4), new MySqlParameter("@dpid", MySqlDbType.VarChar, 8), new MySqlParameter("@_TheaterId", MySqlDbType.VarChar, 8) }; parameters[0].Value = pageindex; parameters[1].Value = pagecount; parameters[2].Direction = ParameterDirection.Output; parameters[3].Value = dailyplanid; parameters[4].Value = theaterid; DataSet ds = DbHelperMySQL.RunProcedure("proc_film_getFilmChoose", parameters, "getFilmChoose"); totalpage = Int32.Parse(parameters[2].Value.ToString()); return(ds); }
/// <summary> /// 获得日计划中的影厅信息 /// </summary> /// <param name="dailyplanid">日计划ID</param> /// <param name="showplanname">放映计划名称</param> /// <returns></returns> public static DataSet GetHallByDailyPlan(string dailyplanid, string showplanname, int pageindex, int pagecount, out int totalpage) { MySqlParameter[] parameters = { new MySqlParameter("@_DailyPlanId", MySqlDbType.VarChar, 8), new MySqlParameter("@_ShowPlanName", MySqlDbType.VarChar, 12), new MySqlParameter("pageindex", MySqlDbType.Int32, 4), new MySqlParameter("pagecount", MySqlDbType.Int32, 4), new MySqlParameter("totalpage", MySqlDbType.Int32, 4) }; parameters[0].Value = dailyplanid; parameters[1].Value = showplanname; parameters[2].Value = pageindex; parameters[3].Value = pagecount; parameters[4].Direction = ParameterDirection.Output; DataSet ds = DbHelperMySQL.RunProcedure("proc_showplan_getHall", parameters, "GetHall"); totalpage = Int32.Parse(parameters[4].Value.ToString()); return(ds); }
/// <summary> /// 获得票券信息(优惠券/兑换券) /// </summary> /// <param name="voucherid">票券ID(编号)</param> /// <returns></returns> public static Flamingo.Entity.Para_Voucher GetVoucher(string voucherid) { MySqlParameter[] parameters = { new MySqlParameter("@_VoucherId", MySqlDbType.VarChar, 16), new MySqlParameter("@_HasUsed", MySqlDbType.Bit) }; parameters[0].Value = voucherid; parameters[1].Direction = ParameterDirection.Output; DataTable dt = DbHelperMySQL.RunProcedure("proc_voucherbatch_getByVoucherId", parameters, "getByVoucherId").Tables[0]; bool tf = parameters[1].Value.ToString().Trim() == "1" ? true : false; Flamingo.Entity.Para_Voucher model = new Entity.Para_Voucher(); if (dt.Rows.Count > 0) { model.VoucherBatchId = dt.Rows[0]["VoucherBatchId"].ToString(); model.VoucherId = voucherid; model.VoucherName = dt.Rows[0]["VoucherName"].ToString(); model.VoucherTypeId = Int32.Parse(dt.Rows[0]["VoucherTypeId"].ToString()); model.VoucherType = dt.Rows[0]["VoucherTypeName"].ToString(); model.BeginDate = DateTime.Parse(dt.Rows[0]["ReleaseDate"].ToString()); model.EndDate = DateTime.Parse(dt.Rows[0]["ExpireDate"].ToString()); model.Price = float.Parse(dt.Rows[0]["UnitPrice"].ToString()); model.SerialScope = dt.Rows[0]["SerialScope"].ToString(); model.TemplateId = 0;// Int32.Parse(dt.Rows[0]["TemplateId"].ToString()); model.VoucherPrice = float.Parse(dt.Rows[0]["VoucherPrice"].ToString()); model.VoucherSubTypeId = Int32.Parse(dt.Rows[0]["VoucherSubTypeId"].ToString()); model.VoucherSubType = dt.Rows[0]["VoucherSubTypeName"].ToString(); model.AllowUse = true; model.ErrorMsg = string.Empty; if (tf == true) { model.AllowUse = false; model.ErrorMsg = "票券已被使用"; } } return(model); }
/// <summary> /// 获得场次 /// </summary> /// <param name="dailyplanid">日计划ID</param> /// <param name="filmid">影片ID</param> /// <param name="hallid">影厅ID</param> /// <returns></returns> public static DataSet GetShowPlan(string dailyplanid, string filmid, string hallid, int pageindex, int pagecount, out int totalpage) { MySqlParameter[] parameters = { new MySqlParameter("@dpid", MySqlDbType.VarChar, 8), new MySqlParameter("@fid", MySqlDbType.VarChar, 255), new MySqlParameter("@hid", MySqlDbType.VarChar, 2), new MySqlParameter("pageindex", MySqlDbType.Int32, 4), new MySqlParameter("pagecount", MySqlDbType.Int32, 4), new MySqlParameter("totalpage", MySqlDbType.Int32, 4) }; parameters[0].Value = dailyplanid; parameters[1].Value = filmid; parameters[2].Value = hallid; parameters[3].Value = pageindex; parameters[4].Value = pagecount; parameters[5].Direction = ParameterDirection.Output; DataSet ds = DbHelperMySQL.RunProcedure("proc_showplan_getShowPlan", parameters, "GetShowPlan"); totalpage = Int32.Parse(parameters[5].Value.ToString()); return(ds); }
/// <summary> /// 获得场次计划名称和影片ID 影厅ID 影厅名称 影院ID 影院名称 是否对号入座 /// </summary> /// <param name="showplanid"></param> /// <returns></returns> public static string[] GetShowPlanName(string showplanid) { MySqlParameter[] parameters = { new MySqlParameter("@_showplanid", MySqlDbType.VarChar, 12) }; parameters[0].Value = showplanid; DataSet ds = DbHelperMySQL.RunProcedure("proc_showplan_getShowPlanName", parameters, "getShowPlanName"); string[] strs = new string[ds.Tables[ds.Tables.Count - 1].Columns.Count]; if (ds != null) { DataTable dt = ds.Tables[ds.Tables.Count - 1]; if (dt != null) { if (ds.Tables[ds.Tables.Count - 1].Rows.Count == 1) { strs[0] = dt.Rows[0]["ShowPlanName"].ToString(); strs[1] = dt.Rows[0]["FilmId"].ToString(); strs[2] = dt.Rows[0]["HallName"].ToString(); strs[3] = dt.Rows[0]["HallId"].ToString(); strs[4] = dt.Rows[0]["TheaterId"].ToString(); strs[5] = dt.Rows[0]["TheaterName"].ToString(); strs[6] = (bool)dt.Rows[0]["IsCheckingNumber"] == true ? "对号入座" : "非对号入座"; strs[7] = dt.Rows[0]["ShowGroup"].ToString() == "" ? "false" : "true"; strs[8] = dt.Rows[0]["ShowPlanIds"].ToString(); strs[9] = dt.Rows[0]["FilmIds"].ToString(); strs[10] = dt.Rows[0]["ShowGroupShowPlanNames"].ToString(); strs[11] = dt.Rows[0]["LowestPrice"].ToString(); strs[12] = dt.Rows[0]["Position"].ToString(); strs[13] = dt.Rows[0]["StartTime"].ToString(); } } } return(strs); }
/// <summary> /// 获得代用券名称 /// </summary> /// <returns></returns> public static DataTable GetVoucherSubstituteVoucherName() { DataSet ds = DbHelperMySQL.RunProcedure("proc_voucherbatch_getSubstitute", null, "getSubstitute"); return(ds.Tables[0]); }
/// <summary> /// 获得备份设置信息 /// </summary> /// <returns></returns> public static DataTable GetBackUpSetting() { DataTable dt = DbHelperMySQL.RunProcedure("proc_backupsetting_sel", null, "backupsetting_sel").Tables[0]; return(dt); }
/// <summary> /// 获得影院信息 /// </summary> /// <returns></returns> public static string GetTheater() { return(DbHelperMySQL.RunProcedure("proc_theater_sel", null, "theater_sel").Tables[0].Rows[0][0].ToString()); }
/// <summary> /// 获得客户类型 /// </summary> /// <returns></returns> public static DataTable GetCustomerType() { DataTable dt = DbHelperMySQL.RunProcedure("proc_customer_getCustomerType", null, "getCustomerType").Tables[0]; return(dt); }