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