private void btnAdd_Click(object sender, EventArgs e) { if (!CheckDate_ADD()) { return; } m_listDebitSchedule = (dataGridView1.DataSource as BindingCollection <View_S_DebitSchedule>).ToList(); View_S_DebitSchedule tempLnq = new View_S_DebitSchedule(); tempLnq.单据号 = txtSDBNo.Text; tempLnq.规格 = txtSpec.Text; tempLnq.图号型号 = txtCode.Text; tempLnq.物品ID = (int)txtCode.Tag; tempLnq.物品名称 = txtName.Text; tempLnq.总成编码 = txtEditionCode.Text; tempLnq.基数 = numRedices.Value; tempLnq.适用范围 = cmbApplicable.Text; tempLnq.一次性整台份发料 = chbOnceTheWholeIssue.Checked; m_listDebitSchedule.Add(tempLnq); RefreshDataGridView(m_listDebitSchedule); }
private void txtEditionCode_OnCompleteSearch() { if (cmbApplicable.Text.Length == 0) { MessageDialog.ShowPromptMessage("请先选择适用范围"); txtEditionCode.Text = ""; txtEditionCode.Tag = null; return; } if (txtEditionCode.DataResult == null) { return; } txtEditionCode.Text = txtEditionCode.DataResult["图号型号"].ToString(); if (lbSDBStatus.Text == ProductOrderListStatus.新建单据.ToString()) { m_listDebitSchedule = new List <View_S_DebitSchedule>(); DataTable tempTable = m_findProductOrder.GetAllData(txtEditionCode.Text.ToString(), GlobalObject.GeneralFunction.StringConvertToEnum <CE_DebitScheduleApplicable>(cmbApplicable.Text)); foreach (DataRow dr in tempTable.Rows) { View_S_DebitSchedule tempLnq = new View_S_DebitSchedule(); tempLnq.单据号 = txtSDBNo.Text; tempLnq.规格 = dr["规格"].ToString(); tempLnq.基数 = (decimal)dr["基数"]; tempLnq.图号型号 = dr["零件编码"].ToString(); tempLnq.物品ID = (int)dr["物品ID"]; tempLnq.物品名称 = dr["零件名称"].ToString(); tempLnq.总成编码 = dr["产品编码"].ToString(); tempLnq.适用范围 = dr["适用范围"].ToString(); tempLnq.一次性整台份发料 = Convert.ToBoolean(dr["一次性整台份发料"]); m_listDebitSchedule.Add(tempLnq); } RefreshDataGridView(m_listDebitSchedule); } }
void SetTempSource() { m_listDebitSchedule_Temp = new List <View_S_DebitSchedule>(); foreach (View_S_DebitSchedule item in m_listDebitSchedule) { View_S_DebitSchedule tempLnq = new View_S_DebitSchedule(); tempLnq.单据号 = item.单据号; tempLnq.规格 = item.规格; tempLnq.基数 = item.基数; tempLnq.图号型号 = item.图号型号; tempLnq.物品ID = item.物品ID; tempLnq.物品名称 = item.物品名称; tempLnq.总成编码 = item.总成编码; tempLnq.适用范围 = item.适用范围; tempLnq.一次性整台份发料 = item.一次性整台份发料; m_listDebitSchedule_Temp.Add(tempLnq); } }
private void btn_Import_Click(object sender, EventArgs e) { //string error = ""; DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1); if (dtTemp == null) { //MessageDialog.ShowPromptMessage(error); return; } if (!dtTemp.Columns.Contains("图号型号")) { MessageDialog.ShowPromptMessage("无【图号型号】列"); } if (!dtTemp.Columns.Contains("物品名称")) { MessageDialog.ShowPromptMessage("无【物品名称】列"); } if (!dtTemp.Columns.Contains("规格")) { MessageDialog.ShowPromptMessage("无【规格】列"); } if (!dtTemp.Columns.Contains("基数")) { MessageDialog.ShowPromptMessage("无【基数】列"); } if (!dtTemp.Columns.Contains("一次性整台份发料")) { MessageDialog.ShowPromptMessage("无【一次性整台份发料】列"); } m_listDebitSchedule = new List <View_S_DebitSchedule>(); foreach (DataRow dr in dtTemp.Rows) { View_S_DebitSchedule tempLnq = new View_S_DebitSchedule(); int goodsID = UniversalFunction.GetGoodsID(dr["图号型号"].ToString(), dr["物品名称"].ToString(), dr["规格"].ToString()); if (goodsID != 0) { tempLnq.物品ID = goodsID; foreach (View_S_DebitSchedule item in m_listDebitSchedule) { if (item.物品ID == tempLnq.物品ID) { MessageDialog.ShowPromptMessage(UniversalFunction.GetGoodsMessage(tempLnq.物品ID) + "已存在一条记录,不能插入重复记录"); } } } else { MessageDialog.ShowPromptMessage("图号:" + dr["图号型号"].ToString() + " 名称:" + dr["物品名称"].ToString() + " 规格:" + dr["规格"].ToString() + " 不存在于系统中"); return; } if (dr["基数"] == null || Convert.ToInt32(dr["基数"]) == 0) { MessageDialog.ShowPromptMessage("图号:" + dr["图号型号"].ToString() + " 名称:" + dr["物品名称"].ToString() + " 规格:" + dr["规格"].ToString() + " 【基数】不符合要求,请重新检查"); } else { tempLnq.基数 = Convert.ToDecimal(dr["基数"]); } if (dr["一次性整台份发料"] == null) { MessageDialog.ShowPromptMessage("图号:" + dr["图号型号"].ToString() + " 名称:" + dr["物品名称"].ToString() + " 规格:" + dr["规格"].ToString() + " 【一次性整台份发料】不符合要求,请重新检查"); } else { tempLnq.一次性整台份发料 = dr["一次性整台份发料"].ToString().Trim() == "是" ? true : false; } tempLnq.单据号 = txtSDBNo.Text; tempLnq.规格 = dr["规格"].ToString(); tempLnq.图号型号 = dr["图号型号"].ToString(); tempLnq.物品名称 = dr["物品名称"].ToString(); tempLnq.总成编码 = txtEditionCode.Text; tempLnq.适用范围 = cmbApplicable.Text; m_listDebitSchedule.Add(tempLnq); } RefreshDataGridView(m_listDebitSchedule); MessageDialog.ShowPromptMessage("导入完成"); }