private void ly_store_innum_purchaseDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (SQLDatabase.nowUserName() != dgv.CurrentRow.Cells["收料人"].Value.ToString())
{
MessageBox.Show("请收料人:" + dgv.CurrentRow.Cells["收料人"].Value.ToString() + " 修改");
return;
}
if ("入库日期1" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == dgv.CurrentRow.Cells["签证"].Value.ToString())
{
MessageBox.Show("已经签证,不能修改入库日期...");
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "datetime";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentCell.Value = queryForm.NewValue;
SaveIndate(queryForm.NewValue);
}
return;
}
}
private void ly_inma0010DataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if ("en_name" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (!string.IsNullOrEmpty(queryForm.NewValue))
{
dgv.CurrentRow.Cells["en_name"].Value = queryForm.NewValue;
this.ly_inma0010DataGridView.EndEdit();
this.Validate();
this.lysalesclientBindingSource.EndEdit();
this.ly_sales_clientTableAdapter.Update(this.lYMaterialMange.ly_sales_client);
return;
}
}
}
private void ly_production_task_returnSingleDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (this.ly_production_task_returnSingleDataGridView.CurrentRow.Cells["退料审批人"].Value != null)
{
string inspector = this.ly_production_task_returnSingleDataGridView.CurrentRow.Cells["退料审批人"].Value.ToString();
if (inspector.Trim() != "")
{
if (inspector != SQLDatabase.nowUserName())
{
MessageBox.Show("请质检员:" + inspector + "修改", "注意");
return;
}
}
}
if ("退料审批" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.Text = "审批意见";
queryForm.ChangeMode = "longstring";
queryForm.OldValue = dgv.CurrentRow.Cells["审批意见2"].Value.ToString();
queryForm.NewValue = "";
queryForm.ShowDialog();
string id = this.ly_production_task_returnSingleDataGridView.CurrentRow.Cells["退料编号"].Value.ToString();
string sql = "";
if ("True" == dgv.CurrentRow.Cells["退料审批"].Value.ToString())
{
sql = @"update ly_production_task_returnSingle set material_flag = 0 , approve_people =null , approve_date =null ,approve_remark=null where id=" + id;
}
else
{
sql = @"update ly_production_task_returnSingle set material_flag =1 , approve_people ='" + SQLDatabase.nowUserName() + "' , approve_date =GETDATE() ,approve_remark='" + queryForm.NewValue + "' where id=" + id;
}
using (SqlConnection con = new SqlConnection(SQLDatabase.Connectstring))
{
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
cmd.ExecuteNonQuery();
}
}
reLoad();
return;
}
}
private void ly_material_plan_detailDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (Check_ifApproved(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString()))
{
MessageBox.Show("计划已经批准,不能改动...", "注意");
return;
}
if ("True" == this.ly_material_plan_mainDataGridView.CurrentRow.Cells["启用"].Value.ToString())
{
MessageBox.Show("领料计划已经审批,不能修改条目...", "注意");
return;
}
DataGridView dgv = sender as DataGridView;
if ("领料数量" == dgv.CurrentCell.OwningColumn.Name)
{
return;
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;
SaveChanged();
}
return;
}
if ("新旧" == dgv.CurrentCell.OwningColumn.Name)
{
string sel = "SELECT oldnew as 新旧 FROM ly_finishproduct_newold ";
QueryForm queryForm = new QueryForm();
queryForm.Sel = sel;
queryForm.Constr = SQLDatabase.Connectstring;
queryForm.ShowDialog();
if (queryForm.Result != "")
{
dgv.CurrentRow.Cells["新旧"].Value = queryForm.Result;
SaveChanged();
}
return;
}
}
private void ly_outmachine_contract_detail_selDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = ly_outmachine_contract_detail_selDataGridView;
return;
/////////////////////////////////////////////////////////
//if ("True" == ly_purchase_contract_mainDataGridView.CurrentRow.Cells["批准"].Value.ToString())
//{
// MessageBox.Show("合同已经审批,不能修改数据...", "注意");
// return;
//}
///////////////////////////////////////////////////////////////
/////////////////////////////
if ("合格金额3" == 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["合格金额3"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
Savedetail();
//CountPlanStru();
}
else
{
dgv.CurrentRow.Cells["合格金额3"].Value = 0;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
Savedetail();
}
return;
}
}
private void ly_Restructuring_Bom_requestDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if ("备注2" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["备注2"].Value = queryForm.NewValue;
SaveReq();
}
else
{
}
return;
}
if ("数量1" == 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["数量1"].Value = queryForm.NewValue;
SaveReq();
}
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;
}
}
private void ly_Restructuring_Bom_returnDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if ("备注3" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["备注3"].Value = queryForm.NewValue;
SaveRet();
}
else
{
}
return;
}
if ("数量2" == 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["数量2"].Value = queryForm.NewValue;
SaveRet();
}
else
{
}
return;
}
}
private void ly_purchase_contract_inspection_MainDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (SQLDatabase.nowUserName() != dgv.CurrentRow.Cells["质检员"].Value.ToString())
{
MessageBox.Show("请质检员:" + dgv.CurrentRow.Cells["质检员"].Value.ToString() + " 修改");
return;
}
/////////////////////////////////////////////////////
if ("检验日期" == dgv.CurrentCell.OwningColumn.Name)
{
//if ("True" == dgv.CurrentRow.Cells["签证"].Value.ToString())
//{
// MessageBox.Show("已经签证,不能修改入库日期...");
// return;
//}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "datetime";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentCell.Value = queryForm.NewValue;
SaveIndate(queryForm.NewValue);
}
return;
}
/////////////////////////////////////////////////////
}
private void ly_purchase_prepareforplanDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
//if (CheckFinished()) return;
DataGridView dgv = sender as DataGridView;
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 != "")
{
/////////////////////////////////////////////////////////////////////////////////////////////
decimal oldQty = decimal.Parse(queryForm.OldValue);
decimal newQty = decimal.Parse(queryForm.NewValue);
decimal nowQty = decimal.Parse(this.lY_MaterielRequirementsDataGridView.CurrentRow.Cells["未排数量1"].Value.ToString());
if (newQty > (oldQty + nowQty))
{
MessageBox.Show("修改数量超出需求数量,操作取消", "注意");
return;
}
dgv.CurrentRow.Cells["需求数量"].Value = queryForm.NewValue;
SaveChanged();
return;
}
}
///////////////////////////////////////////////////////
}
private void bom_material_for_machine_baseDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (null == this.bom_material_for_machine_baseDataGridView.CurrentRow)
{
return;
}
string itemno = this.bom_material_for_machine_baseDataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
ChangeValue queryForm = new ChangeValue();
queryForm.Text = "请输入机器号";
queryForm.ChangeMode = "longstring";
queryForm.NewValue = "";
queryForm.ShowDialog();
if (queryForm.NewValue == "")
{
MessageBox.Show("机器号为空，不可添加！"); return;
}
string sql = "select id from ly_borrow_store where machine_num='" + queryForm.NewValue + "'";
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];
}
if (dt.Rows.Count > 0)
{
MessageBox.Show("该机器号在库中已经存在，不可添加！"); return;
}
this.lyborrowstoreBindingSource.AddNew();
this.ly_borrow_store_Grid.CurrentRow.Cells["wzbh"].Value = itemno;
this.ly_borrow_store_Grid.CurrentRow.Cells["machine_num"].Value = queryForm.NewValue;
SaveChanged();
}
private void ly_plan_getmaterialDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (Check_ifApproved(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString()))
{
MessageBox.Show("计划已经批准,不能改动...", "注意");
return;
}
if ("True" == this.ly_material_plan_mainDataGridView.CurrentRow.Cells["启用"].Value.ToString())
{
MessageBox.Show("领料计划已经审批,不能修改条目...", "注意");
return;
}
DataGridView dgv = sender as DataGridView;
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;
this.ly_plan_getmaterialDataGridView.EndEdit();
this.lyplangetmaterialPlanToolBindingSource.EndEdit();
this.ly_plan_getmaterialPlan_ToolTableAdapter.Update(this.lYPlanMange.ly_plan_getmaterialPlan_Tool);
}
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_material_plan_detailDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (ly_material_plan_detailDataGridView.CurrentRow == null)
{
return;
}
try
{
string plan_count = ly_material_plan_detailDataGridView.CurrentRow.Cells["数量"].Value.ToString();
string done_count = ly_material_plan_detailDataGridView.CurrentRow.Cells["完成数量"].Value.ToString();
if (!SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "装配工单关闭"))
{
MessageBox.Show("无装配工单关闭权限！"); return;
}
DataGridView dgv = sender as DataGridView;
if ("close_count" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
if (queryForm.NewValue.Trim() == "0")
{
decimal count = 0;
if (string.IsNullOrEmpty(dgv.CurrentCell.Value.ToString()))
{
count = 0;
}
else
{
count = decimal.Parse(dgv.CurrentCell.Value.ToString());
}
dgv.CurrentRow.Cells["close_count"].Value = 0;
dgv.CurrentRow.Cells["close_peo"].Value = SQLDatabase.nowUserName();
dgv.CurrentRow.Cells["数量"].Value = decimal.Parse(plan_count) + count;
dgv.CurrentRow.Cells["close_time"].Value = DateTime.Now;
}
else
{
decimal count = decimal.Parse(queryForm.NewValue);
if ((decimal.Parse(plan_count) - decimal.Parse(done_count)) < count)
{
MessageBox.Show("关闭数量超过未完成数量！"); return;
}
dgv.CurrentRow.Cells["close_count"].Value = count;
dgv.CurrentRow.Cells["close_peo"].Value = SQLDatabase.nowUserName();
dgv.CurrentRow.Cells["数量"].Value = decimal.Parse(plan_count) - count;
dgv.CurrentRow.Cells["close_time"].Value = DateTime.Now;
}
}
this.ly_material_plan_detailDataGridView.EndEdit();
this.ly_material_plan_detailBindingSource.EndEdit();
this.ly_material_plan_detailTableAdapter.Update(this.lYProductMange.ly_material_plan_detail);
if (null != this.ly_material_plan_mainDataGridView.CurrentRow)
{
int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["parentid"].Value.ToString());
this.ly_material_plan_detailTableAdapter.Fill(this.lYProductMange.ly_material_plan_detail, parentId, "01");
}
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString()); return;
}
}
private void ly_store_outDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (CheckFinished())
{
return;
}
if ("True" == this.ly_store_outDataGridView.CurrentRow.Cells["签证"].Value.ToString())
{
MessageBox.Show("已经签证，不能修改(实需删除，请先删除签证标记)", "注意");
return;
}
string nowoperptar = this.ly_store_outDataGridView.CurrentRow.Cells["发料人"].Value.ToString();
if (nowoperptar != SQLDatabase.nowUserName())
{
MessageBox.Show("请发料人:" + nowoperptar + "修改", "注意");
return;
}
DataGridView dgv = sender as DataGridView;
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;
/////////////////////////////////////////////////////////////////////////////////////////////
decimal request_count;
decimal hadget_count;
if (!string.IsNullOrEmpty(this.ly_production_order_materialrequisitionDataGridView.CurrentRow.Cells["数量5"].Value.ToString()))
{
request_count = decimal.Parse(this.ly_production_order_materialrequisitionDataGridView.CurrentRow.Cells["数量5"].Value.ToString());
}
else
{
request_count = 0;
}
//if (!string.IsNullOrEmpty(this.ly_production_order_inspectionAll_InstoreDataGridView.CurrentRow.Cells["入库数量0"].Value.ToString()))
//{
// instore_count = decimal.Parse(this.ly_production_order_inspectionAll_InstoreDataGridView.CurrentRow.Cells["入库数量0"].Value.ToString());
//}
//else
//{
// instore_count = 0;
//}
hadget_count = 0;
if (null != this.ly_store_outDataGridView.CurrentRow)
{
foreach (DataGridViewRow dgr in ly_store_outDataGridView.Rows)
{
if (string.IsNullOrEmpty(dgr.Cells["领料数量"].Value.ToString()))
{
continue;
}
hadget_count = hadget_count + decimal.Parse(dgr.Cells["领料数量"].Value.ToString());
}
}
if (hadget_count >= request_count)
{
MessageBox.Show("该领料单数量已全部领完,不能增加领料出库记录", "注意");
if (string.IsNullOrEmpty(queryForm.OldValue))
{
dgv.CurrentRow.Cells["领料数量"].Value = DBNull.Value;
}
else
{
dgv.CurrentRow.Cells["领料数量"].Value = queryForm.OldValue;
}
return;
}
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)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "datetime";
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;
/////////////////////////////////////
//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)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
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)
//{
// string sel;
// sel = "SELECT yhmc as 姓名 FROM T_users where bumen='000401'";
// 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["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;
//}
/////////////////////////////////////////////////////////
}
private void ly_material_plan_detailDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
string planNum = this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString();
int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
if (Check_ifApproved(planNum))
{
MessageBox.Show("计划已经批准,不能修改数据...", "注意");
return;
}
DataGridView dgv = sender as DataGridView;
if ("编号" == dgv.CurrentCell.OwningColumn.Name)
{
return;
if (Check_ifApproved(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString()))
{
MessageBox.Show("计划已经批准,不能改动...", "注意");
return;
}
//string componentNum = this.lY_dayget_material_selDataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
//int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
//string planNum = this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString();
//string componentNum = this.lY_dayget_material_selDataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
//int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
//string prod_dept = SQLDatabase.nowUserDepartmentBig();
string sel = "SELECT wzbh as 编号,mch as 名称,xhc as 型号,gg as 规格 FROM ly_inma0010";
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 (!string.IsNullOrEmpty(queryForm.Result))
{
dgv.CurrentRow.Cells["编号"].Value = queryForm.Result;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
return;
}
//int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
//string planNum = this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString();
this.lY_restructuring_material_selTableAdapter.Fill(this.lYPlanMange.LY_restructuring_material_sel, parentId);
this.ly_restructuring_plan_detail_AlldeptTableAdapter.Fill(this.lYProductMange.ly_restructuring_plan_detail_Alldept, parentId);
}
if ("改前编码" == dgv.CurrentCell.OwningColumn.Name)
{
return;
if (Check_ifApproved(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString()))
{
MessageBox.Show("计划已经批准,不能改动...", "注意");
return;
}
//string componentNum = this.lY_dayget_material_selDataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
//int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
//string planNum = this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString();
//string componentNum = this.lY_dayget_material_selDataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
//int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
//string prod_dept = SQLDatabase.nowUserDepartmentBig();
string sel = "SELECT wzbh as 编号,mch as 名称,xhc as 型号,gg as 规格 FROM ly_inma0010";
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 (!string.IsNullOrEmpty(queryForm.Result))
{
dgv.CurrentRow.Cells["改前编码"].Value = queryForm.Result;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
return;
}
//int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
//string planNum = this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString();
this.lY_restructuring_material_selTableAdapter.Fill(this.lYPlanMange.LY_restructuring_material_sel, parentId);
this.ly_restructuring_plan_detail_AlldeptTableAdapter.Fill(this.lYProductMange.ly_restructuring_plan_detail_Alldept, parentId);
}
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;
SaveChanged();
}
else
{
}
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;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
else
{
}
return;
}
}
private void ly_machinepart_processDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (ly_inma0010_sortDataGridView.CurrentRow == null)
{
return;
}
DataGridView dgv = sender as DataGridView;
if ("standard_time" == 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["standard_time"].Value = queryForm.NewValue;
SaveChanged();
}
return;
}
if ("optimize_time" == 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["optimize_time"].Value = queryForm.NewValue;
SaveChanged();
}
return;
}
if ("True" == ly_inma0010_sortDataGridView.CurrentRow.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;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
}
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)
{
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;
SaveChanged();
}
else
{
}
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;
SaveChanged();
//CountPlanStru();
}
else
{
}
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;
SaveChanged();
//CountPlanStru();
}
else
{
}
return;
}
/////////////////////////////////////////////////////
if ("外协标识" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == dgv.CurrentRow.Cells["外协标识"].Value.ToString())
{
dgv.CurrentRow.Cells["外协标识"].Value = "False";
}
else
{
dgv.CurrentRow.Cells["外协标识"].Value = "True";
}
SaveChanged();
return;
}
/////////////////////////////////////////////////////
if ("加工说明" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["加工说明"].Value = queryForm.NewValue;
SaveChanged();
}
else
{
}
return;
}
/////////////////////////////////////////////////////
}
private void CountPlanStru()
{
if (null == this.ly_material_plan_mainDataGridView.CurrentRow)
{
return;
}
if ("True" == this.ly_material_plan_mainDataGridView.CurrentRow.Cells["启用"].Value.ToString())
{
MessageBox.Show("改型号计划已经审批,不能增加条目...", "注意");
return;
}
int qty = 0;
ChangeValue queryForm = new ChangeValue();
queryForm.Text = "改型号数量";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
try
{
qty = int.Parse(queryForm.NewValue);
}
catch (Exception ex)
{
MessageBox.Show("数量只能为正数...", "注意");
return;
}
finally { }
}
else
{
MessageBox.Show("数量不能为空...", "注意");
return;
}
string planNum = this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString();
string componentNum = this.lY_dayget_material_selDataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
string prod_dept = SQLDatabase.nowUserDepartmentBig();
NewFrm.Show(this);
SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@number", SqlDbType.Int);
cmd.Parameters["@number"].Value = qty;
cmd.Parameters.Add("@planId", SqlDbType.Int);
cmd.Parameters["@planId"].Value = parentId;
cmd.Parameters.Add("@prod_dept", SqlDbType.VarChar);
cmd.Parameters["@prod_dept"].Value = prod_dept;
cmd.Parameters.Add("@itemno", SqlDbType.VarChar);
cmd.Parameters["@itemno"].Value = componentNum;
cmd.CommandText = "LY_Dayget_input_GXH";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
this.lY_dayget_material_sel_newTableAdapter.Fill(this.lYPlanMange.LY_dayget_material_sel_new, parentId, SQLDatabase.nowUserDepartment());
this.ly_plan_getmaterialPlanGxhOutTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterialPlanGxhOut, planNum);
this.ly_plan_getmaterialPlanGxhInTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterialPlanGxhIn, planNum);
NewFrm.Hide(this);
}
private void ly_store_outDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (null == this.ly_store_outnumDataGridView.CurrentRow)
{
return;
}
if (null == this.ly_store_outDataGridView.CurrentRow)
{
return;
}
if (SQLDatabase.nowUserName() != ly_store_outnumDataGridView.CurrentRow.Cells["发料人"].Value.ToString())
{
MessageBox.Show("请发料人:" + ly_store_outnumDataGridView.CurrentRow.Cells["发料人"].Value.ToString() + " 修改");
return;
}
if ("True" == ly_store_outnumDataGridView.CurrentRow.Cells["finished"].Value.ToString())
{
MessageBox.Show("已经签证,领料单不能修改...");
return;
}
if ("领料数量" == dgv.CurrentCell.OwningColumn.Name)
{
if (dgv.CurrentRow.Cells["仓库类别"].Value.ToString() == "成品")
{
MessageBox.Show("成品数量不可以修改...");
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
if (decimal.Parse(queryForm.NewValue) < 0)
{
MessageBox.Show("领料数量必须大于0..."); return;
}
dgv.CurrentRow.Cells["领料数量"].Value = queryForm.NewValue;
}
else
{
}
this.ly_store_outDataGridView.EndEdit();
this.Validate();
this.ly_Restructuring_outBindingSource.EndEdit();
this.ly_Restructuring_outTableAdapter.Update(this.lYStoreMange.ly_Restructuring_out);
reLoad();
return;
}
}
private void ly_machinepart_processDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
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)
{
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)
{
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;
SaveChanged();
//CountPlanStru();
}
else
{
}
return;
}
/////////////////////////////////////////////////////
if ("加工说明" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["加工说明"].Value = queryForm.NewValue;
SaveChanged();
}
else
{
}
return;
}
/////////////////////////////////////////////////////
}
private void ly_store_in_ylDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
return;
DataGridView dgv = sender as DataGridView;
if ("True" == ly_store_innum_purchaseDataGridView.CurrentRow.Cells["签证"].Value.ToString())
{
MessageBox.Show("已经签证,入库信息不能修改...");
return;
}
if (SQLDatabase.nowUserName() != (ly_store_innum_purchaseDataGridView.CurrentRow.Cells["收料人"].Value.ToString()))
{
MessageBox.Show("请收料人:" + ly_store_innum_purchaseDataGridView.CurrentRow.Cells["收料人"].Value.ToString() + " 修改");
return;
}
if ("入库数量" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
//decimal oldnum = decimal.Parse(dgv.CurrentCell.Value.ToString());
//decimal notinnum = decimal.Parse(dgv.CurrentRow.Cells["storecount"].Value.ToString());
//decimal stanterdnum = 0;
//if (null != this.ly_plan_getmaterialDataGridView.CurrentRow)
//{
// stanterdnum = decimal.Parse(this.ly_plan_getmaterialDataGridView.CurrentRow.Cells["未领数量"].Value.ToString());
//}
if (queryForm.NewValue != "")
{
//decimal newnum = decimal.Parse(queryForm.NewValue);
//if ((newnum - oldnum) > storenum)
//{
// MessageBox.Show("库存不足,操作取消...");
//}
//else if (newnum - oldnum > stanterdnum)
//{
// MessageBox.Show("领料超计划,操作取消...");
//}
//else
//{
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;
}
/////////////////////////////////////////////////////
}
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_bm0031DataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
string nowgeometry;
//decimal nowspecific_weight;
//decimal nowdiameter;
//decimal nowlength;
//decimal nowwidth;
//decimal nowheight;
if (!string.IsNullOrEmpty(this.ly_bm0031DataGridView.CurrentRow.Cells["geometry"].Value.ToString()))
{
nowgeometry = this.ly_bm0031DataGridView.CurrentRow.Cells["geometry"].Value.ToString();
}
else
{
nowgeometry = "ELSE";
}
//if (!string.IsNullOrEmpty(this.ly_machinepart_process_workDataGridView.Rows[this.ly_machinepart_process_workDataGridView.RowCount - 1].Cells["本序可用"].Value.ToString()))
//{
// canuse_count = decimal.Parse(this.ly_machinepart_process_workDataGridView.Rows[this.ly_machinepart_process_workDataGridView.RowCount - 1].Cells["本序可用"].Value.ToString());
//}
//else
//{
// canuse_count = 0;
//}
////////////////////////////
if ("qty_set" == 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["qty_set"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
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 ("oper_dept" == dgv.CurrentCell.OwningColumn.Name)
//{
// 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["oper_dept"].Value = queryForm.Result; ;
// SaveChanged();
// return;
//}
////////////////////////////////////////////////////////
/////////////////////////////////////////////////////
if ("out_prod" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" != dgv.CurrentRow.Cells["out_prod"].Value.ToString())
{
string message = "确定出制单(领料单)吗?";
string caption = "提示...";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, caption, buttons,
MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.Yes)
{
//dgv.CurrentRow.Cells["discount_money"].Value = dgv.CurrentRow.Cells["apply_money"].Value;
dgv.CurrentRow.Cells["out_prod"].Value = "True";
SaveChanged();
}
}
else
{
string message = "取消出制单(领料单)吗?";
string caption = "提示...";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, caption, buttons,
MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.Yes)
{
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["apply_money"].Value = DBNull.Value;
dgv.CurrentRow.Cells["out_prod"].Value = "False";
SaveChanged();
}
}
return;
}
///////////////////////////////////////////////////
if ("qty_set_waste" == 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["qty_set_waste"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SetUseNum(nowgeometry);
SaveChanged();
}
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 ("diameter" == dgv.CurrentCell.OwningColumn.Name)
{
if ("ELSE" == nowgeometry)
{
return;
}
if ("棒料" != nowgeometry)
{
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["diameter"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SetUseNum(nowgeometry);
SaveChanged();
}
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 ("length" == dgv.CurrentCell.OwningColumn.Name)
{
if ("ELSE" == nowgeometry)
{
return;
}
//if ("圆柱体" != nowgeometry) return;
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["length"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
SetUseNum(nowgeometry);
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
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 ("width" == dgv.CurrentCell.OwningColumn.Name)
{
if ("ELSE" == nowgeometry)
{
return;
}
if ("板料" != nowgeometry)
{
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["width"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
SetUseNum(nowgeometry);
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
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 ("height" == dgv.CurrentCell.OwningColumn.Name)
{
if ("ELSE" == nowgeometry)
{
return;
}
if ("板料" != nowgeometry)
{
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["height"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
SetUseNum(nowgeometry);
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
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 ("input_count" == dgv.CurrentCell.OwningColumn.Name)
{
if ("ELSE" == nowgeometry)
{
return;
}
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["input_count"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
SetUseNum(nowgeometry);
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
}
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 ("pf" == dgv.CurrentCell.OwningColumn.Name)
{
//if (!HaveRight(SQLDatabase.NowUserID, "管理费优惠批准"))
//{
// MessageBox.Show("没有管理费优惠批准权限...", "注意");
// return;
//}
if ("True" != dgv.CurrentRow.Cells["pf"].Value.ToString())
{
string message = "设定物料出库吗？";
string caption = "提示...";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, caption, buttons,
MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.Yes)
{
//dgv.CurrentRow.Cells["discount_money"].Value = dgv.CurrentRow.Cells["apply_money"].Value;
dgv.CurrentRow.Cells["pf"].Value = "True";
SaveChanged();
}
}
else
{
string message = "取消物料出库吗？";
string caption = "提示...";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, caption, buttons,
MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.Yes)
{
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["apply_money"].Value = DBNull.Value;
dgv.CurrentRow.Cells["pf"].Value = "False";
SaveChanged();
}
}
return;
}
/////////////////////////////////////////////////////
}
private void ly_production_task_inspectionDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if ("True" == dgv.CurrentRow.Cells["入库"].Value.ToString())
{
MessageBox.Show("已经入库，不能修改(实需修改，请先删除该质检单号的入库记录)", "注意");
return;
}
string inspector = this.ly_production_task_inspectionDataGridView.CurrentRow.Cells["质检人"].Value.ToString();
//if (inspector != SQLDatabase.nowUserName())
//{
// MessageBox.Show("请质检员:" + inspector + "修改", "注意");
// return;
//}
if ("合格" == dgv.CurrentCell.OwningColumn.Name)
{
if (string.IsNullOrEmpty(dgv.CurrentRow.Cells["设备编号"].Value.ToString()))
{
MessageBox.Show("无设备编号,不能设置合格标记...", "注意");
return;
}
if ("True" == dgv.CurrentRow.Cells["合格"].Value.ToString())
{
dgv.CurrentRow.Cells["合格"].Value = "False";
dgv.CurrentRow.Cells["质检人"].Value = DBNull.Value;
dgv.CurrentRow.Cells["质检日期"].Value = DBNull.Value;
dgv.CurrentRow.Cells["质检单号"].Value = DBNull.Value;
}
else
{
dgv.CurrentRow.Cells["合格"].Value = "True";
dgv.CurrentRow.Cells["质检人"].Value = SQLDatabase.nowUserName();
dgv.CurrentRow.Cells["质检日期"].Value = SQLDatabase.GetNowdate();
dgv.CurrentRow.Cells["质检单号"].Value = GetMaxTaskInspection();
if (!string.IsNullOrEmpty(dgv.CurrentRow.Cells["质检次数"].Value.ToString()))
{
dgv.CurrentRow.Cells["质检次数"].Value = int.Parse(dgv.CurrentRow.Cells["质检次数"].Value.ToString()) + 1;
}
else
{
dgv.CurrentRow.Cells["质检次数"].Value = 1;
}
}
SaveChanged();
return;
}
if ("质检日期" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "datetime";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["质检日期"].Value = queryForm.NewValue;
}
else
{
dgv.CurrentRow.Cells["质检日期"].Value = DBNull.Value;
}
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;
if (int.Parse(queryForm.NewValue) == 1)
{
dgv.CurrentRow.Cells["初检"].Value = "True";
}
else
{
dgv.CurrentRow.Cells["初检"].Value = "False";
}
}
else
{
dgv.CurrentRow.Cells["质检次数"].Value = DBNull.Value;
dgv.CurrentRow.Cells["初检"].Value = "False";
}
SaveChanged();
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 != "")
{
dgv.CurrentRow.Cells["设备编号"].Value = queryForm.NewValue;
}
else
{
dgv.CurrentRow.Cells["设备编号"].Value = DBNull.Value;
}
SaveChanged();
return;
}
if ("质检意见" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["质检意见"].Value = queryForm.NewValue;
}
else
{
dgv.CurrentRow.Cells["质检意见"].Value = DBNull.Value;
}
SaveChanged();
return;
}
}
private void ly_material_plan_detailDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (Check_ifApproved(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["计划编号"].Value.ToString()))
{
MessageBox.Show("计划已经批准,不能改动...", "注意");
return;
}
if ("True" == this.ly_material_plan_mainDataGridView.CurrentRow.Cells["启用"].Value.ToString())
{
MessageBox.Show("领料计划已经审批,不能修改条目...", "注意");
return;
}
DataGridView dgv = sender as DataGridView;
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
{
//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)
{
//ChangeValue queryForm = new ChangeValue();
//queryForm.OldValue = dgv.CurrentCell.Value.ToString();
//queryForm.NewValue = "";
//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();
//}
//else
//{
//}
//return;
//////////////////
string sel = "SELECT a.prodname as 编码,a.prodcode 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;
SaveChanged();
return;
}
}
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_inma0010DataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (null == dgv.CurrentRow)
{
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 main_Id = int.Parse(dgv.CurrentRow.Cells["id"].Value.ToString());
string updstr = " update ly_inma0010 " +
" set sales_price= " + queryForm.NewValue + " where id=" + main_Id.ToString();
SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = updstr;
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
int temp = 0;
using (TransactionScope scope = new TransactionScope())
{
sqlConnection1.Open();
try
{
cmd.ExecuteNonQuery();
scope.Complete();
}
catch (SqlException sqle)
{
MessageBox.Show(sqle.Message.Split('*')[0]);
}
finally
{
sqlConnection1.Close();
}
}
}
return;
}
////////////////////////////////////////////////////////////////////////////////////
if ("产品折扣" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
int main_Id = int.Parse(dgv.CurrentRow.Cells["id"].Value.ToString());
string updstr;
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["产品折扣"].Value = queryForm.NewValue;
updstr = " update ly_inma0010 " +
" set product_discount= " + queryForm.NewValue + " where id=" + main_Id.ToString();
}
else
{
dgv.CurrentRow.Cells["产品折扣"].Value = DBNull.Value;
updstr = " update ly_inma0010 " +
" set product_discount= null where id=" + main_Id.ToString();
}
SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = updstr;
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
int temp = 0;
using (TransactionScope scope = new TransactionScope())
{
sqlConnection1.Open();
try
{
cmd.ExecuteNonQuery();
scope.Complete();
}
catch (SqlException sqle)
{
MessageBox.Show(sqle.Message.Split('*')[0]);
}
finally
{
sqlConnection1.Close();
}
}
return;
}
///////////////////////////////////////////////////////
}
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (null == this.dataGridView2.CurrentRow)
{
return;
}
if (null == this.dataGridView1.CurrentRow)
{
return;
}
if (SQLDatabase.nowUserName() != dataGridView2.CurrentRow.Cells["收料人_T"].Value.ToString())
{
MessageBox.Show("请收料人:" + dataGridView2.CurrentRow.Cells["收料人_T"].Value.ToString() + " 修改");
return;
}
if ("True" == dataGridView2.CurrentRow.Cells["签证_T"].Value.ToString())
{
MessageBox.Show("已经签证,退料单不能修改...");
return;
}
if ("领料数量_T" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
if (decimal.Parse(queryForm.NewValue) > 0)
{
MessageBox.Show("退料数量填写负数..."); return;
}
dgv.CurrentRow.Cells["领料数量_T"].Value = queryForm.NewValue;
}
else
{
}
this.dataGridView1.EndEdit();
this.Validate();
this.ly_Restructuring_inBindingSource.EndEdit();
this.ly_Restructuring_inTableAdapter.Update(this.lYStoreMange.ly_Restructuring_in);
reLoad();
if (dataGridView2.Rows.Count == 0)
{
if (null != this.ly_production_orderDataGridView.CurrentRow)
{
string taskMumber = this.ly_production_orderDataGridView.CurrentRow.Cells["任务单号"].Value.ToString();
string workName = ly_production_orderDataGridView.CurrentRow.Cells["工人"].Value.ToString();
ly_store_in_production_returnSingleTableAdapter.Fill(this.lYSalseRepair.ly_store_in_production_returnSingle, workName, taskMumber, SQLDatabase.NowUserID);
}
}
return;
}
}
private void ly_sales_outbindDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (null == dgv.CurrentRow)
{
return;
}
if ("数量fh" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "value";
queryForm.ShowDialog();
string borrowitemno = dgv.CurrentRow.Cells["成品编码fh"].Value.ToString();
decimal oldnum;
if ("" != dgv.CurrentCell.Value.ToString())
{
oldnum = decimal.Parse(dgv.CurrentCell.Value.ToString());
}
else
{
oldnum = 0;
}
decimal borrowqty;
if ("" != this.ly_sales_borrow_detail_clientDataGridView.CurrentRow.Cells["未还数量jy"].Value.ToString())
{
borrowqty = decimal.Parse(this.ly_sales_borrow_detail_clientDataGridView.CurrentRow.Cells["未还数量jy"].Value.ToString());
}
else
{
borrowqty = 0;
}
if (queryForm.NewValue != "")
{
decimal newnum = decimal.Parse(queryForm.NewValue);
if (newnum > borrowqty + oldnum)
{
MessageBox.Show("数量超出未还数量,操作取消...");
}
else
{
dgv.CurrentRow.Cells["数量fh"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
this.ly_sales_outbindDataGridView.EndEdit();
this.ly_sales_outbindBindingSource.EndEdit();
this.ly_sales_outbindTableAdapter.Update(this.lYSalseMange.ly_sales_outbind);
ly_sales_contract_detail_sumDataGridView.SelectionChanged -= ly_sales_contract_detail_sumDataGridView_SelectionChanged;
this.ly_sales_outbindTableAdapter.Fill(this.lYSalseMange.ly_sales_outbind, this.innercode);
this.ly_sales_outbindBindingSource.Position = this.ly_sales_outbindBindingSource.Find("成品编码", borrowitemno);
ly_sales_contract_detail_sumDataGridView.SelectionChanged += ly_sales_contract_detail_sumDataGridView_SelectionChanged;
this.ly_sales_contract_detail_sumTableAdapter.Fill(this.lYSalseMange.ly_sales_contract_detail_sum, this.innercode, this.fromwhere);
this.ly_sales_contract_detail_sumBindingSource.Position = this.ly_sales_contract_detail_sumBindingSource.Find("产品编码", borrowitemno);
this.ly_sales_borrow_detail_clientTableAdapter.Fill(this.lYSalseMange.ly_sales_borrow_detail_client, clientcode, borrowitemno);
}
// 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;
}
/////////////////////////////////////////////////////
//////////////////////////////////////////////////////////
}
private void ly_purchase_partDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (null == this.ly_purchase_partDataGridView.CurrentRow)
{
return;
}
DataGridView dgv = sender as DataGridView;
///////////////////////////////////////////////////////
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();
}
return;
}
/////////////////////////////
/////////////////////////////
if ("入库" == dgv.CurrentCell.OwningColumn.Name)
{
if ("True" == dgv.CurrentRow.Cells["入库"].Value.ToString())
{
dgv.CurrentRow.Cells["入库"].Value = "False";
dgv.Rows[dgv.Rows.Count - 1].Cells["入库"].Value = "True";
}
else
{
foreach (DataGridViewRow dgr in dgv.Rows)
{
dgr.Cells["入库"].Value = "False";
}
dgv.CurrentRow.Cells["入库"].Value = "True";
}
SaveChanged();
return;
}
///////////////////////////////////////////////////////
}
private void ly_production_order_inspectionDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (CheckFinished())
{
return;
}
DataGridView dgv = sender as DataGridView;
if ("送检数量8" == 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["送检数量8"].Value = queryForm.NewValue;
///////////////////////////////////////////////////////////////////////////////////////////////
//if (!string.IsNullOrEmpty(queryForm.NewValue))
//{
// inspect_count = decimal.Parse(queryForm.NewValue);
//}
//else
//{
// inspect_count = 0;
//}
//if (!string.IsNullOrEmpty(dgv.CurrentRow.Cells["合格数量8"].Value.ToString()))
//{
// qualified_count = decimal.Parse(dgv.CurrentRow.Cells["合格数量8"].Value.ToString());
//}
//else
//{
// qualified_count = 0;
//}
//if (!string.IsNullOrEmpty(dgv.CurrentRow.Cells["可用数量8"].Value.ToString()))
//{
// canuse_count = decimal.Parse(dgv.CurrentRow.Cells["可用数量8"].Value.ToString());
//}
//else
//{
// canuse_count = 0;
//}
//waste_count = inspect_count - qualified_count - canuse_count;
//decimal send_inspect_count = 0;
//if (null != this.ly_production_order_inspectionAll_MainDataGridView.CurrentRow)
//{
// foreach (DataGridViewRow dgr in ly_production_order_inspectionAll_MainDataGridView.Rows)
// {
// if (string.IsNullOrEmpty(dgr.Cells["送检"].Value.ToString())) continue;
// send_inspect_count = send_inspect_count + decimal.Parse(dgr.Cells["送检"].Value.ToString());
// }
//}
//if (1 > inspect_count)
//{
// MessageBox.Show("末序无序检记录,不能增加总检记录", "注意");
// return;
//}
//if (send_inspect_count >= inspect_count)
//{
// //dgv.CurrentRow.Cells["送检"].Value = queryForm.OldValue;
// if (string.IsNullOrEmpty(queryForm.OldValue))
// {
// dgv.CurrentRow.Cells["送检"].Value = DBNull.Value;
// }
// else
// {
// dgv.CurrentRow.Cells["送检"].Value = queryForm.OldValue;
// }
// MessageBox.Show("末序数量已经全部送交总检,不能增加总检记录", "注意");
// return;
//}
////////////////////////////////////////////////////////////////////////////////////////////
if (!CheckInput(dgv))
{
if (string.IsNullOrEmpty(queryForm.OldValue))
{
dgv.CurrentRow.Cells["送检数量8"].Value = DBNull.Value;
}
else
{
dgv.CurrentRow.Cells["送检数量8"].Value = queryForm.OldValue;
}
return;
}
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 ("合格数量8" == 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["合格数量8"].Value = queryForm.NewValue;
if (!CheckInput(dgv))
{
if (string.IsNullOrEmpty(queryForm.OldValue))
{
dgv.CurrentRow.Cells["合格数量8"].Value = DBNull.Value;
}
else
{
dgv.CurrentRow.Cells["合格数量8"].Value = queryForm.OldValue;
}
return;
}
SaveChanged();
}
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)
// {
// ChangeValue queryForm = new ChangeValue();
// queryForm.OldValue = dgv.CurrentCell.Value.ToString();
// queryForm.NewValue = "";
// queryForm.ChangeMode = "datetime";
// 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;
// /////////////////////////////////////
// //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 ("检验说明8" == dgv.CurrentCell.OwningColumn.Name)
{
ChangeValue queryForm = new ChangeValue();
queryForm.OldValue = dgv.CurrentCell.Value.ToString();
queryForm.NewValue = "";
queryForm.ChangeMode = "longstring";
queryForm.ShowDialog();
if (queryForm.NewValue != "")
{
dgv.CurrentRow.Cells["检验说明8"].Value = queryForm.NewValue;
//dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
//dgv.CurrentRow.Cells["approve_flag"].Value = "False";
SaveChanged();
//CountPlanStru();
}
else
{
}
return;
}
///////////////////////////////////////////////////////
//if ("可用数量8" == 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["可用数量8"].Value = queryForm.NewValue;
// if (!CheckCanuse(dgv))
// {
// if (string.IsNullOrEmpty(queryForm.OldValue))
// {
// dgv.CurrentRow.Cells["可用数量8"].Value = DBNull.Value;
// }
// else
// {
// dgv.CurrentRow.Cells["可用数量8"].Value = queryForm.OldValue;
// }
// return;
// }
// dgv.CurrentRow.Cells["审查日期8"].Value = SQLDatabase.GetNowdate().ToString();
// 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 ("审查意见8" == dgv.CurrentCell.OwningColumn.Name)
//{
// ChangeValue queryForm = new ChangeValue();
// queryForm.OldValue = dgv.CurrentCell.Value.ToString();
// queryForm.NewValue = "";
// queryForm.ChangeMode = "longstring";
// queryForm.ShowDialog();
// if (queryForm.NewValue != "")
// {
// dgv.CurrentRow.Cells["审查意见8"].Value = queryForm.NewValue;
// //dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
// //dgv.CurrentRow.Cells["approve_flag"].Value = "False";
// SaveChanged();
// //CountPlanStru();
// }
// else
// {
// }
// return;
//}
///////////////////////////////
///////////////////////////////////////////////////////////////////////////////////
//if ("审查日期8" == dgv.CurrentCell.OwningColumn.Name)
//{
// ChangeValue queryForm = new ChangeValue();
// queryForm.OldValue = dgv.CurrentCell.Value.ToString();
// queryForm.NewValue = "";
// queryForm.ChangeMode = "datetime";
// queryForm.ShowDialog();
// if (queryForm.NewValue != "")
// {
// dgv.CurrentRow.Cells["审查日期8"].Value = queryForm.NewValue;
// //dgv.CurrentRow.Cells["discount_money"].Value = DBNull.Value;
// //dgv.CurrentRow.Cells["approve_flag"].Value = "False";
// SaveChanged();
// //CountPlanStru();
// }
// else
// {
// }
// return;
//}
///////////////////////////////////////
}
