private void ly_machine_rk_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (ly_machine_rk.CurrentRow == null)
{
return;
}
if (this.ly_machine_rk.CurrentRow.Cells["审批2"].Value.ToString() == "True")
{
MessageBox.Show("已经锁定...", "注意");
return;
}
string salespeople = this.ly_machine_rk.CurrentRow.Cells["操作人2"].Value.ToString();
if (salespeople != SQLDatabase.nowUserName())
{
MessageBox.Show("请操作人:" + salespeople + "修改", "注意");
return;
}
DataGridView dgv = sender as DataGridView;
if ("pay_time2" == dgv.CurrentCell.OwningColumn.Name)
{
DatePicker queryForm = new DatePicker();
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
else
{
queryForm.NowDate = SQLDatabase.GetNowdate().Date.ToString();
}
queryForm.ShowDialog();
if (!string.IsNullOrEmpty(queryForm.NowDate))
{
dgv.CurrentRow.Cells["pay_time2"].Value = queryForm.NowDate;
}
this.ly_machine_rk.EndEdit();
this.lyinvoicepayBindingSource.EndEdit();
this.ly_invoice_payTableAdapter.Update(this.lYStoreMange.ly_invoice_pay);
return;
}
}
private void handinDatebutton_Click(object sender, EventArgs e)
{
DatePicker queryForm = new DatePicker();
queryForm.NowDate = DateTime.Today.Date.ToString();
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
handinDatetextBox.Text = queryForm.NowDate.Substring(0, 10);
}
}
private void ly_store_innumDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (!string.IsNullOrEmpty(ly_store_outnumDailyDataGridView.CurrentRow.Cells["计划编号"].Value.ToString()))
{
MessageBox.Show("计划发料只能在这里浏览,不能修改", "注意");
return;
}
if (SQLDatabase.nowUserName() != dgv.CurrentRow.Cells["发料人"].Value.ToString())
{
MessageBox.Show("请发料人:" + dgv.CurrentRow.Cells["发料人"].Value.ToString() + " 修改");
return;
}
/////////////////////////////////
if ("出库类别" == dgv.CurrentCell.OwningColumn.Name)
{
if ("借旧还新" == dgv.CurrentCell.Value.ToString() || "借新还旧" == dgv.CurrentCell.Value.ToString())
{
return;
}
if ("True" == ly_store_outDataGridView.CurrentRow.Cells["finished1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改出库类别...");
return;
}
string sel = "SELECT a.stylecode as 编码,a.stylename as 名称 FROM ly_store_out_styleset a ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
//dgv.CurrentRow.Cells["out_style"].Value = queryForm.Result;
dgv.CurrentCell.Value = queryForm.Result1;
SaveInStyle(queryForm.Result1);
string outnumber = ly_store_outnumDailyDataGridView.CurrentRow.Cells["出库单号"].Value.ToString();
this.ly_waste_outTableAdapter.Fill(this.lYStoreMange.ly_waste_out, outnumber, SQLDatabase.nowUserName());
return;
}
/////////////////////////////////////////////////////
if ("领料人" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_outDataGridView.CurrentRow.Cells["finished1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改领料人...");
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "string";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentCell.Value = queryForm.NewValue;
SaveEmploye(queryForm.NewValue);
}
else
{
}
string outnumber = ly_store_outnumDailyDataGridView.CurrentRow.Cells["出库单号"].Value.ToString();
this.ly_waste_outTableAdapter.Fill(this.lYStoreMange.ly_waste_out, outnumber, SQLDatabase.nowUserName());
return;
}
/////////////////////////////////////////////////////
/////////////////////////////////////////////////////
if ("原始单据" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_outDataGridView.CurrentRow.Cells["finished1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改原始单据...");
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "string";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentCell.Value = queryForm.NewValue;
SaveOriginNum(queryForm.NewValue);
}
else
{
}
string outnumber = ly_store_outnumDailyDataGridView.CurrentRow.Cells["出库单号"].Value.ToString();
this.ly_waste_outTableAdapter.Fill(this.lYStoreMange.ly_waste_out, outnumber, SQLDatabase.nowUserName());
return;
}
/////////////////////////////////////////////////////
/////////////////////////////////////////////////////
if ("部门名称" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_outDataGridView.CurrentRow.Cells["finished1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改部门名称...");
return;
}
string sel = "SELECT a.prodcode as 编码,a.prodname as 名称 FROM ly_prod_dept a ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
dgv.CurrentRow.Cells["部门代码"].Value = queryForm.Result;
dgv.CurrentRow.Cells["部门名称"].Value = queryForm.Result1;
SaveDepartment(queryForm.Result);
return;
string outnumber = ly_store_outnumDailyDataGridView.CurrentRow.Cells["出库单号"].Value.ToString();
this.ly_waste_outTableAdapter.Fill(this.lYStoreMange.ly_waste_out, outnumber, SQLDatabase.nowUserName());
return;
}
/////////////////////////////////////////////////////
if ("出库日期" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_outDataGridView.CurrentRow.Cells["finished1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改出库日期...");
return;
}
DatePicker queryForm = new DatePicker();
//queryForm.Pt = pt;
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
dgv.CurrentCell.Value = queryForm.NowDate;
SaveIndate(queryForm.NowDate);
}
string outnumber = ly_store_outnumDailyDataGridView.CurrentRow.Cells["出库单号"].Value.ToString();
this.ly_waste_outTableAdapter.Fill(this.lYStoreMange.ly_waste_out, outnumber, SQLDatabase.nowUserName());
return;
}
/////////////////////////////////////////////////////
}
private void ly_production_orderDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (null == this.ly_production_orderDataGridView.CurrentRow)
{
return;
}
DataGridView dgv = sender as DataGridView;
string taskMumber = ly_production_orderDataGridView.CurrentRow.Cells["任务单号"].Value.ToString();
using (SqlConnection con = new SqlConnection(SQLDatabase.Connectstring))
{
string sql = "select COUNT(1) from ly_store_out where pruductionTaskInspection_num='" + taskMumber + "'";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
int k = Convert.ToInt32(cmd.ExecuteScalar());
if (k > 0)
{
MessageBox.Show("已有出入库记录不可删除", "注意");
return;
}
}
}
using (SqlConnection con = new SqlConnection(SQLDatabase.Connectstring))
{
string sql = "select COUNT(1) from ly_store_in where pruductionTaskInspection_num='" + taskMumber + "'";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
int k = Convert.ToInt32(cmd.ExecuteScalar());
if (k > 0)
{
MessageBox.Show("已有出入库记录不可删除", "注意");
return;
}
}
}
if ("加工数量" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["加工数量"].Value = queryForm.NewValue;
int noworderValue = 0;
int nowplanValue = int.Parse(this.ly_material_plan_detailDataGridView.CurrentRow.Cells["数量"].Value.ToString(), System.Globalization.NumberStyles.Number);
foreach (DataGridViewRow dgr in dgv.Rows)
{
if (string.IsNullOrEmpty(dgr.Cells["加工数量"].Value.ToString()))
{
continue;
}
noworderValue = noworderValue + int.Parse(dgr.Cells["加工数量"].Value.ToString(), System.Globalization.NumberStyles.Number);
}
if (noworderValue > nowplanValue)
{
dgv.CurrentRow.Cells["加工数量"].Value = queryForm.OldValue;
MessageBox.Show("任务安排不能超过计划数量,操作取消...", "注意");
return;
}
dgv.CurrentRow.Cells["加工数量"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
//hT_Manage_ItemDataGridView.CurrentRow.Cells["apply_money"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["apply_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
//SaveChanged();
}
return;
}
///////////////////////////////////////////////////////
if ("工号" == dgv.CurrentCell.OwningColumn.Name || "工人" == dgv.CurrentCell.OwningColumn.Name)
{
//if (!checkqualityRec() && "系统管理员" != SQLDatabase.nowUserName())
//{
// MessageBox.Show("任务已有检验记录,不能修改, 操作取消", "注意");
// return;
//}
//string outflag = this.ly_production_order_detailDataGridView.CurrentRow.Cells["外协"].Value.ToString();
string sel;
//if ("True" == outflag)
//{
// sel = "SELECT supplier_code as 工号, supplier_name as 姓名 FROM ly_supplier_list where sort_code='4'";
//}
//else
//{
// sel = "SELECT work_code as 工号, worker_name as 姓名 FROM ly_worker_list";
//}
sel = "SELECT work_code as 工号, worker_name as 姓名 FROM ly_worker_list where prodcode='01'";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
//Set the Column Collection to the filter Table
//queryForm.SetSourceColumns(this.billMainDataSet.BalanceBill.Columns);
queryForm.ShowDialog();
if (queryForm.Result != "")
{
dgv.CurrentRow.Cells["工号"].Value = queryForm.Result;
dgv.CurrentRow.Cells["工人"].Value = queryForm.Result1;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
dgv.CurrentRow.Cells["工号"].Value = DBNull.Value;
dgv.CurrentRow.Cells["工人"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
return;
}
///////////////////////////////////////////////////////
///////////////////////////////////////////////////////
if ("下单日期" == dgv.CurrentCell.OwningColumn.Name)
{
DatePicker queryForm = new DatePicker();
queryForm.Pt = pt;
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
dgv.CurrentRow.Cells["下单日期"].Value = queryForm.NowDate;
SaveChanged();
}
return;
}
///////////////////////////////////////////////////////
if ("完成日期" == dgv.CurrentCell.OwningColumn.Name)
{
DatePicker queryForm = new DatePicker();
queryForm.Pt = pt;
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
else
{
queryForm.NowDate = SQLDatabase.GetNowdate().Date.ToString();
}
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
dgv.CurrentRow.Cells["完成日期"].Value = queryForm.NowDate;
SaveChanged();
}
return;
}
///////////////////////////////////////////////////////
if ("备注" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
//queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["备注"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
}
return;
}
/////////////////////////////
if ("完成" == dgv.CurrentCell.OwningColumn.Name)
{
if (!SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "跟单完成设置"))
{
MessageBox.Show("无跟单完成设置权限,操作取消...", "注意");
return;
}
if ("True" == dgv.CurrentRow.Cells["完成"].Value.ToString())
{
dgv.CurrentRow.Cells["完成"].Value = "False";
}
else
{
dgv.CurrentRow.Cells["完成"].Value = "True";
}
SaveChanged();
return;
}
///////////////////////////////////////////////////////
}
private void ly_store_innumDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (SQLDatabase.nowUserName() != dgv.CurrentRow.Cells["收料人"].Value.ToString() && "000" != SQLDatabase.NowUserID)
{
MessageBox.Show("请收料人:" + dgv.CurrentRow.Cells["收料人"].Value.ToString() + " 修改");
return;
}
/////////////////////////////////
if ("入库类别1" == dgv.CurrentCell.OwningColumn.Name)
{
if ("借旧还新" == dgv.CurrentCell.Value.ToString() || "借新还旧" == dgv.CurrentCell.Value.ToString())
{
return;
}
if ("True" == ly_store_in_ylDataGridView.CurrentRow.Cells["签证1"].Value.ToString() && "000" != SQLDatabase.NowUserID)
{
MessageBox.Show("已经签证,不能修改入库类别...");
return;
}
string sel = "SELECT a.stylecode as 编码,a.stylename as 名称 FROM ly_store_in_styleset a ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
//dgv.CurrentRow.Cells["out_style"].Value = queryForm.Result;
dgv.CurrentCell.Value = queryForm.Result1;
SaveInStyle(queryForm.Result1);
string innumber = ly_store_innumDataGridView.CurrentRow.Cells["入库单号"].Value.ToString();
this.ly_store_in_innumTableAdapter.Fill(this.lYStoreMange.ly_store_in_innum, innumber, SQLDatabase.NowUserID);
return;
}
/////////////////////////////////////////////////////
if ("采购员1" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_in_ylDataGridView.CurrentRow.Cells["签证1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改采购员...");
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "string";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentCell.Value = queryForm.NewValue;
SaveEmploye(queryForm.NewValue);
}
else
{
//hT_Manage_ItemDataGridView.CurrentRow.Cells["apply_money"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["apply_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
//SaveChanged();
}
string innumber = ly_store_innumDataGridView.CurrentRow.Cells["入库单号"].Value.ToString();
this.ly_store_in_innumTableAdapter.Fill(this.lYStoreMange.ly_store_in_innum, innumber, SQLDatabase.NowUserID);
return;
}
/////////////////////////////////////////////////////
/////////////////////////////////////////////////////
if ("单据编号1" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_in_ylDataGridView.CurrentRow.Cells["签证1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改单据编号...");
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "string";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentCell.Value = queryForm.NewValue;
SaveBllcode(queryForm.NewValue);
}
else
{
//hT_Manage_ItemDataGridView.CurrentRow.Cells["apply_money"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["apply_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
//SaveChanged();
}
string innumber = ly_store_innumDataGridView.CurrentRow.Cells["入库单号"].Value.ToString();
this.ly_store_in_innumTableAdapter.Fill(this.lYStoreMange.ly_store_in_innum, innumber, SQLDatabase.NowUserID);
return;
}
/////////////////////////////////////////////////////
if ("入库日期1" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == ly_store_in_ylDataGridView.CurrentRow.Cells["签证1"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改入库日期...");
return;
}
DatePicker queryForm = new DatePicker();
//queryForm.Pt = pt;
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
dgv.CurrentCell.Value = queryForm.NowDate;
SaveIndate(queryForm.NowDate);
}
string innumber = ly_store_innumDataGridView.CurrentRow.Cells["入库单号"].Value.ToString();
this.ly_store_in_innumTableAdapter.Fill(this.lYStoreMange.ly_store_in_innum, innumber, SQLDatabase.NowUserID);
return;
}
/////////////////////////////////////////////////////
}
private void ly_production_orderDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (null == this.ly_production_orderDataGridView.CurrentRow)
{
return;
}
DataGridView dgv = sender as DataGridView;
string taskMumber = ly_production_orderDataGridView.CurrentRow.Cells["任务单号"].Value.ToString();
using (SqlConnection con = new SqlConnection(SQLDatabase.Connectstring))
{
string sql = "select COUNT(1) from ly_store_out where pruductionTaskInspection_num='" + taskMumber + "'";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
int k = Convert.ToInt32(cmd.ExecuteScalar());
if (k > 0)
{
MessageBox.Show("已有出入库记录不可删除", "注意");
return;
}
}
}
using (SqlConnection con = new SqlConnection(SQLDatabase.Connectstring))
{
string sql = "select COUNT(1) from ly_store_in where pruductionTaskInspection_num='" + taskMumber + "'";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
int k = Convert.ToInt32(cmd.ExecuteScalar());
if (k > 0)
{
MessageBox.Show("已有出入库记录不可删除", "注意");
return;
}
}
}
if (ly_restructuring_task_inspectionDataGridView.Rows.Count > 0)
{
foreach (DataGridViewRow dgr in ly_restructuring_task_inspectionDataGridView.Rows)
{
if ("True" == dgr.Cells["合格"].Value.ToString())
{
MessageBox.Show("已经质检合格，不能删除(实需删除，请先清除质检合格标记)", "注意");
return;
}
if ("True" == dgr.Cells["出库"].Value.ToString())
{
MessageBox.Show("已经领料，不能删除(实需删除，请先清除领料标记)", "注意");
return;
}
if ("True" == dgr.Cells["入库"].Value.ToString())
{
MessageBox.Show("已经入库，不能删除(实需删除，请先删除该质检单号的入库记录)", "注意");
return;
}
}
}
if ("加工数量" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["加工数量"].Value = queryForm.NewValue;
int noworderValue = 0;
int nowplanValue = int.Parse(this.ly_material_plan_detailDataGridView.CurrentRow.Cells["改制数量"].Value.ToString(), System.Globalization.NumberStyles.Number);
foreach (DataGridViewRow dgr in dgv.Rows)
{
if (string.IsNullOrEmpty(dgr.Cells["加工数量"].Value.ToString()))
{
continue;
}
noworderValue = noworderValue + int.Parse(dgr.Cells["加工数量"].Value.ToString(), System.Globalization.NumberStyles.Number);
}
if (noworderValue > nowplanValue)
{
dgv.CurrentRow.Cells["加工数量"].Value = queryForm.OldValue;
MessageBox.Show("任务安排不能超过计划数量,操作取消...", "注意");
return;
}
dgv.CurrentRow.Cells["加工数量"].Value = queryForm.NewValue;
dgv.CurrentRow.Cells["未入库数"].Value = queryForm.NewValue;
InsertRequset(dgv);
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
}
else
{
}
return;
}
if ("工号" == dgv.CurrentCell.OwningColumn.Name || "工人" == dgv.CurrentCell.OwningColumn.Name)
{
string sel;
sel = "SELECT work_code as 工号, worker_name as 姓名 FROM ly_worker_list where prodcode='01'";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
if (queryForm.Result != "")
{
dgv.CurrentRow.Cells["工号"].Value = queryForm.Result;
dgv.CurrentRow.Cells["工人"].Value = queryForm.Result1;
InsertRequset(dgv);
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
}
else
{
dgv.CurrentRow.Cells["工号"].Value = DBNull.Value;
dgv.CurrentRow.Cells["工人"].Value = DBNull.Value;
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
}
return;
}
if ("下单日期" == dgv.CurrentCell.OwningColumn.Name)
{
DatePicker queryForm = new DatePicker();
queryForm.Pt = pt;
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
dgv.CurrentRow.Cells["下单日期"].Value = queryForm.NowDate;
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
}
return;
}
if ("完成日期" == dgv.CurrentCell.OwningColumn.Name)
{
DatePicker queryForm = new DatePicker();
queryForm.Pt = pt;
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
else
{
queryForm.NowDate = SQLDatabase.GetNowdate().Date.ToString();
}
queryForm.ShowDialog();
if (null != queryForm.NowDate)
{
dgv.CurrentRow.Cells["完成日期"].Value = queryForm.NowDate;
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
}
return;
}
if ("任务单备注" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["任务单备注"].Value = queryForm.NewValue;
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
}
else
{
}
return;
}
if ("完成" == dgv.CurrentCell.OwningColumn.Name)
{
if (!SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "跟单完成设置"))
{
MessageBox.Show("无跟单完成设置权限,操作取消...", "注意");
return;
}
if ("True" == dgv.CurrentRow.Cells["完成"].Value.ToString())
{
dgv.CurrentRow.Cells["完成"].Value = "False";
}
else
{
dgv.CurrentRow.Cells["完成"].Value = "True";
}
SaveChanged(int.Parse(dgv.CurrentRow.Cells["改制编号"].Value.ToString()));
return;
}
}
private void ly_manufacturing_procedureDataGridView_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (null == ly_fpDataGridView.CurrentRow)
{
return;
}
DataGridView dgv = sender as DataGridView;
if (SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "发票总管理权限"))
{
if ("lock_flag" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == dgv.CurrentRow.Cells["lock_flag"].Value.ToString())
{
////----------------------
//string sql = "SELECT a.contract_code, c.confirm_flag FROM ly_payable_item_detail AS a left join ly_payable_plan c on a.payable_plan_num = c.payable_plan_num WHERE c.confirm_flag=1";
//DataTable dt = null;
//using (SqlConnection connection = new SqlConnection(SQLDatabase.Connectstring))
//{
// SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
// DataSet ds = new DataSet();
// adapter.Fill(ds);
// dt = ds.Tables[0];
//}
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// for (int j = 0; j < ly_invoice_detailDataGridView.Rows.Count; j++)
// {
// if (dt.Rows[i]["contract_code"].ToString() == ly_invoice_detailDataGridView.Rows[j].Cells["contractcode0"].Value.ToString())
// {
// MessageBox.Show("已有付款计划不可操作！", "注意");
// return;
// }
// }
//}
//-------------------
//dgv.CurrentRow.Cells["lock_flag"].Value = "False";
//dgv.CurrentRow.Cells["lock_people"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["lock_time"].Value = DBNull.Value;
if (SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "采购预付付款取消"))
{
dgv.CurrentRow.Cells["lock_flag"].Value = "False";
dgv.CurrentRow.Cells["lock_people"].Value = DBNull.Value;
dgv.CurrentRow.Cells["lock_time"].Value = DBNull.Value;
}
else
{
MessageBox.Show("无发票锁定取消权限...", "注意");
return;
}
}
else
{
if ("False" == dgv.CurrentRow.Cells["提交"].Value.ToString() || "" == dgv.CurrentRow.Cells["提交"].Value.ToString().Trim())
{
MessageBox.Show("采购员未提交不可锁定！", "注意");
return;
}
if (decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["invoice_money_novat"].Value.ToString().Trim()), 1)
<= decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["bind_money_ovat"].Value.ToString().Trim()), 1)
||
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["发票金额"].Value.ToString().Trim()), 1)
<= decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["绑定金额"].Value.ToString().Trim()), 1)
)
{
if (decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["bind_money_ovat"].Value.ToString().Trim()), 1) -
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["invoice_money_novat"].Value.ToString().Trim()), 1) > 10
&&
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["绑定金额"].Value.ToString().Trim()), 1) -
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["发票金额"].Value.ToString().Trim()), 1) > 10)
{
MessageBox.Show("本次发票绑定金额异常过大，请联系管理员排查！", "注意");
return;
}
else
{
dgv.CurrentRow.Cells["lock_flag"].Value = "True";
dgv.CurrentRow.Cells["lock_people"].Value = SQLDatabase.nowUserName();
dgv.CurrentRow.Cells["lock_time"].Value = SQLDatabase.GetNowtime();
}
}
else
{
MessageBox.Show("发票金额与绑定金额不一致！", "注意");
return;
}
}
save();
return;
}
}
string salespeople = this.ly_fpDataGridView.CurrentRow.Cells["录入人"].Value.ToString();
if (!string.IsNullOrEmpty(salespeople))
{
if (salespeople != SQLDatabase.nowUserName())
{
MessageBox.Show("请录入人:" + salespeople + "修改", "注意");
return;
}
}
//加锁
if (ly_fpDataGridView.CurrentRow.Cells["lock_flag"].Value.ToString() == "True")
{
MessageBox.Show("已经锁定无法操作...", "注意");
return;
}
if ("提交" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == dgv.CurrentRow.Cells["提交"].Value.ToString())
{
dgv.CurrentRow.Cells["提交"].Value = "False";
save();
}
else
{
if (
//decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["invoice_money_novat"].Value.ToString().Trim()),1)
// <= decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["bind_money_ovat"].Value.ToString().Trim()), 1)
// ||
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["发票金额"].Value.ToString().Trim()), 2)
!= decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["绑定金额"].Value.ToString().Trim()), 2))
{
MessageBox.Show("本次发票绑定金额和发票金额不相等，请检查！", "注意");
return;
if (decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["bind_money_ovat"].Value.ToString().Trim()), 1) -
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["invoice_money_novat"].Value.ToString().Trim()), 1) > 10
&&
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["绑定金额"].Value.ToString().Trim()), 1) -
decimal.Round(decimal.Parse(dgv.CurrentRow.Cells["发票金额"].Value.ToString().Trim()), 1) > 10)
{
MessageBox.Show("本次发票绑定金额异常过大，请排查！", "注意");
return;
}
else
{
dgv.CurrentRow.Cells["提交"].Value = "True";
save();
}
}
else
{
dgv.CurrentRow.Cells["提交"].Value = "True";
save();
}
}
}
if ("录入人" == dgv.CurrentCell.OwningColumn.Name)
{
return;
string sel = "select yhmc as 采购员 from dbo.T_users where bumen like '0004%' ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
if (queryForm.Result != "")
{
dgv.CurrentRow.Cells["录入人"].Value = queryForm.Result;
save();
}
return;
}
if ("发票类别" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == dgv.CurrentRow.Cells["lock_flag"].Value.ToString() || "True" == dgv.CurrentRow.Cells["提交"].Value.ToString())
{
MessageBox.Show("已经提交或锁定，不能修改！", "注意");
return;
}
string sel = "SELECT id as 编号, tax_type_name as 发票类型 FROM ly_tax_type ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
if (queryForm.Result != "")
{
dgv.CurrentRow.Cells["发票类别"].Value = queryForm.Result1;
save();
}
return;
}
if ("客户编码" == dgv.CurrentCell.OwningColumn.Name || "客户名称" == dgv.CurrentCell.OwningColumn.Name)
{
string sel = "select supplier_code as 客户编码,supplier_name 客户名称 from ly_supplier_list ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
if (queryForm.Result != "")
{
dgv.CurrentRow.Cells["客户编码"].Value = queryForm.Result;
dgv.CurrentRow.Cells["客户名称"].Value = queryForm.Result1;
save();
}
return;
}
if ("发票号码" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "string";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
for (int i = 0; i < ly_fpDataGridView.Rows.Count; i++)
{
if (ly_fpDataGridView.Rows[i].Cells["发票号码"].Value.ToString() == queryForm.NewValue)
{
MessageBox.Show("该张发票已经存在", "注意");
return;
}
}
dgv.CurrentRow.Cells["发票号码"].Value = queryForm.NewValue;
save();
}
return;
}
if ("发票日期" == dgv.CurrentCell.OwningColumn.Name)
{
DatePicker queryForm = new DatePicker();
if (null != (dgv.CurrentCell.Value))
{
queryForm.NowDate = dgv.CurrentCell.Value.ToString();
}
else
{
queryForm.NowDate = SQLDatabase.GetNowdate().Date.ToString();
}
queryForm.ShowDialog();
if (!string.IsNullOrEmpty(queryForm.NowDate))
{
dgv.CurrentRow.Cells["发票日期"].Value = queryForm.NowDate;
save();
}
return;
}
if ("发票金额" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["发票金额"].Value = queryForm.NewValue;
save();
}
return;
}
if ("税率" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["税率"].Value = queryForm.NewValue;
save();
}
return;
}
}
