public PowerEdit(string text, CarpenterEntity.PowerEntity _model, string nameOfPerson, string nameOfProgram, string sign) { InitializeComponent( ); this.Text = text; this.sign = sign; this._model = _model; 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 = "DBA002"; lupNamePerson.Properties.ValueMember = "DBA001"; lupNamePro.Properties.DataSource = _bll.GetProgram( ); lupNamePro.Properties.DisplayMember = "FOR001"; lupNamePro.Properties.ValueMember = "FOR002"; }
/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int EditIdx(CarpenterEntity.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT idx FROM MOXPOW "); strSql.Append("WHERE POW002=@POW002 AND POW003=@POW003"); SqlParameter [] parameter = { new SqlParameter("@POW002", SqlDbType.NVarChar, 20), new SqlParameter("@POW003", SqlDbType.NVarChar, 20) }; parameter [0].Value = _model.POW002; parameter [1].Value = _model.POW003; DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ), parameter); if (da != null && da.Rows.Count > 0) { if (string.IsNullOrEmpty(da.Rows [0] ["idx"].ToString( ))) { return(0); } else { return(int.Parse(da.Rows [0] ["idx"].ToString( ))); } } else { return(0); } }
public FormPower( ) { InitializeComponent( ); _bll = new CarpenterBll.Bll.PowerBll( ); _model = new CarpenterEntity.PowerEntity( ); Utility.GridViewMoHuSelect.SetFilter(gridView1); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); barMenu.LinksPersistInfo.RemoveAt(toolExport.Id); barMenu.LinksPersistInfo.RemoveAt(toolPrint.Id); barMenu.LinksPersistInfo.RemoveAt(toolCancel.Id); barMenu.LinksPersistInfo.RemoveAt(toolSave.Id); lupPerson.Properties.DataSource = _bll.GetPerson( ); lupPerson.Properties.DisplayMember = "DBA002"; lupPerson.Properties.ValueMember = "DBA001"; lupProgram.Properties.DataSource = _bll.GetProgram( ); lupProgram.Properties.DisplayMember = "FOR001"; lupProgram.Properties.ValueMember = "FOR002"; }
/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Exsits(CarpenterEntity.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) COUN FROM MOXPOW "); strSql.Append("WHERE POW002=@POW002 AND POW003=@POW003"); SqlParameter [] parameter = { new SqlParameter("@POW002", SqlDbType.NVarChar, 20), new SqlParameter("@POW003", SqlDbType.NVarChar, 20) }; 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(CarpenterEntity.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO MOXPOW ("); 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)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(CarpenterEntity.PowerEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MOXPOW 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 int EditIdx(CarpenterEntity.PowerEntity _model) { return(_dao.EditIdx(_model)); }
/// <summary> /// 是否存在 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Exsits(CarpenterEntity.PowerEntity _model) { return(_dao.Exsits(_model)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(CarpenterEntity.PowerEntity _model) { return(_dao.Edit(_model)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add(CarpenterEntity.PowerEntity _model) { return(_dao.Add(_model)); }