private void dgvMaterials_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { string strPId = frmPart.PartsID; DataTable dpt = DBHelper.GetTable("", "v_parts_chooser", "*", " parts_id='" + strPId + "'", "", ""); if (dpt.Rows.Count > 0) { DataRow dpr = dpt.Rows[0]; dgvMaterials.Rows[e.RowIndex].Cells["parts_code"].Value = CommonCtrl.IsNullToString(dpr["ser_parts_code"]); dgvMaterials.Rows[e.RowIndex].Cells["parts_name"].Value = CommonCtrl.IsNullToString(dpr["parts_name"]); dgvMaterials.Rows[e.RowIndex].Cells["unit"].Value = CommonCtrl.IsNullToString(dpr["unit"]); dgvMaterials.Rows[e.RowIndex].Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dpr["drawing_num"]); dgvMaterials.Rows[e.RowIndex].Cells["quantity"].Value = "0"; string unit_price = CommonCtrl.IsNullToString(dpr["retail"]); dgvMaterials.Rows[e.RowIndex].Cells["unit_price"].Value = !string.IsNullOrEmpty(unit_price)?unit_price:"0"; dgvMaterials.Rows[e.RowIndex].Cells["norms"].Value = CommonCtrl.IsNullToString(dpr["model"]); dgvMaterials.Rows[e.RowIndex].Cells["inventory_num"].Value = CommonCtrl.IsNullToString(dpr["paper_count"]); dgvMaterials.Rows.Add(1); } } }
private void dgvMaterials_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { string strPId = frmPart.PartsID; DataTable dpt = DBHelper.GetTable("", "v_parts", "*", " parts_id='" + strPId + "'", "", ""); if (dpt.Rows.Count > 0) { DataRow dpr = dpt.Rows[0]; dgvMaterials.Rows[e.RowIndex].Cells["parts_code"].Value = CommonCtrl.IsNullToString(dpr["ser_parts_code"]); dgvMaterials.Rows[e.RowIndex].Cells["parts_name"].Value = CommonCtrl.IsNullToString(dpr["parts_name"]); dgvMaterials.Rows[e.RowIndex].Cells["norms"].Value = CommonCtrl.IsNullToString(dpr["model"]); dgvMaterials.Rows[e.RowIndex].Cells["unit"].Value = CommonCtrl.IsNullToString(dpr["default_unit_name"]); dgvMaterials.Rows[e.RowIndex].Cells["whether_imported"].Value = CommonCtrl.IsNullToString(dpr["is_import"]) == "1" ? "是" : "否"; dgvMaterials.Rows[e.RowIndex].Cells["quantity"].Value = "1"; dgvMaterials.Rows[e.RowIndex].Cells["unit_price"].Value = CommonCtrl.IsNullToString(dpr["highest_out_price"]); string strNum = CommonCtrl.IsNullToString(dgvMaterials.Rows[e.RowIndex].Cells["quantity"].Value); string strUMoney = !string.IsNullOrEmpty(CommonCtrl.IsNullToString(dgvMaterials.Rows[e.RowIndex].Cells["unit_price"].Value)) ? CommonCtrl.IsNullToString(dgvMaterials.Rows[e.RowIndex].Cells["unit_price"].Value) : "0"; dgvMaterials.Rows[e.RowIndex].Cells["Msum_money"].Value = Convert.ToString(Convert.ToDecimal(strNum) * Convert.ToDecimal(strUMoney = strUMoney == "" ? "0" : strUMoney)); dgvMaterials.Rows[e.RowIndex].Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dpr["drawing_num"]); dgvMaterials.Rows[e.RowIndex].Cells["vehicle_model"].Value = CommonCtrl.IsNullToString(dpr["v_brand_name"]); dgvMaterials.Rows[e.RowIndex].Cells["Mremarks"].Value = CommonCtrl.IsNullToString(dpr["remark"]); dgvMaterials.Rows[e.RowIndex].Cells["M_Id"].Value = frmPart.PartsID; dgvMaterials.Rows.Add(1); } } }
private void dgvMaterials_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { string strPId = frmPart.PartsID; DataTable dpt = DBHelper.GetTable("", "v_parts_chooser", "*", " parts_id='" + strPId + "'", "", ""); if (dpt.Rows.Count > 0) { DataRow dpr = dpt.Rows[0]; dgvMaterials.Rows[e.RowIndex].Cells["parts_code"].Value = CommonCtrl.IsNullToString(dpr["ser_parts_code"]); dgvMaterials.Rows[e.RowIndex].Cells["parts_name"].Value = CommonCtrl.IsNullToString(dpr["parts_name"]); dgvMaterials.Rows[e.RowIndex].Cells["unit"].Value = CommonCtrl.IsNullToString(dpr["unit"]); dgvMaterials.Rows[e.RowIndex].Cells["inventory_num"].Value = CommonCtrl.IsNullToString(dpr["paper_count"]); dgvMaterials.Rows[e.RowIndex].Cells["quantity"].Value = "1"; //dgvMaterials.Rows[e.RowIndex].Cells["whether_imported"].Value = CommonCtrl.IsNullToString(dpr["is_import"]) == "1" ? "是" : "否"; dgvMaterials.Rows[e.RowIndex].Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dpr["drawing_num"]); dgvMaterials.Rows[e.RowIndex].Cells["vehicle_brand"].Value = CommonCtrl.IsNullToString(dpr["brand_name"]); dgvMaterials.Rows.Add(1); } } }
//配件选择 private void txtcparts_code_ChooserClick(object sender, EventArgs e) { frmParts parts = new frmParts(); if (parts.ShowDialog() == DialogResult.OK) { txtcparts_code.Text = parts.PartsCode; txtPartsName.Caption = parts.PartsName; } }
//配件选择器 private void txtcPartsCode_ChooserClick(object sender, EventArgs e) { frmParts frmPartsChooser = new frmParts(); if (frmPartsChooser.ShowDialog() == DialogResult.OK) { txtcPartsCode.Text = frmPartsChooser.PartsCode; txtPartsName.Caption = frmPartsChooser.PartsName; } }
/// <summary> 选择配件名称 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtparts_name_ChooserClick(object sender, EventArgs e) { frmParts chooseParts = new frmParts(); chooseParts.ShowDialog(); if (!string.IsNullOrEmpty(chooseParts.PartsID)) { txtparts_name.Text = chooseParts.PartsName; } }
/// <summary> /// 选择配件编码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtparts_code_ChooserClick(object sender, EventArgs e) { //显示配件选择窗口 frmParts chooseParts = new frmParts(); chooseParts.ShowDialog(); if (!string.IsNullOrEmpty(chooseParts.PartsID)) { txtparts_code.Text = chooseParts.PartsCode; } }
/// <summary> /// 配件编码选择器事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtPartsCode_ChooserClick(object sender, EventArgs e) { frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { txtPartsCode.Text = frmPart.PartsCode; txtPartsCode.Tag = frmPart.PartsID; txtPartsName.Caption = frmPart.PartsName; } }
/// <summary> 选择配件编码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtparts_code2_ChooserClick(object sender, EventArgs e) { frmParts chooseParts = new frmParts(); chooseParts.ShowDialog(); this.Refresh(); if (!string.IsNullOrEmpty(chooseParts.PartsID)) { txtparts_code2.Text = chooseParts.PartsCode; txtparts_name2.Caption = chooseParts.PartsName; } }
/// <summary> /// 根据选择的配件编码获取编码和名称 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtparts_code_ChooserClick(object sender, EventArgs e) { try { frmParts chooseParts = new frmParts(); chooseParts.ShowDialog(); if (!string.IsNullOrEmpty(chooseParts.PartsID)) { txtparts_code.Text = chooseParts.PartsCode; txtparts_name.Caption = chooseParts.PartsName; } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
/// <summary> /// 调价单配件信息添加 /// </summary> private void PartsAdd() { try { frmParts frm = new frmParts(); DialogResult result = frm.ShowDialog(); if (result == DialogResult.OK) { string PartsCode = frm.PartsCode; if (gvPartsMsgList.Rows.Count > 0) { foreach (DataGridViewRow dr in gvPartsMsgList.Rows) { if (dr.Cells["partsnum"].Value.ToString() == PartsCode) { MessageBoxEx.Show("该配件信息已经存在与列表中,不能再次添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } } DataTable dt = GetPartsByCode(PartsCode); if (dt == null || dt.Rows.Count == 0) { return; } else { foreach (DataRow dr in dt.Rows) { DataGridViewRow dgvr = gvPartsMsgList.Rows[gvPartsMsgList.Rows.Add()]; GetGridViewRowByDr(dgvr, dr); } } } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question); } }
/// <summary> /// 调价单配件信息添加 /// </summary> private void PartsAdd() { try { frmParts frm = new frmParts(); DialogResult result = frm.ShowDialog(); if (result == DialogResult.OK) { string PartsCode = frm.PartsCode; if (gvPartsMsgList.Rows.Count > 0) { foreach (DataGridViewRow dr in gvPartsMsgList.Rows) { if (dr.Cells["parts_code"].Value.ToString() == PartsCode) { MessageBoxEx.Show("该配件信息已经存在与列表中,不能再次添加!"); return; } } } DataTable dt = GetPartsByCode(PartsCode); if (dt == null || dt.Rows.Count == 0) { return; } else { int SerialID = 1; foreach (DataRow dr in dt.Rows) { DataGridViewRow dgvr = gvPartsMsgList.Rows[gvPartsMsgList.Rows.Add()]; GetGridViewRowByDr(dgvr, dr, SerialID); SerialID++;//序号自动增长 } } } } catch (Exception ex) { MessageBoxEx.Show(ex.Message); } }
private void tsmadd_Click(object sender, EventArgs e) { if (tabControlEx1.SelectedIndex == 0) { //特殊维修项目 frmWorkHours fm = new frmWorkHours(); if (fm.ShowDialog() == DialogResult.OK) { int rowindex = dgvprojrct.Rows.Add(); DataGridViewRow gvr = dgvprojrct.Rows[rowindex]; gvr.Cells["project_num"].Value = fm.strProjectNum; gvr.Cells["project_name"].Value = fm.strProjectName; gvr.Cells["quota_price"].Value = fm.strQuotaPrice; gvr.Cells["service_project_id"].Value = fm.strWhours_id; gvr.Cells["project_service_project_discount"].Value = ""; gvr.Cells["project_discount_price"].Value = ""; gvr.Cells["project_remark"].Value = ""; gvr.Cells["setInfo_projrct_id"].Value = ""; //CommonUtility.SetDgvEditCellBgColor(dgvprojrct.Rows[rowindex], new string[] { "project_service_project_discount", "project_remark" }, true); } } else { //特殊配件 frmParts fm = new frmParts(); if (fm.ShowDialog() == DialogResult.OK) { DataGridViewRow gvr = dgvparts.Rows[dgvparts.Rows.Add()]; gvr.Cells["ser_parts_code"].Value = fm.PartsCode; gvr.Cells["parts_name"].Value = fm.PartsName; gvr.Cells["ref_out_price"].Value = fm.ref_out_price; gvr.Cells["parts_id"].Value = fm.PartsID; gvr.Cells["parts_discount"].Value = ""; gvr.Cells["discount_price"].Value = ""; gvr.Cells["remark"].Value = ""; gvr.Cells["setInfo_parts_id"].Value = ""; } } }
private void dgvMaterials_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { string strPId = frmPart.PartsID; DataTable dpt = DBHelper.GetTable("", "v_parts", "*", " parts_id='" + strPId + "'", "", ""); if (dpt.Rows.Count > 0) { DataRow dpr = dpt.Rows[0]; dgvMaterials.Rows[e.RowIndex].Cells["parts_code"].Value = CommonCtrl.IsNullToString(dpr["ser_parts_code"]); dgvMaterials.Rows[e.RowIndex].Cells["parts_name"].Value = CommonCtrl.IsNullToString(dpr["parts_name"]); dgvMaterials.Rows[e.RowIndex].Cells["unit"].Value = CommonCtrl.IsNullToString(dpr["default_unit_name"]); dgvMaterials.Rows[e.RowIndex].Cells["number"].Value = "1"; dgvMaterials.Rows[e.RowIndex].Cells["original_price"].Value = CommonCtrl.IsNullToString(dpr["highest_out_price"]); dgvMaterials.Rows[e.RowIndex].Cells["Mremarks"].Value = CommonCtrl.IsNullToString(dpr["remark"]); dgvMaterials.Rows.Add(1); } } }
private void addParts_Click(object sender, EventArgs e) { foreach (DataGridViewRow dgvr in dgvMaterials.Rows) { string strPCode = CommonCtrl.IsNullToString(dgvr.Cells["parts_code"].Value); if (!string.IsNullOrEmpty(strPCode)) { listMater.Add(strPCode); } } frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { string strPId = frmPart.PartsID; DataTable dpt = DBHelper.GetTable("", "v_parts_chooser", "*", " parts_id='" + strPId + "'", "", ""); if (dpt.Rows.Count > 0) { DataRow dpr = dpt.Rows[0]; if (listMater.Contains(CommonCtrl.IsNullToString(dpr["ser_parts_code"]))) { MessageBoxEx.Show("此配件已存在,请选择其他配件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } dgvMaterials.CurrentRow.Cells["parts_code"].Value = CommonCtrl.IsNullToString(dpr["ser_parts_code"]); dgvMaterials.CurrentRow.Cells["parts_name"].Value = CommonCtrl.IsNullToString(dpr["parts_name"]); dgvMaterials.CurrentRow.Cells["unit"].Value = CommonCtrl.IsNullToString(dpr["unit"]); dgvMaterials.CurrentRow.Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dpr["drawing_num"]); dgvMaterials.CurrentRow.Cells["quantity"].Value = "0"; string unit_price = CommonCtrl.IsNullToString(dpr["retail"]); dgvMaterials.CurrentRow.Cells["unit_price"].Value = !string.IsNullOrEmpty(unit_price) ? unit_price : "0"; dgvMaterials.CurrentRow.Cells["norms"].Value = CommonCtrl.IsNullToString(dpr["model"]); dgvMaterials.CurrentRow.Cells["inventory_num"].Value = CommonCtrl.IsNullToString(dpr["paper_count"]); dgvMaterials.Rows.Add(1); } } }
private void addParts_Click(object sender, EventArgs e) { foreach (DataGridViewRow dgvr in dgvMaterials.Rows) { string strPCode = CommonCtrl.IsNullToString(dgvr.Cells["parts_code"].Value); if (!string.IsNullOrEmpty(strPCode)) { listMater.Add(strPCode); } } frmParts frmPart = new frmParts(); DialogResult result = frmPart.ShowDialog(); if (result == DialogResult.OK) { string strPId = frmPart.PartsID; DataTable dpt = DBHelper.GetTable("", "v_parts", "*", " parts_id='" + strPId + "'", "", ""); if (dpt.Rows.Count > 0) { DataRow dpr = dpt.Rows[0]; if (listMater.Contains(CommonCtrl.IsNullToString(dpr["ser_parts_code"]))) { MessageBoxEx.Show("此配件已存在,请选择其他配件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } dgvMaterials.CurrentRow.Cells["parts_code"].Value = CommonCtrl.IsNullToString(dpr["ser_parts_code"]); dgvMaterials.CurrentRow.Cells["parts_name"].Value = CommonCtrl.IsNullToString(dpr["parts_name"]); dgvMaterials.CurrentRow.Cells["unit"].Value = CommonCtrl.IsNullToString(dpr["default_unit_name"]); dgvMaterials.CurrentRow.Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dpr["drawing_num"]); dgvMaterials.CurrentRow.Cells["quantity"].Value = "0"; dgvMaterials.CurrentRow.Cells["unit_price"].Value = CommonCtrl.IsNullToString(dpr["highest_out_price"]); dgvMaterials.CurrentRow.Cells["whether_imported"].Value = CommonCtrl.IsNullToString(dpr["is_import"]) == "1" ? "是" : "否"; dgvMaterials.CurrentRow.Cells["vehicle_brand"].Value = CommonCtrl.IsNullToString(dpr["v_brand_name"]); dgvMaterials.Rows.Add(1); } } }