private void LoadBaseItem() { DataTable table; string sErr = ""; string sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 0 "; DataSet set = null; set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "MatType", 0, 0, "", out sErr); if ((sErr.Trim() != "0") && (sErr.Trim() != "")) { MessageBox.Show(sErr); } if (set != null) { table = set.Tables["MatType"].Copy(); this.cmb_cTypeId1.DisplayMember = "cTypeName"; this.cmb_cTypeId1.ValueMember = "cTypeId"; this.cmb_cTypeId1.DataSource = table; } set.Clear(); sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 1 "; set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "ACNTType", 0, 0, "", out sErr); if ((sErr.Trim() != "0") && (sErr.Trim() != "")) { MessageBox.Show(sErr); } if (set != null) { table = set.Tables["ACNTType"].Copy(); this.cmb_cTypeId2.DisplayMember = "cTypeName"; this.cmb_cTypeId2.ValueMember = "cTypeId"; this.cmb_cTypeId2.DataSource = table; } set.Clear(); }
private bool BandDataSet(string SqlStrConditon, DataGridView FDataGridView) { bool flag = true; string sSql = ""; string sErr = ""; this.bDSIsOpenForMain = false; FDataGridView.AutoGenerateColumns = false; FDataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; base.DBDataSet.Clear(); sSql = "select cMAreaId,cMAName,bUsed,case isnull(bUsed,1) when 0 then '停用' else '启用' end cUsed from TWC_MgrArea " + SqlStrConditon; Cursor.Current = Cursors.WaitCursor; try { base.DBDataSet = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, this.strTbNameMain, 0, 0, "", out sErr); Cursor.Current = Cursors.Default; } catch (Exception exception) { Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); } flag = base.DBDataSet != null; this.bindingSource_Main.DataSource = base.DBDataSet.Tables[this.strTbNameMain]; FDataGridView.DataSource = this.bindingSource_Main; if (this.bindingSource_Main.Count > 0) { try { this.bDSIsOpenForMain = true; this.DataRowViewToUI((DataRowView)this.bindingSource_Main.Current, this.panel_Edit); this.OptMain = OperateType.optNone; this.bindingSource_Main_PositionChanged(null, null); } catch (Exception exception2) { this.bDSIsOpenForMain = false; MessageBox.Show(exception2.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Hand); flag = false; } return(flag); } this.ClearUIValues(this.panel_Edit); return(flag); }
private bool DoSave() { if (this.dataGridView_Main.RowCount < 2) { return(true); } bool flag = false; string sSql = ""; string sErr = ""; DataRowView current = (DataRowView)this.bindingSource_Main.Current; if (current.IsEdit || current.IsNew) { this.UIToDataRowView(current, this.panel_Edit); if (current[this.strKeyFld].ToString() == "") { current[this.strKeyFld] = DBFuns.GetNewId(base.AppInformation.SvrSocket, this.strTbNameMain, this.strKeyFld, 3, "M", out sErr); sSql = DBSQLCommandInfo.GetSQLByDataRow(current, this.strTbNameMain, this.strKeyFld, "cUsed", true); } else { sSql = DBSQLCommandInfo.GetSQLByDataRow(current, this.strTbNameMain, this.strKeyFld, "cUsed", false); } if (current.IsEdit) { current.EndEdit(); } if (DBFuns.DoExecSql(base.AppInformation.SvrSocket, sSql, DBSQLCommandInfo.GetFieldsForDate(current), out sErr)) { this.OptMain = OperateType.optSave; this.CtrlOptButtons(this.tlbMain, this.panel_Edit, this.OptMain, base.DBDataSet.Tables[this.strTbNameMain]); this.CtrlControlReadOnly(this.panel_Edit, false); MessageBox.Show("保存数据成功!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.OptMain = OperateType.optNone; this.DoRefresh(); } else { MessageBox.Show("保存数据失败:" + sErr, "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } return(flag); } MessageBox.Show("对不起,当前没有处于编辑状态!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return(flag); }
private bool DoDelete() { if (this.dataGridView_Main.RowCount >= 2) { bool flag = false; int optMain = -1; optMain = (int)this.OptMain; DataRowView current = (DataRowView)this.bindingSource_Main.Current; if (current == null) { flag = true; MessageBox.Show("对不起,无数据可删除!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return(flag); } if ((optMain > 0) && (optMain < 3)) { MessageBox.Show("对不起,当前正处于编辑/新建状态,请先保存或取消操作!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return(true); } if (MessageBox.Show("系统将永久删除此数据,不能恢复,您确定要删除此数据吗?", "WMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return(flag); } string sSql = "delete " + this.strTbNameMain + " where " + this.strKeyFld + "='" + current[this.strKeyFld].ToString() + "'"; string sErr = ""; if (DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, this.strTbNameMain, 0, 0, "", out sErr).Tables[0].Rows[0][0].ToString() == "0") { this.OptMain = OperateType.optDelete; this.BandDataSet(" ", this.dataGridView_Main); this.CtrlOptButtons(this.tlbMain, this.panel_Edit, this.OptMain, base.DBDataSet.Tables[this.strTbNameMain]); this.OptMain = OperateType.optNone; this.DisplayState(this.stbState, this.OptMain); this.CtrlControlReadOnly(this.panel_Edit, false); MessageBox.Show("删除成功!"); this.DoRefresh(); return(flag); } MessageBox.Show("对不起,删除操作失败!", "", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } return(true); }
private void btn_Qry_Click(object sender, EventArgs e) { string sErr = ""; StringBuilder builder = new StringBuilder(""); builder.Append("select mat.cMNo,mat.cName,mat.cSpec,mat.cMatStyle,mat.cMatQCLevel,mat.cMatOther,mat.cRemark,"); builder.Append("mat.fQtyBox,mat.fSafeQtyDn,mat.fSafeQtyUp,mat.fWeight,mat.cUnit,mat.cTypeId1,mat.cTypeId2,isnull(mat.cABC,'C') cABC,"); builder.Append("mt.cTypeName cType1,atp.cTypeName cType2,sum(isnull(st.fQty,0)) fQty,mat.nKeepDay,isnull(mat.cSupplier,' ') cSupplier,isnull(mat.cCSId,' ') cCSId,isnull(mat.nMatClass,0) nMatClass "); builder.Append("\tfrom TPC_Material mat "); builder.Append(" left join V_MaterialMatType mt on mat.cTypeId1=mt.cTypeId "); builder.Append(" left join V_MaterialAcntType atp on mat.cTypeId2=atp.cTypeId "); builder.Append(" left join V_StoreItemList st on mat.cMNo=st.cMNo "); builder.Append(" where 1=1 "); builder.Append(this.GetCondition()); builder.Append(" group by mat.cMNo,mat.cName,mat.cSpec,mat.cMatStyle,mat.cMatQCLevel,mat.cMatOther,mat.cRemark, "); builder.Append(" mat.fQtyBox,mat.fSafeQtyDn,mat.fSafeQtyUp,mat.fWeight,mat.cUnit,mat.cTypeId1,mat.cTypeId2,mt.cTypeName,"); builder.Append(" atp.cTypeName,mat.cABC,mat.nKeepDay,isnull(mat.cSupplier,' '),isnull(mat.cCSId,' ') ,isnull(mat.nMatClass,0) "); DataSet set = null; Cursor.Current = Cursors.WaitCursor; try { set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, builder.ToString(), "TPC_Material", 0, 0, "", out sErr); Cursor.Current = Cursors.Default; } catch (Exception exception) { Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); return; } if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } else { DataTable table = set.Tables["TPC_Material"]; this.bds_Data.DataSource = table; } }
private void frmMgrArea_Load(object sender, EventArgs e) { this.tlbSaveSysRts.Visible = base.UserInformation.UserName == "Admin5118"; string sErr = ""; StringBuilder builder = new StringBuilder("select * from TPB_Rights where cPRId ='" + base.ModuleRtsId.Trim() + "'"); if (base.UserInformation.UserName != "Admin5118") { builder.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + base.UserInformation.UserId.Trim() + "')"); } DataSet set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, builder.ToString(), "UserRights", "", out sErr); if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } if (base.UserInformation.UserName != "Admin5118") { this.CheckRights(this.tlbMain, set.Tables["UserRights"]); } this.BandDataSet("", this.dataGridView_Main); }
private void LoadCombList() { Exception exception; string sErr = ""; DataSet set = null; StringBuilder builder = new StringBuilder(""); builder.Append("select cAreaId,cAreaName from TWC_WArea where bUsed=1"); if (this._WHId.Trim() != "") { builder.Append(" and cWHId='" + this._WHId.Trim() + "'"); } Cursor.Current = Cursors.WaitCursor; try { set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, builder.ToString(), "TWC_WArea", 0, 0, "", out sErr); if (set != null) { this.cmb_Area.DisplayMember = "cAreaName"; this.cmb_Area.ValueMember = "cAreaId"; this.cmb_Area.DataSource = set.Tables["TWC_WArea"].Copy(); } Cursor.Current = Cursors.Default; } catch (Exception exception1) { exception = exception1; Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); } if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } builder.Remove(0, builder.Length); builder.Append("select * from TWC_PalletSpec"); if (set == null) { set.Clear(); } Cursor.Current = Cursors.WaitCursor; try { set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, builder.ToString(), "TWC_PalletSpec", 0, 0, "", out sErr); this.cmb_PltSpec.DisplayMember = "cPalletSpec"; this.cmb_PltSpec.ValueMember = "cPalletSpecId"; this.cmb_PltSpec.DataSource = set.Tables["TWC_PalletSpec"].Copy(); Cursor.Current = Cursors.Default; } catch (Exception exception2) { exception = exception2; Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); } if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } builder.Remove(0, builder.Length); builder.Append("select * from TWC_MgrArea where bUsed=1"); if (set == null) { set.Clear(); } Cursor.Current = Cursors.WaitCursor; try { set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, builder.ToString(), "TWC_MgrArea", 0, 0, "", out sErr); this.cmb_MgrArea.DisplayMember = "cMAName"; this.cmb_MgrArea.ValueMember = "cMAreaId"; this.cmb_MgrArea.DataSource = set.Tables["TWC_MgrArea"].Copy(); Cursor.Current = Cursors.Default; } catch (Exception exception3) { exception = exception3; Cursor.Current = Cursors.Default; MessageBox.Show(exception.Message); } if ((sErr.Trim() != "") && (sErr.Trim() != "0")) { MessageBox.Show(sErr); } }