/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(CarpenterEntity.ProgramControlEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MOXFOR SET "); strSql.Append("FOR001=@FOR001,"); strSql.Append("FOR002=@FOR002,"); strSql.Append("FOR003=@FOR003,"); strSql.Append("FOR004=@FOR004 "); strSql.Append("WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@FOR001", SqlDbType.NVarChar, 20), new SqlParameter("@FOR002", SqlDbType.NVarChar, 20), new SqlParameter("@FOR003", SqlDbType.NChar, 10), new SqlParameter("@FOR004", SqlDbType.NVarChar, 20), new SqlParameter("@idx", SqlDbType.Int) }; parameter [0].Value = _model.FOR001; parameter [1].Value = _model.FOR002; parameter [2].Value = _model.FOR003; parameter [3].Value = _model.FOR004; parameter [4].Value = _model.idx; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (row > 0) { return(true); } else { return(false); } }
public ProgramControlEdit(string text, CarpenterEntity.ProgramControlEntity _model, string sign) { InitializeComponent( ); this.Text = text; this._model = _model; this.sign = sign; comType.Items.Add("0"); comType.Items.Add("1"); }
public FormProgramControl( ) { InitializeComponent( ); _bll = new CarpenterBll.Bll.ProgramControlBll( ); _model = new CarpenterEntity.ProgramControlEntity( ); barMenu.LinksPersistInfo.RemoveAt(toolExport.Id); barMenu.LinksPersistInfo.RemoveAt(toolPrint.Id); barMenu.LinksPersistInfo.RemoveAt(toolCancel.Id); barMenu.LinksPersistInfo.RemoveAt(toolSave.Id); Utility.GridViewMoHuSelect.SetFilter(gridView1); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add(CarpenterEntity.ProgramControlEntity _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO MOXFOR ("); strSql.Append("FOR001,FOR002,FOR003,FOR004) "); strSql.Append("VALUES ("); strSql.Append("@FOR001,@FOR002,@FOR003,@FOR004);"); strSql.Append("SELECT SCOPE_IDENTITY();"); SqlParameter [] parameter = { new SqlParameter("@FOR001", SqlDbType.NVarChar, 20), new SqlParameter("@FOR002", SqlDbType.NVarChar, 20), new SqlParameter("@FOR003", SqlDbType.NChar, 10), new SqlParameter("@FOR004", SqlDbType.NVarChar, 20) }; parameter [0].Value = _model.FOR001; parameter [1].Value = _model.FOR002; parameter [2].Value = _model.FOR003; parameter [3].Value = _model.FOR004; return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(CarpenterEntity.ProgramControlEntity _model) { return(_dao.Edit(_model)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add(CarpenterEntity.ProgramControlEntity _model) { return(_dao.Add(_model)); }