/// <summary> /// 向报表插入信息 /// </summary> /// <param name="SellCash">售卡金额</param> /// <param name="CanCash">退卡金额</param> /// <param name="RecCAsh">充值金额</param> /// <param name="NowCash">本期金额</param> /// <param name="Opertion">操作员</param> /// <param name="Date">结账日期</param> /// <returns></returns> public string InsertRecheck(string SellCash, string CanCash, string RecCAsh, string NowCash, string Opertion, string Date, Form form, string admin) { string Strms = ""; string isnull = IsNull.isNull(form);//判断文本框是否为空 string isGroupNumber = IsNull.GroupIsNumber(form); //判断文本框是否为空 if (isnull == "") //没有返回值说明不为空 { //判断文本内容是否是数字 if (isGroupNumber == "")//没有返回值,说明都是数字 { SettleAccountsIDAL settAccoutIDAL = (SettleAccountsIDAL)fact.CreateUser("SettleAccountsDAL"); //转成售卡实体 RegistrationCardno regist = new RegistrationCardno(); regist.OpertionID = int.Parse(Opertion); regist.AccountsState = "已结账"; settAccoutIDAL.UpdateRegistrationCardno(regist);//更新售卡结账状态 //转成充值实体 Recharge recharge = new Recharge(); recharge.OpertionID = int.Parse(Opertion); recharge.State = "已结账"; settAccoutIDAL.UpdateRecharge(recharge);//更新充值结账状态 //转成退卡实体 CanceCard cancardno = new CanceCard(); cancardno.OperationID = int.Parse(Opertion); cancardno.State = "已结账"; settAccoutIDAL.UpdateCancelCard(cancardno);//更新退卡结账状态 //向报表插入信息 //转成报表实体 Recheck recheck = new Recheck(); recheck.SallCash = double.Parse(SellCash); recheck.RechargeCash = double.Parse(RecCAsh); recheck.CanCash = double.Parse(CanCash); recheck.Currentincome = double.Parse(NowCash); recheck.Opertion = int.Parse(admin); recheck.CheckDate = DateTime.Parse(Date); settAccoutIDAL.InsertRecheck(recheck); Strms = "结账成功!"; } else { Strms = isGroupNumber; } } else { Strms = isnull; } return(Strms); }
/// <summary> /// 查询退卡记录 /// </summary> /// <param name="cancecard">退卡实体</param> /// <returns></returns> public DataTable SelectCancelCard(CanceCard cancecard) { //定义参数 SqlParameter[] sqlpams = { new SqlParameter("@OperationID", cancecard.OperationID), new SqlParameter("@State", cancecard.State) }; //定义SQL语句 string sql = @"select * from CancelCard where OperationID=@OperationID and State=@State"; //接受查询的返回值 DataTable SelectCancelCardnTable = sqlHelper.ExecuteQuery(sql, sqlpams, CommandType.Text); return(SelectCancelCardnTable); }
/// <summary> /// 更新退卡的结账状态 /// </summary> /// <param name="cancecard">退卡表实体</param> /// <returns>受影响行数</returns> public int UpdateCancelCard(CanceCard cancecard) { //定义参数 SqlParameter[] sqlpams = { new SqlParameter("@OperationID", cancecard.OperationID), new SqlParameter("@State", cancecard.State) }; //定义查询参数 string sql = @"update CancelCard set State=@State where OperationID=@OperationID and State='未结账'"; //接受受影响行数 int Relust = sqlHelper.ExecuteNonQuery(sql, sqlpams, CommandType.Text); return(Relust); }
/// <summary> /// 向退卡表插入信息 /// </summary> /// <param name="cancelcard">退卡表实体</param> /// <returns>受影响行数</returns> public int InsertCanCardno(CanceCard cancelcard) { //定义参数 SqlParameter[] sqlamps = { new SqlParameter("@StudentCardno", cancelcard.StudentCardno) , new SqlParameter("@CanCash", cancelcard.CanCash) , new SqlParameter("@CanDate", cancelcard.CanDate) , new SqlParameter("@CanTime", cancelcard.CanTime) , new SqlParameter("@OperationID", cancelcard.OperationID) , new SqlParameter("@State", cancelcard.State) }; //定义SQL语句 string sql = @"insert into CancelCard values(@StudentCardno,@CanCash,@CanDate,@CanTime,@OperationID,@State)"; //接受受影响行数 int Relust = sqlHelper.ExecuteNonQuery(sql, sqlamps, CommandType.Text); return(Relust); }
/// <summary> /// 查询退卡信息 /// </summary> /// <param name="OpertionID">操作员ID</param> /// <param name="StrMsg">返回信息提示</param> /// <returns></returns> public DataTable SelectCanCardno(string OpertionID, out string StrMsg) { bool IsNumber = IsNull.IsNumber(OpertionID); DataTable CanCardnoTable = new DataTable();//返回表信息 //调用接口和工厂创建DAL层具体类 SettleAccountsIDAL setteAcounIDAL = (SettleAccountsIDAL)fact.CreateUser("SettleAccountsDAL"); //判断操作员ID是否为空 if (OpertionID.Trim() == "")//说明操作员ID为空 { StrMsg = "操作员ID不能为空"; } else { //判断操作员ID是否是数字 if (IsNumber == true)//是数字 { #region 查询退卡信息 CanceCard canCardno = new CanceCard(); canCardno.OperationID = int.Parse(OpertionID); canCardno.State = "未结账"; CanCardnoTable = setteAcounIDAL.SelectCancelCard(canCardno);//获取卡号信息 //判断是否有卡号信息 if (CanCardnoTable.Rows.Count != 0) { StrMsg = "查询完毕!"; } else { StrMsg = "暂时没有退卡信息!"; } #endregion } else { StrMsg = "操作员ID必须输入数字,请从新输入!"; } } return(CanCardnoTable);//返回表里内容 }
/// <summary> /// 退卡 /// </summary> /// <param name="cardno">卡号</param> /// <param name="form">退卡窗体</param> /// <returns>是否退卡成功!</returns> public string CancelCard(string cardno, Form form) { //用于返回信息 string strMsger = ""; //接受判空返回值,判断文本框是否为空。 string isNull = IsNull.isNull(form); //接受是不是数字的判断返回值 bool isNumber = IsNull.IsNumber(cardno); //判断卡号是否为空 if (isNull == "")//没有返回值说明,文本框不为空。 { //判断卡号是否是数字 if (isNumber == true)//返回true是数字 { #region 退卡 CancelCardIDAL cancardnoIDAL = (CancelCardIDAL)fact.CreateUser("CancelCardDAL"); //实例化实体 RegistrationCardno registCardno = new RegistrationCardno(); registCardno.StudentCardno = int.Parse(cardno); //获取卡号信息 DataTable CardnoInfoTable = cancardnoIDAL.SelectRegisCardnoInfo(registCardno); //判断卡号是否存在 if (CardnoInfoTable.Rows.Count != 0)//不等于零说明,存在。 { //向CanCardno表插入数据 CanceCard carnCardno = new CanceCard(); carnCardno.StudentCardno = int.Parse(cardno); carnCardno.CanCash = double.Parse(CardnoInfoTable.Rows[0][1].ToString()); carnCardno.CanDate = DateTime.Now.Date; //充值日期 carnCardno.CanTime = DateTime.Now.ToShortTimeString(); //充值时间 carnCardno.OperationID = UserLevel.UserIdall; carnCardno.State = "未结账"; cancardnoIDAL.InsertCanCardno(carnCardno); //删除卡号信息 cancardnoIDAL.DeleteRegiscardnoInfo(registCardno); //删除登录表信息 UserLevel user = new UserLevel(); user.UserID = int.Parse(cardno); cancardnoIDAL.DeleteUserLoginCardnoInfo(user); //删除学生信息 StudentInfo student = new StudentInfo(); student.StudentCardno = int.Parse(cardno); cancardnoIDAL.DeleteStudentInfo(student); strMsger = "退卡成功!"; } else { strMsger = "卡号不存在,请重新输入!"; } #endregion } else { strMsger = "卡号请输入数字!"; } } else { strMsger = isNull; } return(strMsger); }