void EditBody(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QupEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_QUR set ");
strSql.Append("QUR001=@QUR001,");
strSql.Append("QUR002=@QUR002,");
strSql.Append("QUR003=@QUR003,");
strSql.Append("QUR004=@QUR004,");
strSql.Append("QUR005=@QUR005,");
strSql.Append("QUR006=@QUR006,");
strSql.Append("QUR007=@QUR007,");
strSql.Append("QUR008=@QUR008,");
strSql.Append("QUR009=@QUR009,");
strSql.Append("QUR010=@QUR010,");
strSql.Append("QUR011=@QUR011,");
strSql.Append("QUR012=@QUR012,");
strSql.Append("QUR013=@QUR013,");
strSql.Append("QUR014=@QUR014,");
strSql.Append("QUR015=@QUR015,");
strSql.Append("QUR016=@QUR016 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@QUR001", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR002", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR003", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR004", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR005", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR006", SqlDbType.Decimal, 9),
new SqlParameter("@QUR007", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR008", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR009", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR010", SqlDbType.Decimal, 9),
new SqlParameter("@QUR011", SqlDbType.Decimal, 9),
new SqlParameter("@QUR012", SqlDbType.Decimal, 9),
new SqlParameter("@QUR013", SqlDbType.Decimal, 9),
new SqlParameter("@QUR014", SqlDbType.Decimal, 9),
new SqlParameter("@idx", SqlDbType.Int, 4),
new SqlParameter("@QUR015", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR016", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.QUR001;
parameters [1].Value = model.QUR002;
parameters [2].Value = model.QUR003;
parameters [3].Value = model.QUR004;
parameters [4].Value = model.QUR005;
parameters [5].Value = model.QUR006;
parameters [6].Value = model.QUR007;
parameters [7].Value = model.QUR008;
parameters [8].Value = model.QUR009;
parameters [9].Value = model.QUR010;
parameters [10].Value = model.QUR011;
parameters [11].Value = model.QUR012;
parameters [12].Value = model.QUR013;
parameters [13].Value = model.QUR014;
parameters [14].Value = model.idx;
parameters [15].Value = model.QUR015;
parameters [16].Value = model.QUR016;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="_quo"></param>
/// <param name="table"></param>
/// <param name="state"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Save(MulaolaoLibrary.QuoEntity _quo, DataTable table, string state, List <string> idxList)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (state.Equals("add"))
{
_quo.QUO001 = getOddNum( );
AddHeader(SQLString, strSql, _quo);
}
else
{
EditHeader(SQLString, strSql, _quo);
}
MulaolaoLibrary.QupEntity _qup = new MulaolaoLibrary.QupEntity( );
_qup.QUR001 = _quo.QUO001;
for (int i = 0; i < table.Rows.Count; i++)
{
_qup.QUR002 = table.Rows [i] ["QUR002"].ToString( );
_qup.QUR003 = table.Rows [i] ["QUR003"].ToString( );
_qup.QUR004 = table.Rows [i] ["QUR004"].ToString( );
_qup.QUR005 = table.Rows [i] ["QUR005"].ToString( );
_qup.QUR006 = string.IsNullOrEmpty(table.Rows [i] ["QUR006"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR006"].ToString( ));
_qup.QUR007 = table.Rows [i] ["QUR007"].ToString( );
_qup.QUR008 = table.Rows [i] ["QUR008"].ToString( );
_qup.QUR009 = table.Rows [i] ["QUR009"].ToString( );
_qup.QUR010 = string.IsNullOrEmpty(table.Rows [i] ["QUR010"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR010"].ToString( ));
_qup.QUR011 = string.IsNullOrEmpty(table.Rows [i] ["QUR011"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR011"].ToString( ));
_qup.QUR012 = string.IsNullOrEmpty(table.Rows [i] ["QUR012"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR012"].ToString( ));
_qup.QUR013 = string.IsNullOrEmpty(table.Rows [i] ["QUR013"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR013"].ToString( ));
_qup.QUR014 = string.IsNullOrEmpty(table.Rows [i] ["QUR014"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR014"].ToString( ));
_qup.QUR016 = string.IsNullOrEmpty(table.Rows [i] ["QUR016"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["QUR016"].ToString( ));
_qup.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
_qup.QUR015 = table.Rows [i] ["QUR015"].ToString( );
if (_qup.idx < 1)
{
AddBody(SQLString, strSql, _qup);
}
else
{
EditBody(SQLString, strSql, _qup);
}
}
if (idxList.Count > 0)
{
foreach (string s in idxList)
{
DeleteBody(SQLString, strSql, s);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
public FormQuotation( )
{
InitializeComponent( );
_bll = new MulaolaoBll.Bll.QuoBll( );
_quo = new MulaolaoLibrary.QuoEntity( );
_qup = new MulaolaoLibrary.QupEntity( );
controlUnEnable( );
InitData( );
GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, ViewFor });
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1, ViewFor });
dt = Drity.GetDt( );
}
void AddBody(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.QupEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_QUR(");
strSql.Append("QUR001,QUR002,QUR003,QUR004,QUR005,QUR006,QUR007,QUR008,QUR009,QUR010,QUR011,QUR012,QUR013,QUR014,QUR015,QUR016)");
strSql.Append(" values (");
strSql.Append("@QUR001,@QUR002,@QUR003,@QUR004,@QUR005,@QUR006,@QUR007,@QUR008,@QUR009,@QUR010,@QUR011,@QUR012,@QUR013,@QUR014,@QUR015,@QUR016)");
SqlParameter [] parameters =
{
new SqlParameter("@QUR001", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR002", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR003", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR004", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR005", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR006", SqlDbType.Decimal, 9),
new SqlParameter("@QUR007", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR008", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR009", SqlDbType.NVarChar, 20),
new SqlParameter("@QUR010", SqlDbType.Decimal, 9),
new SqlParameter("@QUR011", SqlDbType.Decimal, 9),
new SqlParameter("@QUR012", SqlDbType.Decimal, 9),
new SqlParameter("@QUR013", SqlDbType.Decimal, 9),
new SqlParameter("@QUR014", SqlDbType.Decimal, 9),
new SqlParameter("@QUR015", SqlDbType.NVarChar, 50),
new SqlParameter("@QUR016", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.QUR001;
parameters [1].Value = model.QUR002;
parameters [2].Value = model.QUR003;
parameters [3].Value = model.QUR004;
parameters [4].Value = model.QUR005;
parameters [5].Value = model.QUR006;
parameters [6].Value = model.QUR007;
parameters [7].Value = model.QUR008;
parameters [8].Value = model.QUR009;
parameters [9].Value = model.QUR010;
parameters [10].Value = model.QUR011;
parameters [11].Value = model.QUR012;
parameters [12].Value = model.QUR013;
parameters [13].Value = model.QUR014;
parameters [14].Value = model.QUR015;
parameters [15].Value = model.QUR016;
SQLString.Add(strSql, parameters);
}
