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);
}
}
