public FormPeragg( )
{
InitializeComponent( );
_model = new MulaolaoLibrary.PeraggEntity( );
_bll = new MulaolaoBll.Bll.PeraggBll( );
GridViewMoHuSelect.SetFilter(gridView1);
Power(this);
controlUnEnable( );
lupPerson.Properties.DataSource = _bll.getUser( );
lupPerson.Properties.DisplayMember = "XZ004";
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
//lupPerson . EditValue = "黄贵洪";
//toolStrip1 . Items . Remove ( toolReview );
//toolStrip1 . Items . Remove ( toolExport );
//toolStrip1 . Items . Remove ( toolPrint );
//toolStrip1 . Items . Remove ( toolStorage );
//toolStrip1 . Items . Remove ( toolLibrary );
//toolStrip1 . Items . Remove ( toolCancel );
//toolStrip1 . Items . Remove ( toolcopy );
//toolStrip1 . Items . Remove ( toolMaintain );
}
void edit_pqca(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.PeraggEntity model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQCA SET ");
strSql.Append("CA003=@CA003,");
strSql.Append("CA004=@CA004,");
strSql.Append("CA005=@CA005,");
strSql.Append("CA006=@CA006,");
strSql.Append("CA007=@CA007,");
strSql.Append("CA008=@CA008,");
strSql.Append("CA011=@CA011,");
strSql.Append("CA012=@CA012,");
strSql.Append("CA013=@CA013,");
strSql.Append("CA014=@CA014,");
strSql.Append("CA015=@CA015,");
strSql.Append("CA010=@CA010,");
strSql.Append("CA018=@CA018,");
strSql.Append("CA019=@CA019,");
strSql.Append("CA020=@CA020 ");
strSql.Append(" WHERE idx=@idx");
SqlParameter [] parameters =
{
new SqlParameter("@CA003", SqlDbType.Decimal, 9),
new SqlParameter("@CA004", SqlDbType.Decimal, 9),
new SqlParameter("@CA005", SqlDbType.Decimal, 9),
new SqlParameter("@CA006", SqlDbType.Decimal, 9),
new SqlParameter("@CA007", SqlDbType.Decimal, 9),
new SqlParameter("@CA008", SqlDbType.Decimal, 9),
new SqlParameter("@CA011", SqlDbType.Decimal, 9),
new SqlParameter("@CA012", SqlDbType.Decimal, 9),
new SqlParameter("@CA013", SqlDbType.Decimal, 9),
new SqlParameter("@CA014", SqlDbType.Decimal, 9),
new SqlParameter("@CA015", SqlDbType.Decimal, 9),
new SqlParameter("@CA010", SqlDbType.Decimal, 9),
new SqlParameter("@CA018", SqlDbType.Decimal, 9),
new SqlParameter("@CA019", SqlDbType.Decimal, 9),
new SqlParameter("@CA020", SqlDbType.Decimal, 9),
new SqlParameter("@idx", SqlDbType.Int, 4)
};
parameters [0].Value = model.CA003;
parameters [1].Value = model.CA004;
parameters [2].Value = model.CA005;
parameters [3].Value = model.CA006;
parameters [4].Value = model.CA007;
parameters [5].Value = model.CA008;
parameters [6].Value = model.CA011;
parameters [7].Value = model.CA012;
parameters [8].Value = model.CA013;
parameters [9].Value = model.CA014;
parameters [10].Value = model.CA015;
parameters [11].Value = model.CA010;
parameters [12].Value = model.CA018;
parameters [13].Value = model.CA019;
parameters [14].Value = model.CA020;
parameters [15].Value = model.idx;
SQLString.Add(strSql, parameters);
}
void add_pqca(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.PeraggEntity model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQCA (");
strSql.Append("CA001,CA002,CA016,CA017,CA003,CA004,CA005,CA006,CA007,CA008,CA009,CA010,CA011,CA012,CA013,CA014,CA015,CA018,CA019,CA020)");
strSql.Append(" VALUES (");
strSql.Append("@CA001,@CA002,@CA016,@CA017,@CA003,@CA004,@CA005,@CA006,@CA007,@CA008,@CA009,@CA010,@CA011,@CA012,@CA013,@CA014,@CA015,@CA018,@CA019,@CA020)");
SqlParameter [] parameters =
{
new SqlParameter("@CA001", SqlDbType.NVarChar, 50),
new SqlParameter("@CA002", SqlDbType.Int, 4),
new SqlParameter("@CA016", SqlDbType.NVarChar, 50),
new SqlParameter("@CA017", SqlDbType.Int, 4),
new SqlParameter("@CA003", SqlDbType.Decimal, 9),
new SqlParameter("@CA004", SqlDbType.Decimal, 9),
new SqlParameter("@CA005", SqlDbType.Decimal, 9),
new SqlParameter("@CA006", SqlDbType.Decimal, 9),
new SqlParameter("@CA007", SqlDbType.Decimal, 9),
new SqlParameter("@CA008", SqlDbType.Decimal, 9),
new SqlParameter("@CA009", SqlDbType.Decimal, 9),
new SqlParameter("@CA010", SqlDbType.Decimal, 9),
new SqlParameter("@CA011", SqlDbType.Decimal, 9),
new SqlParameter("@CA012", SqlDbType.Decimal, 9),
new SqlParameter("@CA013", SqlDbType.Decimal, 9),
new SqlParameter("@CA014", SqlDbType.Decimal, 9),
new SqlParameter("@CA015", SqlDbType.Decimal, 9),
new SqlParameter("@CA018", SqlDbType.Decimal, 9),
new SqlParameter("@CA019", SqlDbType.Decimal, 9),
new SqlParameter("@CA020", SqlDbType.Decimal, 9)
};
parameters [0].Value = model.CA001;
parameters [1].Value = model.CA002;
parameters [2].Value = model.CA016;
parameters [3].Value = model.CA017;
parameters [4].Value = model.CA003;
parameters [5].Value = model.CA004;
parameters [6].Value = model.CA005;
parameters [7].Value = model.CA006;
parameters [8].Value = model.CA007;
parameters [9].Value = model.CA008;
parameters [10].Value = model.CA009;
parameters [11].Value = model.CA010;
parameters [12].Value = model.CA011;
parameters [13].Value = model.CA012;
parameters [14].Value = model.CA013;
parameters [15].Value = model.CA014;
parameters [16].Value = model.CA015;
parameters [17].Value = model.CA018;
parameters [18].Value = model.CA019;
parameters [19].Value = model.CA020;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 生成数据
/// </summary>
/// <param name="table"></param>
/// <param name="userName"></param>
/// <param name="year"></param>
/// <returns></returns>
public bool GeneralTable(string userName, int year)
{
DataTable table = GetDataTableRead(userName, year);
if (table == null && table.Rows.Count < 1)
{
return(false);
}
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
MulaolaoLibrary.PeraggEntity _model = new MulaolaoLibrary.PeraggEntity( );
_model.CA001 = getOdd(userName);
if (string.IsNullOrEmpty(_model.CA001))
{
_model.CA001 = getOdd( );
}
DataTable dt = getTableWhether(_model.CA001);
for (int i = 0; i < table.Rows.Count; i++)
{
_model.CA002 = string.IsNullOrEmpty(table.Rows [i] ["CA002"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CA002"].ToString( ));
_model.CA003 = string.IsNullOrEmpty(table.Rows [i] ["CA003"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA003"].ToString( ));
_model.CA004 = string.IsNullOrEmpty(table.Rows [i] ["CA004"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA004"].ToString( ));
_model.CA005 = string.IsNullOrEmpty(table.Rows [i] ["CA005"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA005"].ToString( ));
_model.CA006 = string.IsNullOrEmpty(table.Rows [i] ["CA006"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA006"].ToString( ));
_model.CA007 = string.IsNullOrEmpty(table.Rows [i] ["CA007"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA007"].ToString( ));
_model.CA008 = string.IsNullOrEmpty(table.Rows [i] ["CA008"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA008"].ToString( ));
_model.CA009 = 0;
_model.CA010 = 0;
_model.CA011 = string.IsNullOrEmpty(table.Rows [i] ["CA011"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA011"].ToString( ));
_model.CA012 = string.IsNullOrEmpty(table.Rows [i] ["CA012"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA012"].ToString( ));
_model.CA013 = string.IsNullOrEmpty(table.Rows [i] ["CA013"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA013"].ToString( ));
_model.CA014 = string.IsNullOrEmpty(table.Rows [i] ["CA014"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA014"].ToString( ));
_model.CA015 = string.IsNullOrEmpty(table.Rows [i] ["CA015"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA015"].ToString( ));
_model.CA016 = table.Rows [i] ["CA016"].ToString( );
_model.CA017 = string.IsNullOrEmpty(table.Rows [i] ["CA017"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["CA017"].ToString( ));
_model.CA018 = string.IsNullOrEmpty(table.Rows [i] ["CA018"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA018"].ToString( ));
_model.CA019 = string.IsNullOrEmpty(table.Rows [i] ["CA019"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["CA019"].ToString( ));
_model.CA020 = 0;
if (dt == null || dt.Rows.Count < 1)
{
add_pqca(SQLString, strSql, _model);
}
else
{
if (dt.Select("CA016='" + _model.CA016 + "' AND CA002='" + _model.CA002 + "' AND CA017='" + _model.CA017 + "'").Length > 0)
{
_model.idx = string.IsNullOrEmpty(dt.Select("CA016='" + _model.CA016 + "' AND CA002='" + _model.CA002 + "' AND CA017='" + _model.CA017 + "'") [0] ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(dt.Select("CA016='" + _model.CA016 + "' AND CA002='" + _model.CA002 + "' AND CA017='" + _model.CA017 + "'") [0] ["idx"].ToString( ));
edit_pqca(SQLString, strSql, _model);
}
else
{
add_pqca(SQLString, strSql, _model);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
