/// <summary>
/// 新增一条质检记录
/// </summary>
/// <param name="qcRecord">质检实体</param>
/// <returns></returns>
public static bool InsertOneQCRecord(SMSConfigure qcRecord)
{
bool rbool = true;
using (DCQUALITYDataContext db = new DCQUALITYDataContext())
{
try
{
db.SMSConfigure.InsertOnSubmit(qcRecord);
db.SubmitChanges();
rbool = true;
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
/// <summary>
/// 单击保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
//获取选中人的姓名和电话
string name = "";
string Phon = "";
foreach (TreeNode tnTemp in tv_ReceivePhone.Nodes)
{
if (tnTemp.Checked == true)//选中的项
{
name += tnTemp.Text + ";";
Phon += tnTemp.Tag + ";";
}
}
if (string.IsNullOrEmpty(name))
{
MessageBox.Show("请选择人员号码！");
return;
}
//短信内容
if (cboUnusualType_Name.SelectedIndex < 0)
{
MessageBox.Show("请选择一项发送异常类型");
return;
}
string field = "";
string fieldTxt = "";
//取选中电话号码进行租和
//取选择的短信内容值 控件chb_SendContent
foreach (var item in chb_SendContent.CheckedItems)
{
//if (item.ToString() == "拆包前平均水分")
//{
// if (fieldTxt != "")
// {
// field += ",QCInfo_UnpackBefore_MOIST_PER_SAMPLE";
// fieldTxt += ",拆包前平均水分";
// }
// else
// {
// field += "QCInfo_UnpackBefore_MOIST_PER_SAMPLE";
// fieldTxt += "拆包前平均水分";
// }
//}
if (item.ToString() == "车牌号")
{
if (fieldTxt != "")
{
field += ",CNTR_NO";
fieldTxt += ",车牌号";
}
else
{
field += "CNTR_NO";
fieldTxt += "车牌号";
}
}
//if (item.ToString() == "拆包后平均水分")
//{
// if (fieldTxt != "")
// {
// field += ",QCInfo_UnpackBack_MOIST_PER_SAMPLE";
// fieldTxt += ",拆包后平均水分";
// }
// else
// {
// field += "QCInfo_UnpackBack_MOIST_PER_SAMPLE";
// fieldTxt += "拆包后平均水分";
// }
//}
if (item.ToString() == "货品")
{
if (fieldTxt != "")
{
field += ",PROD_ID";
fieldTxt += ",货品";
}
else
{
field += "PROD_ID";
fieldTxt += "货品";
}
}
if (item.ToString() == "参号")
{
if (fieldTxt != "")
{
field += ",REF_NO";
fieldTxt += ",参号";
}
else
{
fieldTxt += "参号";
}
}
//若继续加短信内容，在此处再写
}
//将字段组合保存到短信内容内
SMSConfigure SMSfIG = new SMSConfigure();
SMSfIG.SMSConfigure_Receive = name;
SMSfIG.SMSConfigure_ReceivePhone = Phon;
SMSfIG.SMSConfigure_SendContent = field;
SMSfIG.SMSConfigure_UnusualType_Id = null;
SMSfIG.SMSConfigure_TestItems_ID = Convert.ToInt32(cboUnusualType_Name.SelectedValue);
SMSfIG.SMSConfigure_Remark = txtRemark.Text.Trim();
SMSfIG.SMSConfigure_SendContentText = fieldTxt;
if (SMSConfigureDAL.InsertOneQCRecord(SMSfIG))
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
LoadData("");
}
