void editAll(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.PaintEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQED SET ");
strSql.Append("ED024=@ED024,");
strSql.Append("ED025=@ED025,");
strSql.Append("ED029=@ED029,");
strSql.Append("ED030=@ED030 ");
strSql.Append("WHERE ED002=@ED002 ");
SqlParameter [] parameter =
{
new SqlParameter("@ED002", SqlDbType.NVarChar, 50),
new SqlParameter("@ED024", SqlDbType.Decimal, 18),
new SqlParameter("@ED025", SqlDbType.Decimal, 18),
new SqlParameter("@ED029", SqlDbType.NVarChar, 50),
new SqlParameter("@ED030", SqlDbType.NVarChar, 255)
};
parameter [0].Value = _model.ED002;
parameter [1].Value = _model.ED024;
parameter [2].Value = _model.ED025;
parameter [3].Value = _model.ED029;
parameter [4].Value = _model.ED030;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public bool Edit(DataTable table)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
MulaolaoLibrary.PaintEntity _model = new MulaolaoLibrary.PaintEntity( );
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.ED002 = table.Rows [i] ["ED002"].ToString( );
_model.ED024 = string.IsNullOrEmpty(table.Rows [i] ["ED024"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["ED024"].ToString( ));
_model.ED025 = string.IsNullOrEmpty(table.Rows [i] ["ED025"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["ED025"].ToString( ));
_model.ED029 = table.Rows [i] ["ED029"].ToString( );
_model.ED030 = table.Rows [i] ["ED030"].ToString( );
editAll(SQLString, strSql, _model);
}
}
else
{
return(false);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void addPen(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.PaintEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQED (");
strSql.Append("ED001,ED002,ED003,ED004,ED005,ED006,ED007,ED008) ");
strSql.Append("VALUES (");
strSql.Append("@ED001,@ED002,@ED003,@ED004,@ED005,@ED006,@ED007,@ED008) ");
SqlParameter [] parameter =
{
new SqlParameter("@ED001", SqlDbType.NVarChar, 50),
new SqlParameter("@ED002", SqlDbType.NVarChar, 50),
new SqlParameter("@ED003", SqlDbType.NVarChar, 50),
new SqlParameter("@ED004", SqlDbType.Int, 4),
new SqlParameter("@ED005", SqlDbType.Date, 3),
new SqlParameter("@ED006", SqlDbType.Decimal, 18),
new SqlParameter("@ED007", SqlDbType.Decimal, 18),
new SqlParameter("@ED008", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.ED001;
parameter [1].Value = _model.ED002;
parameter [2].Value = _model.ED003;
parameter [3].Value = _model.ED004;
parameter [4].Value = _model.ED005;
parameter [5].Value = _model.ED006;
parameter [6].Value = _model.ED007;
parameter [7].Value = _model.ED008;
SQLString.Add(strSql, parameter);
}
bool Exists(MulaolaoLibrary.PaintEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT COUNT(1) FROM R_PQED WHERE ED002='{0}'", _model.ED002);
return(SqlHelper.Exists(strSql.ToString( )));
}
public FormPaint( )
{
InitializeComponent( );
_model = new MulaolaoLibrary.PaintEntity( );
_bll = new MulaolaoBll.Bll.PaintBll( );
MulaolaoBll.UserInfoMation.tableName = this.Name;
toolSave.Enabled = true;
GridViewMoHuSelect.SetFilter(bandedGridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { this.bandedGridView1 });
}
void editPen(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.PaintEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQED SET ");
strSql.Append("ED006=@ED006,");
strSql.Append("ED007=@ED007,");
strSql.Append("ED008=@ED008 ");
strSql.Append("WHERE ED002=@ED002");
SqlParameter [] parameter =
{
new SqlParameter("@ED002", SqlDbType.NVarChar, 50),
new SqlParameter("@ED006", SqlDbType.Decimal, 18),
new SqlParameter("@ED007", SqlDbType.Decimal, 18),
new SqlParameter("@ED008", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.ED002;
parameter [1].Value = _model.ED006;
parameter [2].Value = _model.ED007;
parameter [3].Value = _model.ED008;
SQLString.Add(strSql, parameter);
}
void editGun(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.PaintEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQED SET ");
strSql.Append("ED009=@ED009,");
strSql.Append("ED010=@ED010,");
strSql.Append("ED011=@ED011 ");
strSql.Append("WHERE ED002=@ED002");
SqlParameter [] parameter =
{
new SqlParameter("@ED002", SqlDbType.NVarChar, 50),
new SqlParameter("@ED009", SqlDbType.Decimal, 18),
new SqlParameter("@ED010", SqlDbType.Decimal, 18),
new SqlParameter("@ED011", SqlDbType.Decimal, 18)
};
parameter [0].Value = _model.ED002;
parameter [1].Value = _model.ED009;
parameter [2].Value = _model.ED010;
parameter [3].Value = _model.ED011;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 生成
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public bool Save(string strWhere)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
MulaolaoLibrary.PaintEntity _model = new MulaolaoLibrary.PaintEntity( );
DataTable table = getGun(strWhere);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.ED001 = table.Rows [i] ["AM003"].ToString( );
_model.ED002 = table.Rows [i] ["AM002"].ToString( );
_model.ED003 = table.Rows [i] ["AM005"].ToString( );
_model.ED004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.ED005 = null;
}
else
{
_model.ED005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.ED009 = 0;
_model.ED010 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.ED011 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editGun(SQLString, strSql, _model);
}
else
{
addGun(SQLString, strSql, _model);
}
}
}
if (SqlHelper.ExecuteSqlTran(SQLString))
{
SQLString.Clear( );
table = getPen(strWhere);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_model.ED001 = table.Rows [i] ["AM003"].ToString( );
_model.ED002 = table.Rows [i] ["AM002"].ToString( );
_model.ED003 = table.Rows [i] ["AM005"].ToString( );
_model.ED004 = string.IsNullOrEmpty(table.Rows [i] ["AM006"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["AM006"].ToString( ));
if (string.IsNullOrEmpty(table.Rows [i] ["PQF31"].ToString( )))
{
_model.ED005 = null;
}
else
{
_model.ED005 = Convert.ToDateTime(table.Rows [i] ["PQF31"].ToString( ));
}
_model.ED006 = 0;
_model.ED007 = string.IsNullOrEmpty(table.Rows [i] ["SWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["SWOODNOW"].ToString( ));
_model.ED008 = string.IsNullOrEmpty(table.Rows [i] ["YWOODNOW"].ToString( )) == true ? 0 : Convert.ToDecimal(table.Rows [i] ["YWOODNOW"].ToString( ));
if (Exists(_model))
{
editPen(SQLString, strSql, _model);
}
else
{
addPen(SQLString, strSql, _model);
}
}
}
}
else
{
return(false);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
