/// <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);
}
