/// <summary> /// 保存数据 /// </summary> /// <param name="table"></param> /// <returns></returns> public bool Save(DataTable table) { Hashtable SQLString = new Hashtable( ); LineProductMesEntityu.PowerEntity _model = new LineProductMesEntityu.PowerEntity( ); foreach (DataRow row in table.Rows) { _model.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]); _model.POW002 = row ["POW002"].ToString( ); _model.POW003 = row ["POW003"].ToString( ); _model.POW004 = string.IsNullOrEmpty(row ["POW004"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW004"]); _model.POW005 = string.IsNullOrEmpty(row ["POW005"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW005"]); _model.POW006 = string.IsNullOrEmpty(row ["POW006"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW006"]); _model.POW007 = string.IsNullOrEmpty(row ["POW007"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW007"]); _model.POW008 = string.IsNullOrEmpty(row ["POW008"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW008"]); _model.POW009 = string.IsNullOrEmpty(row ["POW009"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW009"]); _model.POW010 = string.IsNullOrEmpty(row ["POW010"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW010"]); _model.POW011 = string.IsNullOrEmpty(row ["POW011"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW011"]); _model.POW012 = string.IsNullOrEmpty(row ["POW012"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW012"]); _model.POW013 = string.IsNullOrEmpty(row ["POW013"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW013"]); _model.POW016 = string.IsNullOrEmpty(row ["POW016"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW016"]); _model.POW017 = string.IsNullOrEmpty(row ["POW017"].ToString( )) == true ? false : Convert.ToBoolean(row ["POW017"]); if (_model.idx > 0) { edit(SQLString, _model); } else { add(SQLString, _model); } } return(SqlHelper.ExecuteSqlTran(SQLString)); }
public PowerEdit(string text, LineProductMesEntityu.PowerEntity entity, string nameOfPerson, string nameOfProgram, string sign) { InitializeComponent( ); _bll = new LineProductMesBll.Bll.PowerBll( ); _model = new LineProductMesEntityu.PowerEntity( ); this.Text = text; this.sign = sign; this._model = entity; this.nameOfPerson = nameOfPerson; this.nameOfProgram = nameOfProgram; if (sign.Equals("edit")) { lupNamePerson.Enabled = lupNamePro.Enabled = false; } else { lupNamePerson.Enabled = lupNamePro.Enabled = true; } lupNamePerson.Properties.DataSource = _bll.GetPerson( ); lupNamePerson.Properties.DisplayMember = "EMP002"; lupNamePerson.Properties.ValueMember = "EMP001"; lupNamePro.Properties.DataSource = _bll.GetProgram( ); lupNamePro.Properties.DisplayMember = "FOR004"; lupNamePro.Properties.ValueMember = "FOR003"; }
void edit(Hashtable SQLString, LineProductMesEntityu.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MIKPOW SET "); strSql.Append("POW002=@POW002,"); strSql.Append("POW003=@POW003,"); strSql.Append("POW004=@POW004,"); strSql.Append("POW005=@POW005,"); strSql.Append("POW006=@POW006,"); strSql.Append("POW007=@POW007,"); strSql.Append("POW008=@POW008,"); strSql.Append("POW009=@POW009,"); strSql.Append("POW010=@POW010,"); strSql.Append("POW011=@POW011,"); strSql.Append("POW012=@POW012,"); strSql.Append("POW013=@POW013,"); strSql.Append("POW016=@POW016,"); strSql.Append("POW017=@POW017 "); strSql.Append("WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@POW002", SqlDbType.NVarChar, 20), new SqlParameter("@POW003", SqlDbType.NVarChar, 50), new SqlParameter("@POW004", SqlDbType.Bit), new SqlParameter("@POW005", SqlDbType.Bit), new SqlParameter("@POW006", SqlDbType.Bit), new SqlParameter("@POW007", SqlDbType.Bit), new SqlParameter("@POW008", SqlDbType.Bit), new SqlParameter("@POW009", SqlDbType.Bit), new SqlParameter("@POW010", SqlDbType.Bit), new SqlParameter("@POW011", SqlDbType.Bit), new SqlParameter("@POW012", SqlDbType.Bit), new SqlParameter("@POW013", SqlDbType.Bit), new SqlParameter("@POW016", SqlDbType.Bit), new SqlParameter("@POW017", SqlDbType.Bit), new SqlParameter("@idx", SqlDbType.Int) }; parameter [0].Value = _model.POW002; parameter [1].Value = _model.POW003; parameter [2].Value = _model.POW004; parameter [3].Value = _model.POW005; parameter [4].Value = _model.POW006; parameter [5].Value = _model.POW007; parameter [6].Value = _model.POW008; parameter [7].Value = _model.POW009; parameter [8].Value = _model.POW010; parameter [9].Value = _model.POW011; parameter [10].Value = _model.POW012; parameter [11].Value = _model.POW013; parameter [12].Value = _model.POW016; parameter [13].Value = _model.POW017; parameter [14].Value = _model.idx; SQLString.Add(strSql, parameter); }
/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Exsits(LineProductMesEntityu.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) COUN FROM MIKPOW "); strSql.Append("WHERE POW002=@POW002 AND POW003=@POW003"); SqlParameter [] parameter = { new SqlParameter("@POW002", SqlDbType.NVarChar, 50), new SqlParameter("@POW003", SqlDbType.NVarChar, 50) }; parameter [0].Value = _model.POW002; parameter [1].Value = _model.POW003; return(SqlHelper.Exists(strSql.ToString( ), parameter)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add(LineProductMesEntityu.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO MIKPOW ("); strSql.Append("POW002,POW003,POW004,POW005,POW006,POW007,POW008,POW009,POW010,POW011,POW012,POW013,POW016,POW017) "); strSql.Append("VALUES ("); strSql.Append("@POW002,@POW003,@POW004,@POW005,@POW006,@POW007,@POW008,@POW009,@POW010,@POW011,@POW012,@POW013,@POW016,@POW017);"); strSql.Append("SELECT SCOPE_IDENTITY();"); SqlParameter [] parameter = { new SqlParameter("@POW002", SqlDbType.NVarChar, 20), new SqlParameter("@POW003", SqlDbType.NVarChar, 50), new SqlParameter("@POW004", SqlDbType.Bit), new SqlParameter("@POW005", SqlDbType.Bit), new SqlParameter("@POW006", SqlDbType.Bit), new SqlParameter("@POW007", SqlDbType.Bit), new SqlParameter("@POW008", SqlDbType.Bit), new SqlParameter("@POW009", SqlDbType.Bit), new SqlParameter("@POW010", SqlDbType.Bit), new SqlParameter("@POW011", SqlDbType.Bit), new SqlParameter("@POW012", SqlDbType.Bit), new SqlParameter("@POW013", SqlDbType.Bit), new SqlParameter("@POW016", SqlDbType.Bit), new SqlParameter("@POW017", SqlDbType.Bit) }; parameter [0].Value = _model.POW002; parameter [1].Value = _model.POW003; parameter [2].Value = _model.POW004; parameter [3].Value = _model.POW005; parameter [4].Value = _model.POW006; parameter [5].Value = _model.POW007; parameter [6].Value = _model.POW008; parameter [7].Value = _model.POW009; parameter [8].Value = _model.POW010; parameter [9].Value = _model.POW011; parameter [10].Value = _model.POW012; parameter [11].Value = _model.POW013; parameter [12].Value = _model.POW016; parameter [13].Value = _model.POW017; return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter)); }
public FormPower( ) { InitializeComponent( ); GridViewMoHuSelect.SetFilter(gridView1); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); _bll = new LineProductMesBll.Bll.PowerBll( ); _model = new LineProductMesEntityu.PowerEntity( ); ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarItem [] { toolExport, toolPrint, toolCancellation, toolExamin }); lookUpEdit1.Properties.DataSource = _bll.GetPerson( ); lookUpEdit1.Properties.DisplayMember = "EMP002"; lookUpEdit1.Properties.ValueMember = "EMP001"; tablePro = _bll.GetProgram( ); lookUpEdit2.Properties.DataSource = tablePro; lookUpEdit2.Properties.DisplayMember = "FOR004"; lookUpEdit2.Properties.ValueMember = "FOR003"; gridView1.OptionsBehavior.Editable = false; }
public LineProductMesEntityu.PowerEntity getModelPow(DataRow row) { LineProductMesEntityu.PowerEntity model = new LineProductMesEntityu.PowerEntity( ); if (row != null) { if (row ["POW002"] != null) { model.POW002 = row ["POW002"].ToString( ); } if (row ["POW003"] != null) { model.POW003 = row ["POW003"].ToString( ); } if (row ["POW004"] != null && row ["POW004"].ToString( ) != "") { if ((row ["POW004"].ToString( ) == "1") || (row ["POW004"].ToString( ).ToLower( ) == "true")) { model.POW004 = true; } else { model.POW004 = false; } } if (row ["POW005"] != null && row ["POW005"].ToString( ) != "") { if ((row ["POW005"].ToString( ) == "1") || (row ["POW005"].ToString( ).ToLower( ) == "true")) { model.POW005 = true; } else { model.POW005 = false; } } if (row ["POW006"] != null && row ["POW006"].ToString( ) != "") { if ((row ["POW006"].ToString( ) == "1") || (row ["POW006"].ToString( ).ToLower( ) == "true")) { model.POW006 = true; } else { model.POW006 = false; } } if (row ["POW007"] != null && row ["POW007"].ToString( ) != "") { if ((row ["POW007"].ToString( ) == "1") || (row ["POW007"].ToString( ).ToLower( ) == "true")) { model.POW007 = true; } else { model.POW007 = false; } } if (row ["POW009"] != null && row ["POW009"].ToString( ) != "") { if ((row ["POW009"].ToString( ) == "1") || (row ["POW009"].ToString( ).ToLower( ) == "true")) { model.POW009 = true; } else { model.POW009 = false; } } if (row ["POW010"] != null && row ["POW010"].ToString( ) != "") { if ((row ["POW010"].ToString( ) == "1") || (row ["POW010"].ToString( ).ToLower( ) == "true")) { model.POW010 = true; } else { model.POW010 = false; } } if (row ["POW011"] != null && row ["POW011"].ToString( ) != "") { if ((row ["POW011"].ToString( ) == "1") || (row ["POW011"].ToString( ).ToLower( ) == "true")) { model.POW011 = true; } else { model.POW011 = false; } } if (row ["POW012"] != null && row ["POW012"].ToString( ) != "") { if ((row ["POW012"].ToString( ) == "1") || (row ["POW012"].ToString( ).ToLower( ) == "true")) { model.POW012 = true; } else { model.POW012 = false; } } if (row ["POW013"] != null && row ["POW013"].ToString( ) != "") { if ((row ["POW013"].ToString( ) == "1") || (row ["POW013"].ToString( ).ToLower( ) == "true")) { model.POW013 = true; } else { model.POW013 = false; } } if (row ["POW016"] != null && row ["POW016"].ToString( ) != "") { if ((row ["POW016"].ToString( ) == "1") || (row ["POW016"].ToString( ).ToLower( ) == "true")) { model.POW016 = true; } else { model.POW016 = false; } } if (row ["POW017"] != null && row ["POW017"].ToString( ) != "") { if ((row ["POW017"].ToString( ) == "1") || (row ["POW017"].ToString( ).ToLower( ) == "true")) { model.POW017 = true; } else { model.POW017 = false; } } } return(model); }
private void btnOk_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(sign)) { XtraMessageBox.Show("请重新选择新增或编辑"); return; } errorProvider1.Clear( ); bool isOk = true; if (string.IsNullOrEmpty(lupNamePerson.Text)) { errorProvider1.SetError(lupNamePerson, "人员姓名不可为空"); isOk = false; } if (string.IsNullOrEmpty(lupNamePro.Text)) { errorProvider1.SetError(lupNamePro, "程序名称不可为空"); isOk = false; } if (isOk == false) { return; } _model = new LineProductMesEntityu.PowerEntity( ); _model.idx = cekRun.Tag == null ? 0 : int.Parse(cekRun.Tag.ToString( )); _model.POW002 = lupNamePerson.EditValue.ToString( ); _model.POW003 = lupNamePro.EditValue.ToString( ); _model.POW013 = cekRun.Checked == true ? true : false; _model.POW004 = cekQuery.Checked == true ? true : false; _model.POW005 = cekAdd.Checked == true ? true : false; _model.POW006 = cekDelete.Checked == true ? true : false; _model.POW007 = cekEdit.Checked == true ? true : false; _model.POW008 = cekReview.Checked == true ? true : false; _model.POW009 = cekExamin.Checked == true ? true : false; _model.POW010 = cekSave.Checked == true ? true : false; _model.POW011 = cekCancel.Checked == true ? true : false; _model.POW012 = cekCancell.Checked == true ? true : false; _model.POW016 = cekPrint.Checked == true ? true : false; _model.POW017 = cekExample.Checked == true ? true : false; if (sign.Equals("add")) { isOk = _bll.Exsits(_model); if (isOk == true) { XtraMessageBox.Show("" + lupNamePerson.Text + "已经存在" + lupNamePro.Text + "的权限分配记录"); return; } _model.idx = _bll.Add(_model); if (_model.idx > 0) { XtraMessageBox.Show("新增成功"); this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { XtraMessageBox.Show("新增失败,请重试"); } } else if (sign.Equals("edit")) { //int idx = _bll . EditIdx ( _model ); //if ( _model . idx != idx ) //{ // XtraMessageBox . Show ( "" + lupNamePerson . Text + "已经存在" + lupNamePro . Text + "的权限分配记录" ); // return; //} isOk = _bll.Edit(_model); if (isOk == true) { XtraMessageBox.Show("编辑成功"); this.DialogResult = DialogResult.OK; } else { XtraMessageBox.Show("编辑失败,请重试"); } } }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MIKPOW SET "); strSql.Append("POW002=@POW002,"); strSql.Append("POW003=@POW003,"); strSql.Append("POW004=@POW004,"); strSql.Append("POW005=@POW005,"); strSql.Append("POW006=@POW006,"); strSql.Append("POW007=@POW007,"); strSql.Append("POW008=@POW008,"); strSql.Append("POW009=@POW009,"); strSql.Append("POW010=@POW010,"); strSql.Append("POW011=@POW011,"); strSql.Append("POW012=@POW012,"); strSql.Append("POW013=@POW013,"); strSql.Append("POW016=@POW016,"); strSql.Append("POW017=@POW017 "); strSql.Append("WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@POW002", SqlDbType.NVarChar, 20), new SqlParameter("@POW003", SqlDbType.NVarChar, 50), new SqlParameter("@POW004", SqlDbType.Bit), new SqlParameter("@POW005", SqlDbType.Bit), new SqlParameter("@POW006", SqlDbType.Bit), new SqlParameter("@POW007", SqlDbType.Bit), new SqlParameter("@POW008", SqlDbType.Bit), new SqlParameter("@POW009", SqlDbType.Bit), new SqlParameter("@POW010", SqlDbType.Bit), new SqlParameter("@POW011", SqlDbType.Bit), new SqlParameter("@POW012", SqlDbType.Bit), new SqlParameter("@POW013", SqlDbType.Bit), new SqlParameter("@POW016", SqlDbType.Bit), new SqlParameter("@POW017", SqlDbType.Bit), new SqlParameter("@idx", SqlDbType.Int) }; parameter [0].Value = _model.POW002; parameter [1].Value = _model.POW003; parameter [2].Value = _model.POW004; parameter [3].Value = _model.POW005; parameter [4].Value = _model.POW006; parameter [5].Value = _model.POW007; parameter [6].Value = _model.POW008; parameter [7].Value = _model.POW009; parameter [8].Value = _model.POW010; parameter [9].Value = _model.POW011; parameter [10].Value = _model.POW012; parameter [11].Value = _model.POW013; parameter [12].Value = _model.POW016; parameter [13].Value = _model.POW017; parameter [14].Value = _model.idx; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit ( LineProductMesEntityu . PowerEntity _model ) { return dal . Edit ( _model ); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add ( LineProductMesEntityu . PowerEntity _model ) { return dal . Add ( _model ); }
/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Exsits ( LineProductMesEntityu . PowerEntity _model ) { return dal . Exsits ( _model ); }