void DeleteExa(Hashtable SQLString, StringBuilder strSql, ReviewOrderEntity.ExaminnationEntity model)
{
strSql = new StringBuilder( );
strSql.Append("DELETE FROM DETEXA ");
strSql.AppendFormat("WHERE EXA001='{0}' AND EXA002='{1}'", model.EXA001, model.EXA002);
SQLString.Add(strSql, null);
}
void AddExa(Hashtable SQLString, StringBuilder strSql, ReviewOrderEntity.ExaminnationEntity model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO DETEXA (");
strSql.Append("EXA001,EXA002)");
strSql.Append("VALUES (");
strSql.Append("@EXA001,@EXA002)");
SqlParameter [] parameter =
{
new SqlParameter("@EXA001", SqlDbType.NVarChar, 200),
new SqlParameter("@EXA002", SqlDbType.NVarChar, 200)
};
parameter [0].Value = model.EXA001;
parameter [1].Value = model.EXA002;
SQLString.Add(strSql, parameter);
}
public ReviewOrderEntity.ExaminnationEntity getModel(DataRow row)
{
ReviewOrderEntity.ExaminnationEntity model = new ReviewOrderEntity.ExaminnationEntity( );
if (row != null)
{
if (row ["EXA001"] != null)
{
model.EXA001 = row ["EXA001"].ToString( );
}
if (row ["EXA002"] != null)
{
model.EXA002 = row ["EXA002"].ToString( );
}
}
return(model);
}
/// <summary>
/// 保存审批表单相关
/// </summary>
/// <param name="tableView"></param>
/// <returns></returns>
public bool SaveTableView(DataTable tableView)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
DataTable dt = getTableExa( );
bool result = false;
if (dt != null && dt.Rows.Count > 0)
{
result = true;
}
ReviewOrderEntity.ExaminnationEntity model = new ReviewOrderEntity.ExaminnationEntity( );
for (int i = 0; i < tableView.Rows.Count; i++)
{
model.EXA001 = tableView.Rows [i] ["EXA001"].ToString( );
model.EXA002 = tableView.Rows [i] ["EXA002"].ToString( );
if (result == false)
{
AddExa(SQLString, strSql, model);
}
else
{
if (dt.Select("EXA001='" + model.EXA001 + "' AND EXA002='" + model.EXA002 + "'").Length < 1)
{
AddExa(SQLString, strSql, model);
}
}
}
if (result)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
model.EXA001 = dt.Rows [i] ["EXA001"].ToString( );
model.EXA002 = dt.Rows [i] ["EXA002"].ToString( );
if (tableView.Select("EXA001='" + model.EXA001 + "' AND EXA002='" + model.EXA002 + "'").Length < 1)
{
DeleteExa(SQLString, strSql, model);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
