private void send_sms_thread()
{
try
{
var phones = IOUtil.read_file(ConfigKeys.KEY_PHONES_FILE);
if (phones.Count == 0)
{
return;
}
smsPort = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSPORT);
smsBaud = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSBAUD);
if (smsPort == "" || smsBaud == "")
{
SMmsForm smsForm = new SMmsForm();
if (smsForm.ShowDialog() != DialogResult.OK)
{
return;
}
smsPort = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSPORT);
smsBaud = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSBAUD);
}
if (smsPort == "" || smsBaud == "")
{
return;
}
var dao = new DAO(LogIn.connectionString);
var dts = dao.get_last_index_clear_time(2);
DateTime st = DateTime.Parse("2013-01-01 00:00:00");
DateTime et = dts[0].Value;
if (dts.Count == 2)
{
st = dts[1].Value;
}
string sms_msg = dao.get_sms_msg(st, et);
send_SMS(phones, sms_msg);
}
catch
{
}
}
private void send_sms(string cardno)
{
try
{
//var dc = new BathDBDataContext(LogIn.connectionString);
var ci = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == cardno);
if (ci.CI_Telephone == null || ci.CI_Telephone.Length != 11)
{
return;
}
var mt = db.MemberType.FirstOrDefault(x => x.id == ci.CI_CardTypeNo);
if (!BathClass.ToBool(mt.smsAfterUsing))
{
return;
}
string msg = "尊敬的贵宾，您好！";
msg += "您的" + mt.name + "，卡号：" + ci.CI_CardNo + "，";
var cc = db.CardCharge.Where(y => y.CC_CardNo == ci.CI_CardNo);
var debit = cc.Sum(y => y.CC_DebitSum);
var lend = cc.Sum(y => y.CC_LenderSum);
var cu = db.MemberSetting.FirstOrDefault().money;
var balance_money = Convert.ToDouble(debit - lend);
msg += "余额为：" + balance_money.ToString();
if (mt.credits)
{
var cexpense = db.CardCharge.Where(y => y.CC_CardNo == ci.CI_CardNo);
var cvs = cexpense.Sum(y => y.expense);
if (cvs.HasValue)
{
double cds = cvs.Value;
if (ci.CI_CreditsUsed == null)
{
msg += "积分为：" + (cds / cu).ToString();
}
else
{
msg += "积分为：" + (cds / cu - ci.CI_CreditsUsed).ToString();
}
}
}
String TypeStr = "";
String CopyRightToCOM = "";
String CopyRightStr = "//上海迅赛信息技术有限公司,网址www.xunsai.com//";
string smsPort = BathClass.get_config_by_key("smsPort");
string smsBaud = BathClass.get_config_by_key("smsBaud");
if (smsPort == "" || smsBaud == "")
{
SMmsForm smsForm = new SMmsForm();
if (smsForm.ShowDialog() != DialogResult.OK)
{
return;
}
smsPort = BathClass.get_config_by_key("smsPort");
smsBaud = BathClass.get_config_by_key("smsBaud");
}
if (smsPort == "" || smsBaud == "")
{
return;
}
//SmsClass.Sms_Disconnection();
if (SmsClass.Sms_Connection(CopyRightStr, uint.Parse(smsPort[3].ToString()), uint.Parse(smsBaud), out TypeStr, out CopyRightToCOM) != 1)
{
return;
}
SmsClass.Sms_Send(ci.CI_Telephone, msg);
SmsClass.Sms_Disconnection();
}
catch
{}
}
private void send_sms(string cardno)
{
try
{
//var dc = new BathDBDataContext(LogIn.connectionString);
var ci = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == cardno);
if (ci.CI_Telephone == null || ci.CI_Telephone.Length != 11)
return;
var mt = db.MemberType.FirstOrDefault(x => x.id == ci.CI_CardTypeNo);
if (!BathClass.ToBool(mt.smsAfterUsing))
return;
string msg = "尊敬的贵宾，您好！";
msg += "您的" + mt.name + "，卡号：" + ci.CI_CardNo + "，";
var cc = db.CardCharge.Where(y => y.CC_CardNo == ci.CI_CardNo);
var debit = cc.Sum(y => y.CC_DebitSum);
var lend = cc.Sum(y => y.CC_LenderSum);
var cu = db.MemberSetting.FirstOrDefault().money;
var balance_money = Convert.ToDouble(debit - lend);
msg += "余额为：" + balance_money.ToString();
if (mt.credits)
{
var cexpense = db.CardCharge.Where(y => y.CC_CardNo == ci.CI_CardNo);
var cvs = cexpense.Sum(y => y.expense);
if (cvs.HasValue)
{
double cds = cvs.Value;
if (ci.CI_CreditsUsed == null)
msg += "积分为：" + (cds / cu).ToString();
else
msg += "积分为：" + (cds / cu - ci.CI_CreditsUsed).ToString();
}
}
String TypeStr = "";
String CopyRightToCOM = "";
String CopyRightStr = "//上海迅赛信息技术有限公司,网址www.xunsai.com//";
string smsPort = BathClass.get_config_by_key("smsPort");
string smsBaud = BathClass.get_config_by_key("smsBaud");
if (smsPort == "" || smsBaud == "")
{
SMmsForm smsForm = new SMmsForm();
if (smsForm.ShowDialog() != DialogResult.OK)
return;
smsPort = BathClass.get_config_by_key("smsPort");
smsBaud = BathClass.get_config_by_key("smsBaud");
}
if (smsPort == "" || smsBaud == "")
return;
//SmsClass.Sms_Disconnection();
if (SmsClass.Sms_Connection(CopyRightStr, uint.Parse(smsPort[3].ToString()), uint.Parse(smsBaud), out TypeStr, out CopyRightToCOM) != 1)
return;
SmsClass.Sms_Send(ci.CI_Telephone, msg);
SmsClass.Sms_Disconnection();
}
catch
{}
}
private void ToolSmsSet_Click(object sender, EventArgs e)
{
SMmsForm smsForm = new SMmsForm();
smsForm.ShowDialog();
}
private void send_sms_thread()
{
try
{
var phones = IOUtil.read_file(ConfigKeys.KEY_PHONES_FILE);
if (phones.Count == 0)
return;
smsPort = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSPORT);
smsBaud = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSBAUD);
if (smsPort == "" || smsBaud == "")
{
SMmsForm smsForm = new SMmsForm();
if (smsForm.ShowDialog() != DialogResult.OK)
return;
smsPort = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSPORT);
smsBaud = IOUtil.get_config_by_key(ConfigKeys.KEY_SMSBAUD);
}
if (smsPort == "" || smsBaud == "")
return;
var dao = new DAO(LogIn.connectionString);
var dts = dao.get_last_index_clear_time(2);
DateTime st = DateTime.Parse("2013-01-01 00:00:00");
DateTime et = dts[0].Value;
if (dts.Count == 2)
st = dts[1].Value;
string sms_msg = dao.get_sms_msg(st, et);
send_SMS(phones,sms_msg);
}
catch
{
}
}
private void ToolSmsSet_Click(object sender, EventArgs e)
{
SMmsForm smsForm = new SMmsForm();
smsForm.ShowDialog();
}