/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="qcRecord">质检实体</param>
/// <returns></returns>
public static bool InsertOneQCRecord(WeighStrategyRecord qcRecord)
{
bool rbool = true;
using (DCCarManagementDataContext db = new DCCarManagementDataContext())
{
try
{
rbool = LinQBaseDao.InsertOne(db, qcRecord);
}
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)
{
try
{
string iccard_id = txtSerialnumber.Text.Trim();
string txtinweight = txtInWeight.Text.ToString().Trim();
string txtoutweight = txtOutWeight.Text.ToString().Trim();
strsql();
if (sql == "")
{
MessageBox.Show("没有该IC卡(小票)号的信息！");
return;
}
DataTable table = LinQBaseDao.Query(sql).Tables[0];
if (table.Rows.Count > 0)
{
if (Convert.ToBoolean(table.Rows[0]["CarInOutRecord_ISFulfill"].ToString()))
{
MessageBox.Show("该车辆通行已完成！");
return;
}
if (ISFill(table) == false)
{
return;
}
string carinoutrecord = table.Rows[0]["CarInOutRecord_ID"].ToString();
string weight1 = "";
string weight2 = "";
string type = "";
DataTable tableB = LinQBaseDao.Query("select * from BusinessRecord where BusinessRecord_CarInOutRecord_ID=" + carinoutrecord).Tables[0];
for (int i = 0; i < tableB.Rows.Count; i++)
{
if (tableB.Rows[i]["BusinessRecord_Type"].ToString() == CommonalityEntity.upWeight)
{
weight1 = tableB.Rows[i]["BusinessRecord_Weight"].ToString();
}
if (tableB.Rows[i]["BusinessRecord_Type"].ToString() == CommonalityEntity.outWeight)
{
weight2 = tableB.Rows[i]["BusinessRecord_Weight"].ToString();
}
if (tableB.Rows[i]["BusinessRecord_Type"].ToString() == CommonalityEntity.loadSecondWeight || tableB.Rows[i]["BusinessRecord_Type"].ToString() == CommonalityEntity.unloadSecondWeight)
{
type = tableB.Rows[i]["BusinessRecord_Type"].ToString();
}
}
//对地磅策略判断 该磅房信息
if (Convert.ToInt32(cobWeighStrategyRecord.SelectedValue) < 1)
{
MessageBox.Show("请选择此磅房名称");
return;
}
if (!WeighStrategyIf())
{
return;
}
//判断进门地磅是否重复记录,如果原记录重量不等于现在输入的重量则提示是否修改
if (txtinweight != "" && weight1 != txtinweight)
{
DataTable dtbus = LinQBaseDao.Query("select * from BusinessRecord where BusinessRecord_Type='" + CommonalityEntity.upWeight + "' and BusinessRecord_CarInOutRecord_ID=" + carinoutrecord).Tables[0];
if (dtbus.Rows.Count > 0)
{
if (MessageBox.Show("是否修改进门地磅重量？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
LinQBaseDao.Query(" update BusinessRecord set BusinessRecord_Weight=" + txtinweight + " where BusinessRecord_CarInOutRecord_ID=" + carinoutrecord + " and BusinessRecord_Type='" + CommonalityEntity.upWeight + "'");
}
else
{
return;
}
}
else
{
string content = table.Rows[0]["CarInfo_PO"].ToString();
save(carinoutrecord, content, CommonalityEntity.upWeight, txtinweight);
MessageBox.Show("保存成功！");
CommonalityEntity.strCardNo = "";
CommonalityEntity.WriteLogData("记录", "记录IC卡(小票)号为：" + txtSerialnumber.Text.Trim() + "的进门过磅信息", CommonalityEntity.USERNAME);//添加操作日志
//记录地磅策略已通过
record = new WeighStrategyRecord();//txtCarregistration_Carnumber
record.WeighStrategyRecord_WeighInfo_ID = Convert.ToInt32(cobWeighStrategyRecord.SelectedValue);
record.WeighStrategyRecord_StaffInfo_ID = Convert.ToInt32(txtCarregistration_Name.Tag.ToString());
record.WeighStrategyRecord_CarInfo_ID = Convert.ToInt32(txtCarregistration_Carnumber.Tag.ToString());
record.WeighStrategyRecord_Carnumber = txtCarregistration_Carnumber.Text.Trim();
record.WeighStrategyRecord_StaffInfo_Name = txtCarregistration_Name.Text.Trim();
record.WeighStrategyRecord_CarType = txtCartype_Name.Text.Trim();
record.WeighStrategyRecord_mark = true;
record.WeighStrategyRecord_RecordTime = CommonalityEntity.GetServersTime();
record.WeighStrategyRecord_Name = cobWeighStrategyRecord.Text.Trim();
record.WeighStrategyRecord_order = RraderSort;
record.WeighStrategyRecord_Remark = txtRemark.Text.Trim();
if (!WeighStrategyRecordDAL.InsertOneQCRecord(record))
{
// MessageBox.Show("地磅房策略通行记录失败！");
}
}
}
//判断出门地磅是否重复记录，如果原记录重量不等于现在输入的重量则提示是否修改
if (txtoutweight != "" && weight2 != txtoutweight)
{
DataTable ds = LinQBaseDao.Query("select * from BusinessRecord where BusinessRecord_Type='" + CommonalityEntity.outWeight + "' and BusinessRecord_CarInOutRecord_ID=" + carinoutrecord + " order by BusinessRecord_ID desc").Tables[0];
if (ds.Rows.Count > 0)
{
if (MessageBox.Show("是否修改出门地磅重量？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
LinQBaseDao.Query(" update BusinessRecord set BusinessRecord_Weight=" + txtoutweight + " where BusinessRecord_CarInOutRecord_ID=" + carinoutrecord + " and BusinessRecord_Type='" + CommonalityEntity.outWeight + "'");
}
else
{
return;
}
}
else
{
if (type == CommonalityEntity.loadSecondWeight || type == CommonalityEntity.unloadSecondWeight)
{
string carinfo_po = table.Rows[0]["CarInfo_PO"].ToString();
save(carinoutrecord, carinfo_po, CommonalityEntity.outWeight, txtoutweight);
MessageBox.Show("保存成功！");
CommonalityEntity.strCardNo = "";
CommonalityEntity.WriteLogData("记录", "记录IC卡(小票)号为：" + txtSerialnumber.Text.Trim() + "的" + CommonalityEntity.outWeight + "信息", CommonalityEntity.USERNAME);//添加操作日志
//记录地磅策略已通过
record = new WeighStrategyRecord();
record.WeighStrategyRecord_WeighInfo_ID = Convert.ToInt32(cobWeighStrategyRecord.SelectedValue);
record.WeighStrategyRecord_StaffInfo_ID = Convert.ToInt32(txtCarregistration_Name.Tag.ToString());
record.WeighStrategyRecord_CarInfo_ID = Convert.ToInt32(txtCarregistration_Carnumber.Tag.ToString());
record.WeighStrategyRecord_Carnumber = txtCarregistration_Carnumber.Text.Trim();
record.WeighStrategyRecord_StaffInfo_Name = txtCarregistration_Name.Text.Trim();
record.WeighStrategyRecord_CarType = txtCartype_Name.Text.Trim();
record.WeighStrategyRecord_mark = true;
record.WeighStrategyRecord_RecordTime = CommonalityEntity.GetServersTime();
record.WeighStrategyRecord_Name = cobWeighStrategyRecord.Text.Trim();
record.WeighStrategyRecord_order = RraderSort;
record.WeighStrategyRecord_Remark = txtRemark.Text.Trim();
if (!WeighStrategyRecordDAL.InsertOneQCRecord(record))
{
//MessageBox.Show("地磅房策略通行记录失败！");
}
}
else
{
MessageBox.Show("没有装卸货点第二次过磅重量");
txtOutWeight.Text = "";
return;
}
}
}
}
}
catch
{
CommonalityEntity.WriteTextLog("地磅房信息 btnSave_Click()");
}
}
