void add_db(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDBEntity model)
{
strSql = new StringBuilder( );
strSql.Append("insert into R_PQDB(");
strSql.Append("DB001,DB002,DB003,DB004,DB005,DB006,DB007,DB008,DB009,DB010)");
strSql.Append(" values (");
strSql.Append("@DB001,@DB002,@DB003,@DB004,@DB005,@DB006,@DB007,@DB008,@DB009,@DB010)");
SqlParameter [] parameters =
{
new SqlParameter("@DB001", SqlDbType.NVarChar, 20),
new SqlParameter("@DB002", SqlDbType.NVarChar, 50),
new SqlParameter("@DB003", SqlDbType.NVarChar, 50),
new SqlParameter("@DB004", SqlDbType.Int, 4),
new SqlParameter("@DB005", SqlDbType.Int, 4),
new SqlParameter("@DB006", SqlDbType.Int, 4),
new SqlParameter("@DB007", SqlDbType.Int, 4),
new SqlParameter("@DB008", SqlDbType.Int, 4),
new SqlParameter("@DB009", SqlDbType.NVarChar, 100),
new SqlParameter("@DB010", SqlDbType.Int, 4)
};
parameters [0].Value = model.DB001;
parameters [1].Value = model.DB002;
parameters [2].Value = model.DB003;
parameters [3].Value = model.DB004;
parameters [4].Value = model.DB005;
parameters [5].Value = model.DB006;
parameters [6].Value = model.DB007;
parameters [7].Value = model.DB008;
parameters [8].Value = model.DB009;
parameters [9].Value = model.DB010;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// save data to r_pqda r_pqdb
/// </summary>
/// <param name="table"></param>
/// <param name="_da"></param>
/// <param name="bodyList"></param>
/// <param name="logins"></param>
/// <returns></returns>
public bool Save(DataTable table, MulaolaoLibrary.TestReportForAQDAEntity _da, List <string> bodyList, string logins)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (_da.idx < 1)
{
_da.DA001 = getOddNum( );
add_da(SQLString, strSql, _da);
SQLString.Add(Drity.DrityOfComparation("R_142", "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表头"), null);
}
else
{
edit_da(SQLString, strSql, _da);
SQLString.Add(Drity.DrityOfComparation("R_142", "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表头"), null);
}
MulaolaoLibrary.TestReportForAQDBEntity model = new MulaolaoLibrary.TestReportForAQDBEntity( );
model.DB001 = _da.DA001;
for (int i = 0; i < table.Rows.Count; i++)
{
model.idx = string.IsNullOrEmpty(table.Rows [i] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["idx"].ToString( ));
model.DB002 = table.Rows [i] ["DB002"].ToString( );
model.DB003 = table.Rows [i] ["DB003"].ToString( );
model.DB004 = string.IsNullOrEmpty(table.Rows [i] ["DB004"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB004"].ToString( ));
model.DB005 = string.IsNullOrEmpty(table.Rows [i] ["DB005"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB005"].ToString( ));
model.DB006 = string.IsNullOrEmpty(table.Rows [i] ["DB006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB006"].ToString( ));
model.DB007 = string.IsNullOrEmpty(table.Rows [i] ["DB007"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB007"].ToString( ));
model.DB008 = string.IsNullOrEmpty(table.Rows [i] ["DB008"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB008"].ToString( ));
model.DB009 = table.Rows [i] ["DB009"].ToString( );
model.DB010 = string.IsNullOrEmpty(table.Rows [i] ["DB010"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["DB010"].ToString( ));
if (model.idx < 1)
{
add_db(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_142" + i, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "新增", "新增表身"), null);
}
else
{
edit_db(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_142" + i, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "编辑", "编辑表身"), null);
}
}
if (bodyList.Count > 0)
{
foreach (string s in bodyList)
{
model.idx = Convert.ToInt32(s);
delete_db(SQLString, strSql, model);
SQLString.Add(Drity.DrityOfComparation("R_142" + model.idx, "QA测试报告(R_142)", logins, Drity.GetDt( ), _da.DA001, strSql.ToString( ).Replace("'", "''"), "删除", "删除表身"), null);
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void delete_db(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDBEntity model)
{
strSql = new StringBuilder( );
strSql.Append("delete from R_PQDB ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.idx;
SQLString.Add(strSql, parameters);
}
void edit_db(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.TestReportForAQDBEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update R_PQDB set ");
strSql.Append("DB001=@DB001,");
strSql.Append("DB002=@DB002,");
strSql.Append("DB003=@DB003,");
strSql.Append("DB004=@DB004,");
strSql.Append("DB005=@DB005,");
strSql.Append("DB006=@DB006,");
strSql.Append("DB007=@DB007,");
strSql.Append("DB008=@DB008,");
strSql.Append("DB009=@DB009,");
strSql.Append("DB010=@DB010 ");
strSql.Append(" where idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@DB001", SqlDbType.NVarChar, 20),
new SqlParameter("@DB002", SqlDbType.NVarChar, 50),
new SqlParameter("@DB003", SqlDbType.NVarChar, 50),
new SqlParameter("@DB004", SqlDbType.Int, 4),
new SqlParameter("@DB005", SqlDbType.Int, 4),
new SqlParameter("@DB006", SqlDbType.Int, 4),
new SqlParameter("@DB007", SqlDbType.Int, 4),
new SqlParameter("@DB008", SqlDbType.Int, 4),
new SqlParameter("@DB009", SqlDbType.NVarChar, 100),
new SqlParameter("@DB010", SqlDbType.Int, 4),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.DB001;
parameters [1].Value = model.DB002;
parameters [2].Value = model.DB003;
parameters [3].Value = model.DB004;
parameters [4].Value = model.DB005;
parameters [5].Value = model.DB006;
parameters [6].Value = model.DB007;
parameters [7].Value = model.DB008;
parameters [8].Value = model.DB009;
parameters [9].Value = model.DB010;
parameters [10].Value = model.idx;
SQLString.Add(strSql, parameters);
}
public FormTestReportForAQ( )
{
InitializeComponent( );
_da = new MulaolaoLibrary.TestReportForAQDAEntity( );
_db = new MulaolaoLibrary.TestReportForAQDBEntity( );
_bll = new MulaolaoBll.Bll.TestReportForAQBll( );
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( );
secDA002.Properties.DataSource = _bll.getProInfo( );
secDA002.Properties.DisplayMember = "PQF04";
secDA002.Properties.ValueMember = "PQF01";
}
