void Edit(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.ContCheckTableEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEA SET ");
strSql.Append("EA003=@EA003,");
strSql.Append("EA004=@EA004,");
strSql.Append("EA005=@EA005 ");
strSql.Append(" WHERE EA001=@EA001");
strSql.Append(" AND EA002=@EA002");
SqlParameter [] parameter =
{
new SqlParameter("@EA001", SqlDbType.NVarChar, 50),
new SqlParameter("@EA002", SqlDbType.NVarChar, 255),
new SqlParameter("@EA003", SqlDbType.Date),
new SqlParameter("@EA004", SqlDbType.Bit),
new SqlParameter("@EA005", SqlDbType.Bit)
};
parameter [0].Value = _model.EA001;
parameter [1].Value = _model.EA002;
parameter [2].Value = _model.EA003;
parameter [3].Value = _model.EA004;
parameter [4].Value = _model.EA005;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public bool Update(DataTable table)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
if (table != null && table.Rows.Count > 0)
{
MulaolaoLibrary.ContCheckTableEntity _model = new MulaolaoLibrary.ContCheckTableEntity( );
for (int i = 0; i < table.Rows.Count; i++)
{
_model.EA001 = table.Rows [i] ["CP03"].ToString( );
_model.EA002 = table.Rows [i] ["CP01"].ToString( );
if (string.IsNullOrEmpty(table.Rows [i] ["RES04"].ToString( )))
{
_model.EA003 = null;
}
else
{
_model.EA003 = Convert.ToDateTime(table.Rows [i] ["RES04"].ToString( ));
}
_model.EA004 = string.IsNullOrEmpty(table.Rows [i] ["AK"].ToString( )) == true ? false : (table.Rows [i] ["AK"].ToString( ).Equals("已结") ? true : false);
_model.EA005 = string.IsNullOrEmpty(table.Rows [i] ["EA005"].ToString( )) == true ? false : true;
if (!Exists(_model))
{
Add(SQLString, strSql, _model);
}
else
{
Edit(SQLString, strSql, _model);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
bool Exists(MulaolaoLibrary.ContCheckTableEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT COUNT(1) FROM R_PQEA WHERE EA001='{0}' AND EA002='{1}'", _model.EA001, _model.EA002);
return(SqlHelper.Exists(strSql.ToString( )));
}
public FormContCheckTable( )
{
InitializeComponent( );
GridViewMoHuSelect.SetFilter(gridView1);
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
MulaolaoBll.UserInfoMation.tableName = this.Name;
GridViewMoHuSelect.SetFilter(gridView1);
_bll = new MulaolaoBll.Bll.ContCheckTablBll( );
_model = new MulaolaoLibrary.ContCheckTableEntity( );
toolAdd.Text = "查询全部";
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.ContCheckTableEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("DELETE FROM R_PQEA WHERE EA001='{0}' AND EA002='{1}'", _model.EA001, _model.EA002);
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ));
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
void Add(Hashtable SQLString, StringBuilder strSql, MulaolaoLibrary.ContCheckTableEntity _model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQEA (");
strSql.Append("EA001,EA002,EA003,EA004,EA005) ");
strSql.Append("VALUES (");
strSql.Append("@EA001,@EA002,@EA003,@EA004,@EA005)");
SqlParameter [] parameter =
{
new SqlParameter("@EA001", SqlDbType.NVarChar, 50),
new SqlParameter("@EA002", SqlDbType.NVarChar, 255),
new SqlParameter("@EA003", SqlDbType.Date),
new SqlParameter("@EA004", SqlDbType.Bit),
new SqlParameter("@EA005", SqlDbType.Bit)
};
parameter [0].Value = _model.EA001;
parameter [1].Value = _model.EA002;
parameter [2].Value = _model.EA003;
parameter [3].Value = _model.EA004;
parameter [4].Value = _model.EA005;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.ContCheckTableEntity _model)
{
return(_dal.Delete(_model));
}
