public FormArt( ) { InitializeComponent( ); model = new LineProductMesEntityu.ArtEntity( ); body = new LineProductMesEntityu.ArsEntity( ); _bll = new LineProductMesBll.Bll.ArtBll( ); _bodyOne = new LineProductMesEntityu.AruEntity( ); //获取UI线程同步上下文 m_SyncContext = SynchronizationContext.Current; GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2, gridView3, View1, View4, View2, View3, gridView4 }); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, gridView2, gridView3, View1, View4, View2, View3, gridView4 }); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarButtonItem [] { toolCancellation, toolExamin }); Query( ); controlUnEnable( ); controlClear( ); InitData( ); }
void EditBody(Dictionary <object, object> SQLString, LineProductMesEntityu.ArtEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update MIKART set "); strSql.Append("ART002=@ART002,"); strSql.Append("ART003=@ART003,"); strSql.Append("ART004=@ART004,"); strSql.Append("ART005=@ART005,"); strSql.Append("ART006=@ART006,"); strSql.Append("ART007=@ART007,"); //strSql . Append ( "ART008=@ART008," ); strSql.Append("ART009=@ART009,"); strSql.Append("ART010=@ART010,"); strSql.Append("ART011=@ART011,"); strSql.Append("ART012=@ART012,"); strSql.Append("ART013=@ART013 "); strSql.Append(" where idx=@idx"); SqlParameter [] parameters = { new SqlParameter("@ART003", SqlDbType.NVarChar, 20), new SqlParameter("@ART004", SqlDbType.Decimal, 9), new SqlParameter("@ART005", SqlDbType.Decimal, 9), new SqlParameter("@ART006", SqlDbType.NVarChar, 50), new SqlParameter("@ART007", SqlDbType.NVarChar, 50), //new SqlParameter("@ART008", SqlDbType.NVarChar,255), new SqlParameter("@ART009", SqlDbType.NVarChar, 255), new SqlParameter("@ART010", SqlDbType.NVarChar, 5), new SqlParameter("@idx", SqlDbType.Int, 4), new SqlParameter("@ART002", SqlDbType.NVarChar, 20), new SqlParameter("@ART011", SqlDbType.NVarChar, 20), new SqlParameter("@ART012", SqlDbType.Int, 4), new SqlParameter("@ART013", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.ART003; parameters [1].Value = model.ART004; parameters [2].Value = model.ART005; parameters [3].Value = model.ART006; parameters [4].Value = model.ART007; //parameters [ 5 ] . Value = model . ART008; parameters [5].Value = model.ART009; parameters [6].Value = model.ART010; parameters [7].Value = model.idx; parameters [8].Value = model.ART002; parameters [9].Value = model.ART011; parameters [10].Value = model.ART012; parameters [11].Value = model.ART013; SQLString.Add(strSql, parameters); }
/// <summary> /// 注销 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CancellationBool(LineProductMesEntityu.ArtEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MIKART SET ART018=@ART018 WHERE idx=@idx"); SqlParameter [] parameter = { new SqlParameter("@ART018", SqlDbType.Bit), new SqlParameter("@idx", SqlDbType.Int) }; parameter [0].Value = model.ART018; parameter [1].Value = model.idx; return(SqlHelper.ExecuteNonQueryResult(strSql.ToString( ), parameter)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Save(LineProductMesEntityu.ArsEntity model, DataTable table, Hashtable haTable) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); AddHeader(SQLString, model); if (table != null && table.Rows.Count > 0) { LineProductMesEntityu.ArtEntity body = new LineProductMesEntityu.ArtEntity( ); body.ART001 = model.ARS001; foreach (DataRow row in table.Rows) { body.ART011 = row ["ART011"].ToString( ); body.ART002 = row ["ART002"].ToString( ); body.ART003 = row ["ART003"].ToString( ); body.ART004 = string.IsNullOrEmpty(row ["ART004"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ART004"].ToString( )); body.ART005 = string.IsNullOrEmpty(row ["ART005"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["ART005"].ToString( )); body.ART006 = row ["ART006"].ToString( ); body.ART007 = row ["ART007"].ToString( ); //body . ART008 = row [ "ART008" ] . ToString ( ); body.ART009 = row ["ART009"].ToString( ); body.ART010 = string.IsNullOrEmpty(row ["ART010"].ToString( )) == true ? "否" : row ["ART010"].ToString( ); body.ART012 = string.IsNullOrEmpty(row ["ART012"].ToString( )) == true ? 0 : Convert.ToInt32(row ["ART012"].ToString( )); body.ART013 = row ["ART013"].ToString( ); AddBody(SQLString, body); if (haTable != null && haTable.Count > 0) { DataTable tableView = ( DataTable )haTable [body.ART001 + body.ART011]; if (tableView != null && tableView.Rows.Count > 0) { LineProductMesEntityu.AruEntity bodyOne = new LineProductMesEntityu.AruEntity( ); bodyOne.ARU001 = body.ART001; bodyOne.ARU002 = body.ART011; foreach (DataRow rows in tableView.Rows) { bodyOne.ARU003 = rows ["ARU003"].ToString( ); bodyOne.ARU004 = rows ["ARU004"].ToString( ); AddBodyOne(SQLString, bodyOne); } } } } } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }
void AddBody(Dictionary <object, object> SQLString, LineProductMesEntityu.ArtEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into MIKART("); strSql.Append("ART001,ART002,ART003,ART004,ART005,ART006,ART007,ART009,ART010,ART011,ART012,ART013)"); strSql.Append(" values ("); strSql.Append("@ART001,@ART002,@ART003,@ART004,@ART005,@ART006,@ART007,@ART009,@ART010,@ART011,@ART012,@ART013)"); SqlParameter [] parameters = { new SqlParameter("@ART001", SqlDbType.NVarChar, 20), new SqlParameter("@ART002", SqlDbType.NVarChar, 20), new SqlParameter("@ART003", SqlDbType.NVarChar, 20), new SqlParameter("@ART004", SqlDbType.Decimal, 9), new SqlParameter("@ART005", SqlDbType.Decimal, 9), new SqlParameter("@ART006", SqlDbType.NVarChar, 50), new SqlParameter("@ART007", SqlDbType.NVarChar, 50), new SqlParameter("@ART009", SqlDbType.NVarChar, 255), new SqlParameter("@ART010", SqlDbType.NVarChar, 5), new SqlParameter("@ART011", SqlDbType.NVarChar, 20), new SqlParameter("@ART012", SqlDbType.Int, 4), new SqlParameter("@ART013", SqlDbType.NVarChar, 20) }; parameters [0].Value = model.ART001; parameters [1].Value = model.ART002; parameters [2].Value = model.ART003; parameters [3].Value = model.ART004; parameters [4].Value = model.ART005; parameters [5].Value = model.ART006; parameters [6].Value = model.ART007; parameters [7].Value = model.ART009; parameters [8].Value = model.ART010; parameters [9].Value = model.ART011; parameters [10].Value = model.ART012; parameters [11].Value = model.ART013; SQLString.Add(strSql, parameters); }
/// <summary> /// 注销 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CancellationBool(LineProductMesEntityu.ArtEntity model) { return(dal.CancellationBool(model)); }