protected override int Prov( ) { if (string.IsNullOrEmpty(_pdu.idx.ToString( ))) { return(0); } strWhere = "SELECT idx,PDU001 FROM TENPDU WHERE idx=(SELECT MAX(idx) FROM TENPDU WHERE idx<" + _pdu.idx + ")"; _pdu.PDU001 = _bll.getNum(strWhere); if (_pdu.PDU001 != string.Empty) { _pdu = _bll.GetDataTableTwo(_pdu.PDU001); setValue( ); strWhere = "1=1" + " AND PDA001='" + _pdu.PDU001 + "'"; tableOne = _bll.getDataTable(strWhere); gridControl1.DataSource = tableOne; tableFor = _bll.getDataTableEnclosure(txtContrNum.Text); gridControl2.DataSource = tableFor; tableQuery( ); queryTool( ); } return(base.Prov( )); }
void add_one(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDUEntity _pdu, DataTable tableOne, DataTable tableFor) { add_pdu(SQLString, strSql, _pdu); add_pda(SQLString, strSql, _pdu.PDU001, tableOne); add_pdb(SQLString, strSql, tableFor, _pdu.PDU001); }
/// <summary> /// 保存 /// </summary> /// <param name="_pdu"></param> /// <param name="tableOne"></param> /// <param name="tableFor"></param> /// <param name="tableTre"></param> /// <param name="_pdc"></param> /// <returns></returns> public bool Add(MaterileEntity.MaterielPDUEntity _pdu, DataTable tableOne, DataTable tableFor, Hashtable table_one_pdc, Hashtable table_two_pdc) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); add_one(SQLString, strSql, _pdu, tableOne, tableFor); if (table_two_pdc.Count > 0) { add_two(SQLString, strSql, table_one_pdc, table_two_pdc); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
protected override int Query( ) { strWhere = "SELECT PDU001 FROM TENPDU WHERE idx=(SELECT MIN(idx) FROM TENPDU)"; _pdu.PDU001 = _bll.getNum(strWhere); if (_pdu.PDU001 != string.Empty) { _pdu = _bll.GetDataTableTwo(_pdu.PDU001); setValue( ); strWhere = "1=1" + " AND PDA001='" + _pdu.PDU001 + "'"; tableOne = _bll.getDataTable(strWhere); gridControl1.DataSource = tableOne; tableFor = _bll.getDataTableEnclosure(txtContrNum.Text); gridControl2.DataSource = tableFor; tableQuery( ); queryTool( ); } return(base.Query( )); }
public Form1( ) { InitializeComponent( ); _pda = new MaterileEntity.MaterielPDAEntity( ); _pdu = new MaterileEntity.MaterielPDUEntity( ); _pdc = new MaterileEntity.MaterielPDCEntity( ); _pdb = new MaterileEntity.MaterielPDBEntity( ); _bll = new MaterielBll.Bll.MaterielBll( ); tableOne = new DataTable( ); tableTwo = new DataTable( ); tableTre = new DataTable( ); printOne = new DataTable( ); printTwo = new DataTable( ); controlUnEnable( ); Utility.GridViewMoHuSelect.SetFilter(bandedGridView1); FieldInfo fi = typeof(DevExpress.Utils.Paint.XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); }
/// <summary> /// 保存 /// </summary> /// <param name="_pdu"></param> /// <param name="tableOne"></param> /// <param name="tableFor"></param> /// <param name="tableTre"></param> /// <param name="_pdc"></param> /// <returns></returns> public bool Add(MaterileEntity.MaterielPDUEntity _pdu, DataTable tableOne, DataTable tableFor, Hashtable table_one_pdc, Hashtable table_two_pdc) { return(dal.Add(_pdu, tableOne, tableFor, table_one_pdc, table_two_pdc)); }
public MaterileEntity.MaterielPDUEntity GetModel(DataRow row) { MaterileEntity.MaterielPDUEntity model = new MaterileEntity.MaterielPDUEntity( ); if (row != null) { if (row ["idx"] != null) { model.idx = int.Parse(row ["idx"].ToString( )); } if (row ["PDU001"] != null) { model.PDU001 = row ["PDU001"].ToString( ); } if (row ["PDU002"] != null) { model.PDU002 = row ["PDU002"].ToString( ); } if (row ["PDU003"] != null) { model.PDU003 = row ["PDU003"].ToString( ); } if (row ["PDU004"] != null) { model.PDU004 = row ["PDU004"].ToString( ); } if (row ["PDU005"] != null) { model.PDU005 = row ["PDU005"].ToString( ); } if (row ["PDU006"] != null) { model.PDU006 = row ["PDU006"].ToString( ); } if (row ["PDU007"] != null) { model.PDU007 = row ["PDU007"].ToString( ); } if (row ["PDU008"] != null) { model.PDU008 = row ["PDU008"].ToString( ); } if (row ["PDU009"] != null) { model.PDU009 = row ["PDU009"].ToString( ); } if (row ["PDU010"] != null) { model.PDU010 = row ["PDU010"].ToString( ); } if (row ["PDU011"] != null) { model.PDU011 = row ["PDU011"].ToString( ); } if (row ["PDU012"] != null) { model.PDU012 = row ["PDU012"].ToString( ); } if (row ["PDU013"] != null) { model.PDU013 = row ["PDU013"].ToString( ); } if (row ["PDU014"] != null) { model.PDU014 = row ["PDU014"].ToString( ); } if (row ["PDU015"] != null) { model.PDU015 = row ["PDU015"].ToString( ); } if (row ["PDU016"] != null) { model.PDU016 = DateTime.Parse(row ["PDU016"].ToString( )); } } return(model); }
void add_pdu(Hashtable SQLString, StringBuilder strSql, MaterileEntity.MaterielPDUEntity _pdu) { strSql = new StringBuilder( ); if (Exists_pdu(_pdu.PDU001) == false) { strSql.Append("INSERT INTO TENPDU ("); strSql.Append("PDU001,PDU002,PDU003,PDU004,PDU005,PDU006,PDU007,PDU008,PDU009,PDU010,PDU011,PDU012,PDU013,PDU014,PDU015,PDU016) "); strSql.Append("VALUES ("); strSql.Append("@PDU001,@PDU002,@PDU003,@PDU004,@PDU005,@PDU006,@PDU007,@PDU008,@PDU009,@PDU010,@PDU011,@PDU012,@PDU013,@PDU014,@PDU015,@PDU016)"); SqlParameter [] parameter = { new SqlParameter("@PDU001", SqlDbType.NVarChar, 200), new SqlParameter("@PDU002", SqlDbType.NVarChar, 200), new SqlParameter("@PDU003", SqlDbType.NVarChar, 200), new SqlParameter("@PDU004", SqlDbType.NVarChar, 200), new SqlParameter("@PDU005", SqlDbType.NVarChar, 500), new SqlParameter("@PDU006", SqlDbType.NVarChar, 200), new SqlParameter("@PDU007", SqlDbType.NVarChar, 200), new SqlParameter("@PDU008", SqlDbType.NVarChar, 200), new SqlParameter("@PDU009", SqlDbType.NVarChar, 200), new SqlParameter("@PDU010", SqlDbType.NVarChar, 200), new SqlParameter("@PDU011", SqlDbType.NVarChar, 200), new SqlParameter("@PDU012", SqlDbType.NVarChar, 200), new SqlParameter("@PDU013", SqlDbType.NVarChar, 200), new SqlParameter("@PDU014", SqlDbType.NVarChar, 200), new SqlParameter("@PDU015", SqlDbType.NVarChar, 200), new SqlParameter("@PDU016", SqlDbType.Date) }; parameter [0].Value = _pdu.PDU001; parameter [1].Value = _pdu.PDU002; parameter [2].Value = _pdu.PDU003; parameter [3].Value = _pdu.PDU004; parameter [4].Value = _pdu.PDU005; parameter [5].Value = _pdu.PDU006; parameter [6].Value = _pdu.PDU007; parameter [7].Value = _pdu.PDU008; parameter [8].Value = _pdu.PDU009; parameter [9].Value = _pdu.PDU010; parameter [10].Value = _pdu.PDU011; parameter [11].Value = _pdu.PDU012; parameter [12].Value = _pdu.PDU013; parameter [13].Value = _pdu.PDU014; parameter [14].Value = _pdu.PDU015; parameter [15].Value = _pdu.PDU016; SQLString.Add(strSql, parameter); } else { strSql.Append("UPDATE TENPDU SET "); strSql.Append("PDU002=@PDU002,"); strSql.Append("PDU003=@PDU003,"); strSql.Append("PDU004=@PDU004,"); strSql.Append("PDU005=@PDU005,"); strSql.Append("PDU006=@PDU006,"); strSql.Append("PDU007=@PDU007,"); strSql.Append("PDU008=@PDU008,"); strSql.Append("PDU009=@PDU009,"); strSql.Append("PDU010=@PDU010,"); strSql.Append("PDU011=@PDU011,"); strSql.Append("PDU012=@PDU012,"); strSql.Append("PDU013=@PDU013,"); strSql.Append("PDU014=@PDU014,"); strSql.Append("PDU015=@PDU015,"); strSql.Append("PDU016=@PDU016 "); strSql.Append("WHERE PDU001=@PDU001"); SqlParameter [] parameter = { new SqlParameter("@PDU001", SqlDbType.NVarChar, 200), new SqlParameter("@PDU002", SqlDbType.NVarChar, 200), new SqlParameter("@PDU003", SqlDbType.NVarChar, 200), new SqlParameter("@PDU004", SqlDbType.NVarChar, 200), new SqlParameter("@PDU005", SqlDbType.NVarChar, 500), new SqlParameter("@PDU006", SqlDbType.NVarChar, 200), new SqlParameter("@PDU007", SqlDbType.NVarChar, 200), new SqlParameter("@PDU008", SqlDbType.NVarChar, 200), new SqlParameter("@PDU009", SqlDbType.NVarChar, 200), new SqlParameter("@PDU010", SqlDbType.NVarChar, 200), new SqlParameter("@PDU011", SqlDbType.NVarChar, 200), new SqlParameter("@PDU012", SqlDbType.NVarChar, 200), new SqlParameter("@PDU013", SqlDbType.NVarChar, 200), new SqlParameter("@PDU014", SqlDbType.NVarChar, 200), new SqlParameter("@PDU015", SqlDbType.NVarChar, 200), new SqlParameter("@PDU016", SqlDbType.Date) }; parameter [0].Value = _pdu.PDU001; parameter [1].Value = _pdu.PDU002; parameter [2].Value = _pdu.PDU003; parameter [3].Value = _pdu.PDU004; parameter [4].Value = _pdu.PDU005; parameter [5].Value = _pdu.PDU006; parameter [6].Value = _pdu.PDU007; parameter [7].Value = _pdu.PDU008; parameter [8].Value = _pdu.PDU009; parameter [9].Value = _pdu.PDU010; parameter [10].Value = _pdu.PDU011; parameter [11].Value = _pdu.PDU012; parameter [12].Value = _pdu.PDU013; parameter [13].Value = _pdu.PDU014; parameter [14].Value = _pdu.PDU015; parameter [15].Value = _pdu.PDU016; SQLString.Add(strSql, parameter); } }