public CMemberType get_MemberType(string cmd_str)
{
CMemberType memberType = null;
SqlConnection sqlCn = null;
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
cmd_str = "Select * from [MemberType] where (" + cmd_str + ")";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
memberType = new CMemberType();
memberType.id = (int)dr["id"];
memberType.name = dr["name"].ToString();
memberType.timSpan = dr["timSpan"].ToString();
memberType.times = ToInt(dr["times"]);
memberType.money = ToDouble(dr["money"]);
memberType.maxOpenMoney = ToDouble(dr["maxOpenMoney"]);
memberType.expireDate = ToDateTime(dr["expireDate"]);
memberType.offerId = ToInt(dr["offerId"]);
memberType.credits = (bool)dr["credits"];
memberType.smsAfterUsing = ToBool(dr["smsAfterUsing"]);
memberType.userOneTimeOneDay = ToBool(dr["userOneTimeOneDay"]);
memberType.LimitedTimesPerMonth = ToBool(dr["LimitedTimesPerMonth"]);
memberType.TimesPerMonth = ToInt(dr["TimesPerMonth"]);
break;
}
}
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return memberType;
}
//获取会员卡
private void get_member()
{
string card_data = "";
string company_code = LogIn.options.companyCode;
bool st = false;
if (cardType == "SLE4442")
st = ICCard.read_data_4442(company_code, ref card_data);
else if (cardType == "M1")
st = ICCard.read_data_M1(company_code, ref card_data);
else if (cardType == "CT")
{
card_data = id.Text;
st = true;
}
if (!st)
return;
//card_data = "000000";
m_member = dao.get_CardInfo("CI_CardNo='" + card_data + "'");
if (m_member == null)
{
BathClass.printErrorMsg("非本公司卡!");
return;
}
id.Text = m_member.CI_CardNo;
name.Text = m_member.CI_Name;
phone.Text = m_member.CI_Telephone;
cmemberType = dao.get_MemberType("id='" + m_member.CI_CardTypeNo + "'");
if (memberType != null)
memberType.Text = cmemberType.name;
var cc = dao.get_CardCharges("CC_CardNo='" + m_member.CI_CardNo + "'");
double debit = MConvert<int>.ToTypeOrDefault(cc.Sum(x => x.CC_DebitSum), 0);
double lend = MConvert<int>.ToTypeOrDefault(cc.Sum(x => x.CC_LenderSum), 0);
balance.Text = (debit - lend).ToString();
var c = MConvert<int>.ToTypeOrDefault(m_member.CI_CreditsUsed, 0);
var cu = MConvert<int>.ToTypeOrDefault(memberSetting.money, 0);
int cs = (int)(lend / cu - c);
credits.Text = cs.ToString();
btnOk.Text = "会员打折";
}