/// <summary>
/// 编辑业务信息
/// </summary>
/// <param name="record">LNQ业务信息集合</param>
public void EditInfo(ZL_Database_Record record)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
try
{
if (record == null)
{
throw new Exception("录入数据为空");
}
var varData = from a in ctx.ZL_Database_Record
where a.BillNo == record.BillNo
select a;
if (varData == null || varData.Count() == 0)
{
record.CreationTime = ServerTime.Time;
ctx.ZL_Database_Record.InsertOnSubmit(record);
}
else if (varData.Count() == 1)
{
ZL_Database_Record tempLnq = varData.Single();
tempLnq.AssemblyCartonNo = record.AssemblyCartonNo;
tempLnq.CauseAnalysis = record.CauseAnalysis;
tempLnq.FaultRatio = record.FaultRatio;
tempLnq.Provider = record.Provider;
tempLnq.FaultDescription = record.FaultDescription;
tempLnq.FaultType = record.FaultType;
tempLnq.Finder = record.Finder;
tempLnq.FindPlaces = record.FindPlaces;
tempLnq.FindRole = record.FindRole;
tempLnq.GoodsCode = record.GoodsCode;
tempLnq.GoodsName = record.GoodsName;
tempLnq.Spec = record.Spec;
tempLnq.Mileage = record.Mileage;
tempLnq.Model = record.Model;
tempLnq.OccurrenceTime = record.OccurrenceTime;
tempLnq.TreatmentCountermeasures = record.TreatmentCountermeasures;
tempLnq.Type = record.Type;
tempLnq.Version = record.Version;
}
else
{
throw new Exception("相应的单据信息不唯一");
}
ctx.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void 质量数据库信息显示界面_FormClosing(object sender, FormClosingEventArgs e)
{
string billNo = txtBillNo.Text;
ZL_Database_Record record = m_serverQylityDatabase.GetSingleInfo(billNo);
if (record == null)
{
DataTable tempTable = m_serverQylityDatabase.GetAllFileStruct(null, billNo);
if (tempTable != null)
{
foreach (DataRow dr in tempTable.Rows)
{
m_serverQylityDatabase.DeleteFilesStruct(dr["ID"].ToString());
}
}
}
}
/// <summary>
/// 获取信息
/// </summary>
void GetInfo()
{
m_lnqRecord = new ZL_Database_Record();
m_lnqRecord.AssemblyCartonNo = txtAssemblyCartonNo.Text;
m_lnqRecord.BillNo = txtBillNo.Text;
m_lnqRecord.CauseAnalysis = txtCauseAnalysis.Text;
m_lnqRecord.FaultRatio = cmbFaultRatio.Text;
m_lnqRecord.Provider = txtProvider.Text;
m_lnqRecord.FaultDescription = txtFaultDescription.Text;
m_lnqRecord.FaultType = txtFaultType.Text;
m_lnqRecord.Finder = txtFinder.Text;
m_lnqRecord.FindPlaces = cmbFindPlaces.Text;
m_lnqRecord.FindRole = cmbFindRole.Text;
m_lnqRecord.GoodsCode = txtGoodsCode.Text;
m_lnqRecord.GoodsName = txtGoodsName.Text;
m_lnqRecord.Spec = txtSpec.Text;
m_lnqRecord.Mileage = numMileage.Value;
m_lnqRecord.Model = cmbModel.Text;
m_lnqRecord.OccurrenceTime = Convert.ToDateTime(dtpOccurrenceTime.Value.ToShortDateString());
m_lnqRecord.TreatmentCountermeasures = txtTreatmentCountermeasures.Text;
m_lnqRecord.Type = cmbType.Text;
m_lnqRecord.Version = txtVersion.Text;
}
private void txtInport_Click(object sender, EventArgs e)
{
if (openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
try
{
CursorControl.SetWaitCursor(this);
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1.OpenFile());
if (dtTemp == null)
{
MessageDialog.ShowPromptMessage(m_strError);
return;
}
if (CheckTable(dtTemp))
{
List <ZL_Database_Record> listRecord = new List <ZL_Database_Record>();
foreach (DataRow dr in dtTemp.Rows)
{
if (dr["序列号"].ToString().Trim().Length == 0)
{
continue;
}
ZL_Database_Record m_lnqRecord = new ZL_Database_Record();
m_lnqRecord.BillNo = openFileDialog1.FileName.Substring(0, openFileDialog1.FileName.LastIndexOf("\\") + 1) + dr["序列号"].ToString().Trim();
m_lnqRecord.CreationTime = ServerTime.Time;
m_lnqRecord.AssemblyCartonNo = dr["总成箱号"].ToString().Trim();
m_lnqRecord.CauseAnalysis = dr["原因分析"].ToString().Trim();
m_lnqRecord.FaultRatio = dr["故障比例"].ToString().Trim();
m_lnqRecord.Provider = dr["供应商"].ToString().Trim();
m_lnqRecord.FaultDescription = dr["故障描述"].ToString().Trim();
m_lnqRecord.FaultType = dr["故障类型"].ToString().Trim();
m_lnqRecord.Finder = dr["发现人员"].ToString().Trim();
m_lnqRecord.FindPlaces = dr["发现场所"].ToString().Trim();
m_lnqRecord.FindRole = dr["发现者"].ToString().Trim();
m_lnqRecord.GoodsCode = dr["图号型号"].ToString().Trim();
m_lnqRecord.GoodsName = dr["物品名称"].ToString().Trim();
m_lnqRecord.Spec = dr["规格"].ToString().Trim();
m_lnqRecord.Mileage = dr["行驶里程"].ToString().Trim() == "" ? 0 : Convert.ToDecimal(dr["行驶里程"].ToString().Trim());
m_lnqRecord.Model = dr["型号"].ToString().Trim();
m_lnqRecord.OccurrenceTime = dr["发生时间"].ToString().Trim() == ""? null :
(DateTime?)Convert.ToDateTime(dr["发生时间"].ToString().Trim());
m_lnqRecord.TreatmentCountermeasures = dr["处理对策"].ToString().Trim();
m_lnqRecord.Type = dr["不良品类型"].ToString().Trim();
m_lnqRecord.Version = dr["版次"].ToString().Trim();
listRecord.Add(m_lnqRecord);
}
m_serverQylityDatabase.BatchInportInfo(listRecord);
MessageDialog.ShowPromptMessage("导入成功");
}
this.Cursor = System.Windows.Forms.Cursors.Arrow;
}
catch (Exception ex)
{
MessageDialog.ShowErrorMessage(ex.Message);
this.Cursor = System.Windows.Forms.Cursors.Arrow;
}
btnRefresh_Click(null, null);
}
private void 质量数据库信息显示界面_Load(object sender, EventArgs e)
{
m_lnqRecord = m_serverQylityDatabase.GetSingleInfo(txtBillNo.Text);
ShowInfo();
}
