/// <summary> /// 绑定仓库位 /// </summary> private void BindGridSBit() { if (gridView1.RowCount > 0) { SBitRule rule = new SBitRule(); string Str = string.Empty; Str = " AND WHID=" + SysString.ToDBString(txtWHID.Text.Trim()); Str += " AND SectionID=" + SysString.ToDBString(SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SectionID"))); gridView3.GridControl.DataSource = rule.RShow(Str, ProcessGrid.GetQueryField(gridView3)); gridView3.GridControl.Show(); txtWHIDBit.Text = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "WHID")); txtSectionIDBit.Text = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SectionID")); } }
/// <summary> /// 删除位 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDeleteBit_Click(object sender, EventArgs e) { try { if (txtSBit.Text.Trim() == "") { this.ShowMessage("请选择要删除的记录"); return; } if (DialogResult.Yes != this.ShowConfirmMessage("确定要删除本记录?")) { return; } SBitRule rule = new SBitRule(); SBit entity = new SBit(); entity.MainID = HTDataID; entity.WHID = txtWHID.Text.Trim(); entity.SectionID = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SectionID").ToString(); entity.SBitID = txtSBit.Text.Trim(); //entity.OldSBitID = txtSBit.Text.Trim(); rule.RDelete(entity); FCommon.AddDBLog(this.Text, "位删除", "ID:" + entity.SBitID, ""); string tempwhid = entity.WHID; BindGridSBit(); ProcessGrid.GridViewFocus(gridView1, new string[1] { "SectionID" }, new string[1] { entity.WHID }); ProcessGrid.GridViewFocus(gridView3, new string[1] { "SBitID" }, new string[1] { entity.SectionID }); // GridViewFocus(gridView3,new string[1]{"SBitID"},new string[1]{entity.SBitID}); // Common.AddDBLog(this.Text,OPType.删除,"ID:"+entity.OldSBitID.ToString(),"位"); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 更新位 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdateBit_Click(object sender, EventArgs e) { try { if (txtSBit.Text.Trim() == "") { this.ShowMessage("请选择要修改的记录"); return; } if (!CheckCorrectBit()) { return; } SBitRule rule = new SBitRule(); SBit entity = this.GetEntitySBit(); string OLDSBitID = SysConvert.ToString(gridView3.GetFocusedRowCellValue("SBitID")); //entity.MainID = HTDataID; //entity.WHID = txtWHID.Text.Trim(); //entity.SectionID = txtSectionIDBit.Text.Trim(); //entity.SBitID = txtSBit.Text.Trim(); rule.RUpdate(entity, OLDSBitID); FCommon.AddDBLog(this.Text, "位更新", "ID:" + entity.SBitID, "New ID:" + entity.SBitID); BindGridSBit(); //ProcessGrid.GridViewFocus(gridView1, new string[1] { "WHID" }, new string[1] { entity.WHID }); ProcessGrid.GridViewFocus(gridView1, new string[1] { "SectionID" }, new string[1] { entity.SectionID }); ProcessGrid.GridViewFocus(gridView3, new string[1] { "SBitID" }, new string[1] { entity.SBitID }); // Common.AddDBLog(this.Text,OPType.更新,"ID:"+entity.OldSBitID.ToString(),"位"); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 新增位 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnInsertBit_Click(object sender, EventArgs e) { try { if (!CheckCorrectBit()) { return; } SBitRule rule = new SBitRule(); SBit entity = this.GetEntitySBit(); if (SysConvert.ToInt32(drpWHPosMethodID.EditValue) == 1 || SysConvert.ToInt32(drpWHPosMethodID.EditValue) == 2) { this.ShowMessage("物理位置不包含位无法新增"); return; } else { rule.RAdd(entity); } FCommon.AddDBLog(this.Text, "位新增", "ID:" + entity.SBitID, ""); BindGridSBit(); // ProcessGrid.GridViewFocus(gridView1, new string[1] { "WHID" }, new string[1] { entity.WHID }); ProcessGrid.GridViewFocus(gridView1, new string[1] { "SectionID" }, new string[1] { entity.SectionID }); ProcessGrid.GridViewFocus(gridView3, new string[1] { "SBitID" }, new string[1] { entity.SBitID }); // Common.AddDBLog(this.Text,OPType.新增,"ID:"+entity.SBitID.ToString(),"位"); } catch (Exception E) { this.ShowMessage(E.Message); } }