/// <summary>
/// save data to r_pqcn r_pqco r_pqcp
/// </summary>
/// <param name="table"></param>
/// <param name="_cn"></param>
/// <param name="ModelCp"></param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.FeedTestCNEntity _cn, List <MulaolaoLibrary.FeedTestCPEntity> ModelCp)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
MulaolaoLibrary.FeedTestCOEntity _co = new MulaolaoLibrary.FeedTestCOEntity( );
_cn.CN001 = _co.CO001 = getOddNum( );
add_cn(SQLString, strSql, _cn);
for (int i = 0; i < table.Rows.Count; i++)
{
_co.CO002 = table.Rows [i] ["CO002"].ToString( );
_co.CO003 = string.IsNullOrEmpty(table.Rows [i] ["CO003"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO003"].ToString( ));
_co.CO004 = string.IsNullOrEmpty(table.Rows [i] ["CO004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO004"].ToString( ));
_co.CO005 = table.Rows [i] ["CO005"].ToString( );
_co.CO006 = table.Rows [i] ["CO006"].ToString( );
_co.CO007 = string.IsNullOrEmpty(table.Rows [i] ["CO007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO007"].ToString( ));
_co.CO008 = string.IsNullOrEmpty(table.Rows [i] ["CO008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO008"].ToString( ));
_co.CO009 = string.IsNullOrEmpty(table.Rows [i] ["CO009"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO009"].ToString( ));
_co.CO010 = string.IsNullOrEmpty(table.Rows [i] ["CO010"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO010"].ToString( ));
_co.CO011 = table.Rows [i] ["CO011"].ToString( );
add_co(SQLString, strSql, _co);
}
foreach (MulaolaoLibrary.FeedTestCPEntity cp in ModelCp)
{
cp.CP001 = _cn.CN001;
add_cp(SQLString, strSql, cp);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
public FormFeedTest( )
{
InitializeComponent( );
_cn = new MulaolaoLibrary.FeedTestCNEntity( );
_co = new MulaolaoLibrary.FeedTestCOEntity( );
_bll = new MulaolaoBll.Bll.FeedTestBll( );
tableView = new DataTable( );
GridViewMoHuSelect.SetFilter(secView);
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
Power(this);
UnEnable( );
lupSup.Properties.DataSource = _bll.getSupplier( );
lupSup.Properties.DisplayMember = "DGA003";
lupSup.Properties.ValueMember = "DGA001";
secPro.Properties.DataSource = _bll.getProductInfo( );
secPro.Properties.DisplayMember = "PQF04";
secPro.Properties.ValueMember = "PQF01";
}
void setValue( )
{
tableView = _bll.getView(" CO001='" + _cn.CN001 + "'");
gridControl1.DataSource = tableView;
if (gridView1.DataRowCount > 0)
{
_co.CO002 = gridView1.GetDataRow(0) ["CO002"].ToString( );
_co.CO003 = string.IsNullOrEmpty(gridView1.GetDataRow(0) ["CO003"].ToString( )) == true ? 0 : Convert.ToInt32(gridView1.GetDataRow(0) ["CO003"].ToString( ));
}
_cn = _bll.getModel(_cn.CN001);
setValueHead( );
}
void edit_cn(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.FeedTestCNEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_PQCN set ");
strSql.Append("CN002=@CN002,");
strSql.Append("CN003=@CN003,");
strSql.Append("CN004=@CN004,");
strSql.Append("CN005=@CN005,");
strSql.Append("CN006=@CN006,");
strSql.Append("CN007=@CN007,");
strSql.Append("CN008=@CN008,");
strSql.Append("CN009=@CN009,");
strSql.Append("CN010=@CN010,");
strSql.Append("CN011=@CN011,");
strSql.Append("CN012=@CN012,");
strSql.Append("CN013=@CN013,");
strSql.Append("CN014=@CN014,");
strSql.Append("CN015=@CN015,");
strSql.Append("CN016=@CN016,");
strSql.Append("CN017=@CN017,");
strSql.Append("CN018=@CN018,");
strSql.Append("CN019=@CN019,");
strSql.Append("CN020=@CN020,");
strSql.Append("CN021=@CN021,");
strSql.Append("CN022=@CN022,");
strSql.Append("CN023=@CN023,");
strSql.Append("CN024=@CN024,");
strSql.Append("CN025=@CN025,");
strSql.Append("CN026=@CN026,");
strSql.Append("CN027=@CN027,");
strSql.Append("CN030=@CN030,");
strSql.Append("CN028=@CN028,");
strSql.Append("CN031=@CN031,");
strSql.Append("CN029=@CN029 ");
strSql.Append(" where CN001=@CN001");
SqlParameter [] parameters =
{
new SqlParameter("@CN001", SqlDbType.NVarChar, 20),
new SqlParameter("@CN002", SqlDbType.NVarChar, 20),
new SqlParameter("@CN003", SqlDbType.NVarChar, 50),
new SqlParameter("@CN004", SqlDbType.NVarChar, 20),
new SqlParameter("@CN005", SqlDbType.NVarChar, 20),
new SqlParameter("@CN006", SqlDbType.Int, 4),
new SqlParameter("@CN007", SqlDbType.Date, 3),
new SqlParameter("@CN008", SqlDbType.Date, 3),
new SqlParameter("@CN009", SqlDbType.NVarChar, 200),
new SqlParameter("@CN010", SqlDbType.NVarChar, 200),
new SqlParameter("@CN011", SqlDbType.Date, 3),
new SqlParameter("@CN012", SqlDbType.NVarChar, 20),
new SqlParameter("@CN013", SqlDbType.Int, 4),
new SqlParameter("@CN014", SqlDbType.NVarChar, 20),
new SqlParameter("@CN015", SqlDbType.Decimal, 9),
new SqlParameter("@CN016", SqlDbType.Int, 4),
new SqlParameter("@CN017", SqlDbType.Int, 4),
new SqlParameter("@CN018", SqlDbType.Int, 4),
new SqlParameter("@CN019", SqlDbType.Decimal, 9),
new SqlParameter("@CN020", SqlDbType.Int, 4),
new SqlParameter("@CN021", SqlDbType.Int, 4),
new SqlParameter("@CN022", SqlDbType.Int, 4),
new SqlParameter("@CN023", SqlDbType.Decimal, 9),
new SqlParameter("@CN024", SqlDbType.Int, 4),
new SqlParameter("@CN025", SqlDbType.Int, 4),
new SqlParameter("@CN026", SqlDbType.Int, 4),
new SqlParameter("@CN027", SqlDbType.Bit, 1),
new SqlParameter("@CN030", SqlDbType.Bit, 1),
new SqlParameter("@CN028", SqlDbType.Bit, 1),
new SqlParameter("@CN031", SqlDbType.Bit, 1),
new SqlParameter("@CN029", SqlDbType.NVarChar, 500)
};
parameters [0].Value = model.CN001;
parameters [1].Value = model.CN002;
parameters [2].Value = model.CN003;
parameters [3].Value = model.CN004;
parameters [4].Value = model.CN005;
parameters [5].Value = model.CN006;
parameters [6].Value = model.CN007;
parameters [7].Value = model.CN008;
parameters [8].Value = model.CN009;
parameters [9].Value = model.CN010;
parameters [10].Value = model.CN011;
parameters [11].Value = model.CN012;
parameters [12].Value = model.CN013;
parameters [13].Value = model.CN014;
parameters [14].Value = model.CN015;
parameters [15].Value = model.CN016;
parameters [16].Value = model.CN017;
parameters [17].Value = model.CN018;
parameters [18].Value = model.CN019;
parameters [19].Value = model.CN020;
parameters [20].Value = model.CN021;
parameters [21].Value = model.CN022;
parameters [22].Value = model.CN023;
parameters [23].Value = model.CN024;
parameters [24].Value = model.CN025;
parameters [25].Value = model.CN026;
parameters [26].Value = model.CN027;
parameters [27].Value = model.CN030;
parameters [28].Value = model.CN028;
parameters [29].Value = model.CN031;
parameters [30].Value = model.CN029;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// edit data to r_pqcn r_pqco r_pqcp
/// </summary>
/// <param name="table"></param>
/// <param name="_cn"></param>
/// <param name="ModelCp"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(DataTable table, MulaolaoLibrary.FeedTestCNEntity _cn, List <MulaolaoLibrary.FeedTestCPEntity> ModelCp, List <string> strList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
edit_cn(SQLString, strSql, _cn);
MulaolaoLibrary.FeedTestCOEntity _co = new MulaolaoLibrary.FeedTestCOEntity( );
_co.CO001 = _cn.CN001;
for (int i = 0; i < table.Rows.Count; i++)
{
_co.CO002 = table.Rows [i] ["CO002"].ToString( );
_co.CO003 = string.IsNullOrEmpty(table.Rows [i] ["CO003"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO003"].ToString( ));
_co.CO004 = string.IsNullOrEmpty(table.Rows [i] ["CO004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO004"].ToString( ));
_co.CO005 = table.Rows [i] ["CO005"].ToString( );
_co.CO006 = table.Rows [i] ["CO006"].ToString( );
_co.CO007 = string.IsNullOrEmpty(table.Rows [i] ["CO007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO007"].ToString( ));
_co.CO008 = string.IsNullOrEmpty(table.Rows [i] ["CO008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO008"].ToString( ));
_co.CO009 = string.IsNullOrEmpty(table.Rows [i] ["CO009"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO009"].ToString( ));
_co.CO010 = string.IsNullOrEmpty(table.Rows [i] ["CO010"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CO010"].ToString( ));
_co.CO011 = table.Rows [i] ["CO011"].ToString( );
_co.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
if (_co.idx > 0)
{
edit_co(SQLString, strSql, _co);
}
else
{
add_co(SQLString, strSql, _co);
}
}
if (strList.Count > 0)
{
foreach (string s in strList)
{
_co.idx = Convert.ToInt32(s);
delete_co(SQLString, strSql, _co);
}
}
DataTable ta = getCP(_cn.CN001);
foreach (MulaolaoLibrary.FeedTestCPEntity cp in ModelCp)
{
cp.CP001 = _cn.CN001;
if (cp.idx == 0)
{
delete_cp(SQLString, strSql, cp);
}
else
{
if (Exists(cp.idx))
{
edit_cp(SQLString, strSql, cp);
}
}
}
if (ta != null && ta.Rows.Count > 0)
{
MulaolaoLibrary.FeedTestCPEntity cp = new MulaolaoLibrary.FeedTestCPEntity( );
cp.CP001 = _cn.CN001;
for (int i = 0; i < ta.Rows.Count; i++)
{
bool result = false;
cp.idx = string.IsNullOrEmpty(ta.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(ta.Rows [i] ["idx"].ToString( ));
if (cp.idx > 0)
{
foreach (MulaolaoLibrary.FeedTestCPEntity cpM in ModelCp)
{
if (cp.idx == cpM.idx)
{
result = true;
break;
}
}
if (result == false)
{
delete_cp(SQLString, strSql, cp);
}
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void add_cn(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.FeedTestCNEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_PQCN(");
strSql.Append("CN001,CN002,CN003,CN004,CN005,CN006,CN007,CN008,CN010,CN011,CN012,CN014,CN015,CN016,CN017,CN018,CN019,CN020,CN021,CN022,CN023,CN024,CN025,CN026,CN027,CN028,CN029)");
strSql.Append(" values (");
strSql.Append("@CN001,@CN002,@CN003,@CN004,@CN005,@CN006,@CN007,@CN008,@CN010,@CN011,@CN012,@CN014,@CN015,@CN016,@CN017,@CN018,@CN019,@CN020,@CN021,@CN022,@CN023,@CN024,@CN025,@CN026,@CN027,@CN028,@CN029)");
SqlParameter [] parameters =
{
new SqlParameter("@CN001", SqlDbType.NVarChar, 20),
new SqlParameter("@CN002", SqlDbType.NVarChar, 20),
new SqlParameter("@CN003", SqlDbType.NVarChar, 50),
new SqlParameter("@CN004", SqlDbType.NVarChar, 20),
new SqlParameter("@CN005", SqlDbType.NVarChar, 20),
new SqlParameter("@CN006", SqlDbType.Int, 4),
new SqlParameter("@CN007", SqlDbType.Date, 3),
new SqlParameter("@CN008", SqlDbType.Date, 3),
//new SqlParameter("@CN009", SqlDbType.NVarChar,200),
new SqlParameter("@CN010", SqlDbType.NVarChar, 200),
new SqlParameter("@CN011", SqlDbType.Date, 3),
new SqlParameter("@CN012", SqlDbType.NVarChar, 20),
//new SqlParameter("@CN013", SqlDbType.Int,4),
new SqlParameter("@CN014", SqlDbType.NVarChar, 20),
new SqlParameter("@CN015", SqlDbType.Decimal, 9),
new SqlParameter("@CN016", SqlDbType.Int, 4),
new SqlParameter("@CN017", SqlDbType.Int, 4),
new SqlParameter("@CN018", SqlDbType.Int, 4),
new SqlParameter("@CN019", SqlDbType.Decimal, 9),
new SqlParameter("@CN020", SqlDbType.Int, 4),
new SqlParameter("@CN021", SqlDbType.Int, 4),
new SqlParameter("@CN022", SqlDbType.Int, 4),
new SqlParameter("@CN023", SqlDbType.Decimal, 9),
new SqlParameter("@CN024", SqlDbType.Int, 4),
new SqlParameter("@CN025", SqlDbType.Int, 4),
new SqlParameter("@CN026", SqlDbType.Int, 4),
new SqlParameter("@CN027", SqlDbType.Bit, 1),
new SqlParameter("@CN028", SqlDbType.Bit, 1),
new SqlParameter("@CN029", SqlDbType.NVarChar, 500)
};
parameters [0].Value = model.CN001;
parameters [1].Value = model.CN002;
parameters [2].Value = model.CN003;
parameters [3].Value = model.CN004;
parameters [4].Value = model.CN005;
parameters [5].Value = model.CN006;
parameters [6].Value = model.CN007;
parameters [7].Value = model.CN008;
//parameters [ 8 ] . Value = model . CN009;
parameters [8].Value = model.CN010;
parameters [9].Value = model.CN011;
parameters [10].Value = model.CN012;
//parameters [ 12 ] . Value = model . CN013;
parameters [11].Value = model.CN014;
parameters [12].Value = model.CN015;
parameters [13].Value = model.CN016;
parameters [14].Value = model.CN017;
parameters [15].Value = model.CN018;
parameters [16].Value = model.CN019;
parameters [17].Value = model.CN020;
parameters [18].Value = model.CN021;
parameters [19].Value = model.CN022;
parameters [20].Value = model.CN023;
parameters [21].Value = model.CN024;
parameters [22].Value = model.CN025;
parameters [23].Value = model.CN026;
parameters [24].Value = model.CN027;
parameters [25].Value = model.CN028;
parameters [26].Value = model.CN029;
SQLString.Add(strSql, parameters);
}
public MulaolaoLibrary.FeedTestCNEntity getModel(DataRow row)
{
MulaolaoLibrary.FeedTestCNEntity model = new MulaolaoLibrary.FeedTestCNEntity( );
if (row != null)
{
if (row ["CN001"] != null)
{
model.CN001 = row ["CN001"].ToString( );
}
if (row ["CN002"] != null)
{
model.CN002 = row ["CN002"].ToString( );
}
if (row ["CN003"] != null)
{
model.CN003 = row ["CN003"].ToString( );
}
if (row ["CN004"] != null)
{
model.CN004 = row ["CN004"].ToString( );
}
if (row ["CN005"] != null)
{
model.CN005 = row ["CN005"].ToString( );
}
if (row ["CN006"] != null && row ["CN006"].ToString( ) != "")
{
model.CN006 = int.Parse(row ["CN006"].ToString( ));
}
if (row ["CN007"] != null && row ["CN007"].ToString( ) != "")
{
model.CN007 = DateTime.Parse(row ["CN007"].ToString( ));
}
if (row ["CN008"] != null && row ["CN008"].ToString( ) != "")
{
model.CN008 = DateTime.Parse(row ["CN008"].ToString( ));
}
//if ( row [ "CN009" ] != null )
//{
// model . CN009 = row [ "CN009" ] . ToString ( );
//}
if (row ["CN010"] != null)
{
model.CN010 = row ["CN010"].ToString( );
}
if (row ["CN011"] != null && row ["CN011"].ToString( ) != "")
{
model.CN011 = DateTime.Parse(row ["CN011"].ToString( ));
}
if (row ["CN012"] != null)
{
model.CN012 = row ["CN012"].ToString( );
}
//if ( row [ "CN013" ] != null && row [ "CN013" ] . ToString ( ) != "" )
//{
// model . CN013 = int . Parse ( row [ "CN013" ] . ToString ( ) );
//}
if (row ["CN014"] != null)
{
model.CN014 = row ["CN014"].ToString( );
}
if (row ["CN015"] != null && row ["CN015"].ToString( ) != "")
{
model.CN015 = decimal.Parse(row ["CN015"].ToString( ));
}
if (row ["CN016"] != null && row ["CN016"].ToString( ) != "")
{
model.CN016 = int.Parse(row ["CN016"].ToString( ));
}
if (row ["CN017"] != null && row ["CN017"].ToString( ) != "")
{
model.CN017 = int.Parse(row ["CN017"].ToString( ));
}
if (row ["CN018"] != null && row ["CN018"].ToString( ) != "")
{
model.CN018 = int.Parse(row ["CN018"].ToString( ));
}
if (row ["CN019"] != null && row ["CN019"].ToString( ) != "")
{
model.CN019 = decimal.Parse(row ["CN019"].ToString( ));
}
if (row ["CN020"] != null && row ["CN020"].ToString( ) != "")
{
model.CN020 = int.Parse(row ["CN020"].ToString( ));
}
if (row ["CN021"] != null && row ["CN021"].ToString( ) != "")
{
model.CN021 = int.Parse(row ["CN021"].ToString( ));
}
if (row ["CN022"] != null && row ["CN022"].ToString( ) != "")
{
model.CN022 = int.Parse(row ["CN022"].ToString( ));
}
if (row ["CN023"] != null && row ["CN023"].ToString( ) != "")
{
model.CN023 = decimal.Parse(row ["CN023"].ToString( ));
}
if (row ["CN024"] != null && row ["CN024"].ToString( ) != "")
{
model.CN024 = int.Parse(row ["CN024"].ToString( ));
}
if (row ["CN025"] != null && row ["CN025"].ToString( ) != "")
{
model.CN025 = int.Parse(row ["CN025"].ToString( ));
}
if (row ["CN026"] != null && row ["CN026"].ToString( ) != "")
{
model.CN026 = int.Parse(row ["CN026"].ToString( ));
}
if (row ["CN027"] != null && row ["CN027"].ToString( ) != "")
{
if ((row ["CN027"].ToString( ) == "1") || (row ["CN027"].ToString( ).ToLower( ) == "true"))
{
model.CN027 = true;
}
else
{
model.CN027 = false;
}
}
if (row ["CN028"] != null && row ["CN028"].ToString( ) != "")
{
if ((row ["CN028"].ToString( ) == "1") || (row ["CN028"].ToString( ).ToLower( ) == "true"))
{
model.CN028 = true;
}
else
{
model.CN028 = false;
}
}
if (row ["CN029"] != null)
{
model.CN029 = row ["CN029"].ToString( );
}
if (row ["CN030"] != null && row ["CN030"].ToString( ) != "")
{
if ((row ["CN030"].ToString( ) == "1") || (row ["CN030"].ToString( ).ToLower( ) == "true"))
{
model.CN030 = true;
}
else
{
model.CN030 = false;
}
}
if (row ["CN031"] != null && row ["CN031"].ToString( ) != "")
{
if ((row ["CN031"].ToString( ) == "1") || (row ["CN031"].ToString( ).ToLower( ) == "true"))
{
model.CN031 = true;
}
else
{
model.CN031 = false;
}
}
}
return(model);
}
/// <summary>
/// edit data to r_pqcn r_pqco r_pqcp
/// </summary>
/// <param name="table"></param>
/// <param name="_cn"></param>
/// <param name="ModelCp"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(DataTable table, MulaolaoLibrary.FeedTestCNEntity _cn, List <MulaolaoLibrary.FeedTestCPEntity> ModelCp, List <string> strList)
{
return(_dal.Edit(table, _cn, ModelCp, strList));
}
/// <summary>
/// save data to r_pqcn r_pqco r_pqcp
/// </summary>
/// <param name="table"></param>
/// <param name="_cn"></param>
/// <param name="ModelCp"></param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.FeedTestCNEntity _cn, List <MulaolaoLibrary.FeedTestCPEntity> ModelCp)
{
return(_dal.Save(table, _cn, ModelCp));
}
