public LineProductMesEntityu.ProductPlanHeaderEntity getModel(DataRow row) { LineProductMesEntityu.ProductPlanHeaderEntity model = new LineProductMesEntityu.ProductPlanHeaderEntity( ); if (row != null) { if (row ["PRD001"] != null) { model.PRD001 = row ["PRD001"].ToString( ); } if (row ["PRD002"] != null && row ["PRD002"].ToString( ) != "") { model.PRD002 = DateTime.Parse(row ["PRD002"].ToString( )); } if (row ["PRD003"] != null && row ["PRD003"].ToString( ) != "") { if ((row ["PRD003"].ToString( ) == "1") || (row ["PRD003"].ToString( ).ToLower( ) == "true")) { model.PRD003 = true; } else { model.PRD003 = false; } } } return(model); }
/// <summary> /// 复制 /// </summary> /// <param name="table"></param> /// <param name="oddNum"></param> /// <returns></returns> public bool Copy(DataTable table, string oddNum) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); LineProductMesEntityu.ProductPlanHeaderEntity model = new LineProductMesEntityu.ProductPlanHeaderEntity( ); model.PRD001 = getOddNum( ); model.PRD002 = UserInfoMation.sysTime; model.PRD003 = false; AddHeader(SQLString, model); UserInfoMation.oddNum = model.PRD001; LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( ); modelBody.PRE001 = model.PRD001; foreach (DataRow row in table.Rows) { modelBody.PRE002 = row ["PRE002"].ToString( ); modelBody.PRE003 = row ["PRE003"].ToString( ); modelBody.PRE004 = row ["PRE004"].ToString( ); modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( )); modelBody.PRE006 = Convert.ToDateTime(row ["PRE006"].ToString( )); modelBody.PRE007 = Convert.ToInt32(row ["PRE007"].ToString( )); modelBody.PRE008 = Convert.ToInt32(row ["PRE008"].ToString( )); modelBody.PRE010 = Convert.ToInt32(row ["PRE010"].ToString( )); AddBody(SQLString, modelBody); } StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("UPDATE MIKPRD SET PRD003=1 WHERE PRD001='{0}'", oddNum); SQLString.Add(strSql, null); return(SqlHelper.ExecuteSqlTranDic(SQLString)); }
public FormProductPlan(/*DataRow rowedit*/) { InitializeComponent( ); _header = new LineProductMesEntityu.ProductPlanHeaderEntity( ); _body = new LineProductMesEntityu.ProductPlanBodyEntity( ); _bll = new LineProductMesBll.Bll.ProductPlanBll( ); ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarItem [] { toolExport, toolPrint }); GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 }); GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 }); FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); //toolExamin . Caption = "弃用"; //toolCancellation . Caption = "复制"; controlUnEnable( ); controlClear( ); dtTime = LineProductMesBll.UserInfoMation.sysTime; toolCancellation.Caption = "生成ERP计划"; layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; //if ( rowedit != null ) //{ // this . rows = rowedit; //} }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <returns></returns> public bool Save(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); model.PRD001 = getOddNum( ); UserInfoMation.oddNum = model.PRD001; AddHeader(SQLString, model); LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( ); modelBody.PRE001 = model.PRD001; //StringBuilder strSql = new StringBuilder ( ); //strSql . Append ( "SELECT PRF001,PRF002 FROM MIKPRF " ); //DataTable tableR = SqlHelper . ExecuteDataTable ( strSql . ToString ( ) ); foreach (DataRow row in table.Rows) { modelBody.PRE002 = row ["PRE002"].ToString( ); modelBody.PRE003 = row ["PRE003"].ToString( ); modelBody.PRE004 = row ["PRE004"].ToString( ); modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( )); modelBody.PRE006 = Convert.ToDateTime(row ["PRE006"].ToString( )); modelBody.PRE007 = Convert.ToInt32(row ["PRE007"].ToString( )); modelBody.PRE008 = Convert.ToInt32(row ["PRE008"].ToString( )); if (string.IsNullOrEmpty(row ["PRE009"].ToString( ))) { modelBody.PRE009 = null; } else { modelBody.PRE009 = Convert.ToInt32(row ["PRE009"].ToString( )); } modelBody.PRE010 = Convert.ToInt32(row ["PRE010"].ToString( )); if (string.IsNullOrEmpty(row ["PRE011"].ToString( ))) { modelBody.PRE011 = 0; } else { modelBody.PRE011 = Convert.ToInt32(row ["PRE011"].ToString( )); } modelBody.PRE008 = modelBody.PRE008 + modelBody.PRE011; AddBody(SQLString, modelBody); //if ( tableR != null && tableR . Rows . Count > 0 ) //{ // if ( tableR . Select ( "PRF001='" + modelBody . PRE004 + "' AND PRF002='" + modelBody . PRE005 + "'" ) . Length < 1 ) // Addprf ( SQLString ,modelBody ); // else // Editprf ( SQLString ,modelBody ); //} //else // Addprf ( SQLString ,modelBody ); } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }
/// <summary> /// 审核 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public bool Examine(LineProductMesEntityu.ProductPlanHeaderEntity _header, DataTable table) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE MIKPRD SET PRD003=@PRD003 WHERE PRD001=@PRD001"); SqlParameter [] parameter = { new SqlParameter("@PRD001", SqlDbType.NVarChar, 20), new SqlParameter("@PRD003", SqlDbType.Bit) }; parameter [0].Value = _header.PRD001; parameter [1].Value = _header.PRD003; SQLString.Add(strSql, parameter); LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( ); strSql = new StringBuilder( ); strSql.Append("SELECT PRF001,PRF002 FROM MIKPRF "); DataTable tableR = SqlHelper.ExecuteDataTable(strSql.ToString( )); foreach (DataRow row in table.Rows) { modelBody.PRE004 = row ["PRE004"].ToString( ); modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( )); modelBody.PRE008 = Convert.ToInt32(row ["PRE008"].ToString( )); if (string.IsNullOrEmpty(row ["PRE011"].ToString( ))) { modelBody.PRE011 = 0; } else { modelBody.PRE011 = Convert.ToInt32(row ["PRE011"].ToString( )); } modelBody.PRE008 = modelBody.PRE008 + modelBody.PRE011; if (tableR != null && tableR.Rows.Count > 0) { if (tableR.Select("PRF001='" + modelBody.PRE004 + "' AND PRF002='" + modelBody.PRE005 + "'").Length < 1) { Addprf(SQLString, modelBody); } else { Editprf(SQLString, modelBody); } } else { Addprf(SQLString, modelBody); } } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }
protected override int Query( ) { ChildForm.FormProductPlanQuery from = new ChildForm.FormProductPlanQuery( ); from.StartPosition = FormStartPosition.CenterParent; if (from.ShowDialog( ) == DialogResult.OK) { _header.PRD001 = from.getOdd; _header = _bll.getModel(_header.PRD001); setValue( ); tableView = _bll.getTableView(_header.PRD001); gridControl1.DataSource = tableView; QueryTool( ); toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; if (_header.PRD003 == true) { toolExamin.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolCancellation.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; Graph.grPic(pictureEdit1, "审核"); } else { toolExamin.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; toolCancellation.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; Graph.grPic(pictureEdit1, "反审核"); } gridView1.OptionsBehavior.Editable = false; } return(base.Query( )); }
void AddHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.ProductPlanHeaderEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into MIKPRD("); strSql.Append("PRD001,PRD002,PRD003)"); strSql.Append(" values ("); strSql.Append("@PRD001,@PRD002,@PRD003)"); SqlParameter [] parameters = { new SqlParameter("@PRD001", SqlDbType.NVarChar, 20), new SqlParameter("@PRD002", SqlDbType.Date, 3), new SqlParameter("@PRD003", SqlDbType.Bit, 1) }; parameters [0].Value = model.PRD001; parameters [1].Value = model.PRD002; parameters [2].Value = model.PRD003; SQLString.Add(strSql, parameters); }
/// <summary> /// 启用或弃用 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public bool Examine(LineProductMesEntityu.ProductPlanHeaderEntity _header, DataTable tableView) { return(dal.Examine(_header, tableView)); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table, List <string> idxList) { return(dal.Edit(model, table, idxList)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <returns></returns> public bool Save(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table) { return(dal.Save(model, table)); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <param name="table"></param> /// <param name="idxList"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table, List <string> idxList) { Dictionary <object, object> SQLString = new Dictionary <object, object> ( ); LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( ); modelBody.PRE001 = model.PRD001; //StringBuilder strSql = new StringBuilder ( ); //strSql . Append ( "SELECT PRF001,PRF002 FROM MIKPRF " ); //DataTable tableR = SqlHelper . ExecuteDataTable ( strSql . ToString ( ) ); foreach (DataRow row in table.Rows) { modelBody.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]); modelBody.PRE002 = row ["PRE002"].ToString( ); modelBody.PRE003 = row ["PRE003"].ToString( ); modelBody.PRE004 = row ["PRE004"].ToString( ); modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( )); modelBody.PRE006 = Convert.ToDateTime(row ["PRE006"].ToString( )); modelBody.PRE007 = Convert.ToInt32(row ["PRE007"].ToString( )); modelBody.PRE008 = string.IsNullOrEmpty(row ["PRE008"].ToString( )) == true ? 0 : Convert.ToInt32(row ["PRE008"].ToString( )); //modelBody . PRE009 = string . IsNullOrEmpty ( row [ "PRE009" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( row [ "PRE009" ] . ToString ( ) ); modelBody.PRE010 = Convert.ToInt32(row ["PRE010"].ToString( )); //modelBody . PRE012 = modelBody . PRE009 == 0 ? string . Empty : row [ "PRE012" ] . ToString ( ); if (string.IsNullOrEmpty(row ["PRE011"].ToString( ))) { modelBody.PRE011 = 0; } else { modelBody.PRE011 = Convert.ToInt32(row ["PRE011"].ToString( )); } modelBody.PRE008 = modelBody.PRE008 + modelBody.PRE011; if (modelBody.idx < 1) { AddBody(SQLString, modelBody); //if ( tableR != null && tableR . Rows . Count > 0 ) //{ // if ( tableR . Select ( "PRF001='" + modelBody . PRE004 + "' AND PRF002='" + modelBody . PRE005 + "'" ) . Length < 1 ) // Addprf ( SQLString ,modelBody ); // else // { // if ( modelBody . PRE011 != 0 ) // { // modelBody . PRE008 = modelBody . PRE011; // Editprf ( SQLString ,modelBody ); // } // } //} //else // Addprf ( SQLString ,modelBody ); } else { EditBody(SQLString, modelBody); //if ( modelBody . PRE011 != 0 ) //{ // modelBody . PRE008 = modelBody . PRE011; // Editprf ( SQLString ,modelBody ); //} } } foreach (string s in idxList) { DeleteBody(SQLString, s); } return(SqlHelper.ExecuteSqlTranDic(SQLString)); }