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);
}
}
}
