private bool ReadCard()
{
countTimes = 0;
countMoney = 0;
CardDepositLimit = 0;
CardDepositTimes = 0;
CardData10 = "";
CardDataH = "";
CardData8 = "";
EmpSysID = "";
if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8))
{
return(false);
}
pubData = new HSUNFK.TCardPubData();
sfData = new HSUNFK.TCardSFData();
if (!Pub.ReadCardInfo(ref pubData, ref sfData))
{
return(false);
}
if (!db.CheckCardExists(pubData.CardNo, CardData10))
{
return(false);
}
DateTime dt = new DateTime();
if (!db.GetServerDate(ref dt))
{
return(false);
}
if (!Pub.CheckCardValidDate(dt, pubData.CardBeginDate, pubData.CardEndDate))
{
return(false);
}
DataTableReader dr = null;
bool IsOk = false;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (!db.CheckDepartPowerByCard(pubData.CardNo))
{
return(false);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "215", pubData.CardNo }));
if (dr.Read())
{
if (Convert.ToInt32(dr["CardStatusID"]) != 20)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardDepositNotNormal", ""));
}
else
{
EmpSysID = dr["EmpSysID"].ToString();
txtEmpNo.Text = dr["EmpNo"].ToString();
txtEmpName.Text = dr["EmpName"].ToString();
txtDepartName.Text = dr["DepartName"].ToString();
txtCardSectorNo.Text = dr["CardSectorNo"].ToString();
txtCardStatusName.Text = dr["CardStatusName"].ToString();
txtCardType.Text = dr["CardTypeName"].ToString();
int.TryParse(dr["DepositDiscount"].ToString(), out Discount);
txtDepositDiscount.Text = Discount.ToString();
double.TryParse(dr["CardDepositLimit"].ToString(), out CardDepositLimit);
int.TryParse(dr["CardDepositTimes"].ToString(), out CardDepositTimes);
IsOk = true;
}
}
else
{
Pub.ShowErrorMsg(Pub.GetResText("", "ErrorIllegalCard", ""));
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsOk && SystemInfo.AllowCheckDepositLimit == 3)
{
IsOk = false;
try
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004013, new string[] { "200", EmpSysID }));
if (dr.Read())
{
double.TryParse(dr["SFAmount"].ToString(), out countMoney);
int.TryParse(dr["Times"].ToString(), out countTimes);
IsOk = true;
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
}
return(IsOk);
}
private bool ReadCard()
{
CardData10 = "";
CardDataH = "";
CardData8 = "";
if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8))
{
return(false);
}
pubData = new HSUNFK.TCardPubData();
sfData = new HSUNFK.TCardSFData();
if (!Pub.ReadCardInfo(ref pubData, ref sfData))
{
return(false);
}
if (!db.CheckCardExists(pubData.CardNo, CardData10))
{
return(false);
}
DateTime dt = new DateTime();
if (!db.GetServerDate(ref dt))
{
return(false);
}
if (!Pub.CheckCardValidDate(dt, pubData.CardBeginDate, pubData.CardEndDate))
{
return(false);
}
DataTableReader dr = null;
bool IsOk = false;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (!db.CheckDepartPowerByCard(pubData.CardNo))
{
return(false);
}
if (pubData.CardNo != GetCardNo())
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorCard", ""));
return(false);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "215", pubData.CardNo }));
if (dr.Read())
{
if (Convert.ToInt32(dr["CardStatusID"]) != 20)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardRefunNotNormal", ""));
}
else if (!Convert.ToBoolean(dr["CardRefundment"].ToString()))
{
Pub.ShowErrorMsg(string.Format(Pub.GetResText("", "ErrorCardRefundment", ""),
dr["CardTypeName"].ToString()));
}
else
{
IsOk = true;
}
}
else
{
Pub.ShowErrorMsg(Pub.GetResText("", "ErrorIllegalCard", ""));
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
return(IsOk);
}
private bool ReadCard(byte flag)
{
CardDepositLimit = 0;
CardDepositTimes = 0;
CardData10 = "";
CardDataH = "";
CardData8 = "";
if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8))
{
return(false);
}
pubData = new HSUNFK.TCardPubData();
sfData = new HSUNFK.TCardSFData();
if (!Pub.ReadCardInfo(ref pubData, ref sfData))
{
return(false);
}
if (!db.CheckCardExists(pubData.CardNo, CardData10))
{
return(false);
}
DateTime dt = new DateTime();
if (!db.GetServerDate(ref dt))
{
return(false);
}
if (!Pub.CheckCardValidDate(dt, pubData.CardBeginDate, pubData.CardEndDate))
{
return(false);
}
DataTableReader dr = null;
bool IsOk = false;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (!db.CheckDepartPowerByCard(pubData.CardNo))
{
return(false);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "215", pubData.CardNo }));
if (dr.Read())
{
if (Convert.ToInt32(dr["CardStatusID"]) != 20)
{
if (flag == 0)
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardDepositNotNormal", ""));
}
else
{
Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardRefunNotNormal", ""));
}
}
else if (flag != 0 && !Convert.ToBoolean(dr["CardRefundment"].ToString()))
{
Pub.ShowErrorMsg(string.Format(Pub.GetResText("", "ErrorCardRefundment", ""),
dr["CardTypeName"].ToString()));
}
else
{
IsOk = true;
if (flag == 0)
{
txtEmpNo.Text = dr["EmpNo"].ToString();
txtEmpName.Text = dr["EmpName"].ToString();
txtDepartName.Text = dr["DepartName"].ToString();
txtCardSectorNo.Text = dr["CardSectorNo"].ToString();
txtCardStatusName.Text = dr["CardStatusName"].ToString();
txtCardType.Text = dr["CardTypeName"].ToString();
int.TryParse(dr["DepositDiscount"].ToString(), out Discount);
txtDepositDiscount.Text = Discount.ToString();
double.TryParse(dr["CardDepositLimit"].ToString(), out CardDepositLimit);
int.TryParse(dr["CardDepositTimes"].ToString(), out CardDepositTimes);
}
else
{
if (ExistsDepositType)
{
string SFTypeName = "";
double SFAmount = 0;
IsOk = db.SFGetLastSFType(dr["EmpSysID"].ToString(), ref SFTypeName, ref SFAmount);
if (IsOk && (SFTypeName != ""))
{
txtUpDepositType.Text = SFTypeName + ":" + SFAmount.ToString(SystemInfo.CurrencySymbol + "0.00");
}
}
if (IsOk)
{
textBox8.Text = dr["EmpNo"].ToString();
textBox9.Text = dr["EmpName"].ToString();
textBox7.Text = dr["DepartName"].ToString();
textBox5.Text = dr["CardSectorNo"].ToString();
textBox6.Text = dr["CardStatusName"].ToString();
textBox4.Text = dr["CardTypeName"].ToString();
}
}
}
}
else
{
Pub.ShowErrorMsg(Pub.GetResText("", "ErrorIllegalCard", ""));
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
return(IsOk);
}
private bool ReadCard()
{
CardData10 = "";
CardDataH = "";
CardData8 = "";
if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8))
{
return(false);
}
pubData = new QHAPI.TCardPubData();
sfData = new QHAPI.TCardSFData();
if (!Pub.ReadCardInfo(ref pubData, ref sfData))
{
return(false);
}
if (!db.CheckCardExists(pubData.CardNo, CardData10))
{
return(false);
}
DateTime dt = new DateTime();
if (!db.GetServerDate(ref dt))
{
return(false);
}
if (!Pub.CheckCardValidDate(dt, pubData.CardBeginDate, pubData.CardEndDate))
{
return(false);
}
DataTableReader dr = null;
bool IsOk = false;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (!db.CheckDepartPowerByCard(pubData.CardNo))
{
return(false);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "215", pubData.CardNo }));
if (dr.Read())
{
if (Convert.ToInt32(dr["CardStatusID"]) != 20)
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardRefunNotNormal", ""));
}
else
{
IsOk = true;
if (SystemInfo.HasMoreDepositType)
{
string SFTypeName = "";
double SFAmount = 0;
IsOk = db.SFGetLastSFType(dr["EmpSysID"].ToString(), ref SFTypeName, ref SFAmount);
if (IsOk && (SFTypeName != ""))
{
txtCardBalanceBT.Text = SFTypeName + ":" + SFAmount.ToString(SystemInfo.CurrencySymbol + "0.00");
}
}
if (IsOk)
{
txtEmpNo.Text = dr["EmpNo"].ToString();
txtEmpName.Text = dr["EmpName"].ToString();
txtDepartName.Text = dr["DepartName"].ToString();
txtCardSectorNo.Text = dr["CardSectorNo"].ToString();
txtCardStatusName.Text = dr["CardStatusName"].ToString();
txtCardType.Text = dr["CardTypeName"].ToString();
}
}
}
else
{
Pub.MessageBoxShow(Pub.GetResText("", "ErrorIllegalCard", ""));
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
return(IsOk);
}
private bool ReadCard(bool IsWrite)
{
CardData10 = "";
CardDataH = "";
CardData8 = "";
if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8))
{
return(false);
}
pubData = new QHAPI.TCardPubData();
sfData = new QHAPI.TCardSFData();
if (!Pub.ReadCardInfo(ref pubData, ref sfData))
{
return(false);
}
if (!db.CheckCardExists(pubData.CardNo, CardData10))
{
return(false);
}
DateTime dt = new DateTime();
if (!db.GetServerDate(ref dt))
{
return(false);
}
if (!Pub.CheckCardValidDate(dt, pubData.CardBeginDate, pubData.CardEndDate))
{
return(false);
}
DataTableReader dr = null;
bool IsOk = false;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
if (!db.CheckDepartPowerByCard(pubData.CardNo))
{
return(false);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "215", pubData.CardNo }));
if (dr.Read())
{
if (Convert.ToInt32(dr["CardStatusID"]) != 20)
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardCostNotNormal", ""));
}
else
{
txtEmpNo.Text = dr["EmpNo"].ToString();
txtEmpName.Text = dr["EmpName"].ToString();
txtDepartName.Text = dr["DepartName"].ToString();
txtCardSectorNo.Text = dr["CardSectorNo"].ToString();
txtCardStatusName.Text = dr["CardStatusName"].ToString();
txtCardType.Text = dr["CardTypeName"].ToString();
IsOk = true;
}
}
else
{
Pub.MessageBoxShow(Pub.GetResText("", "ErrorIllegalCard", ""));
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
return(IsOk);
}