/// <summary>
/// 增加一条数据
/// </summary>
public int Add(M_reviewremarks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hx_td_reviewremarks(");
strSql.Append("targetid,tender_state,reviewremarks,reviewtime,admin_operator)");
strSql.Append(" values (");
strSql.Append("@targetid,@tender_state,@reviewremarks,@reviewtime,@admin_operator)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@targetid", SqlDbType.Int, 4),
new SqlParameter("@tender_state", SqlDbType.Int, 4),
new SqlParameter("@reviewremarks", SqlDbType.VarChar, 1000),
new SqlParameter("@reviewtime", SqlDbType.DateTime),
new SqlParameter("@admin_operator", SqlDbType.Int, 4)
};
parameters[0].Value = model.targetid;
parameters[1].Value = model.tender_state;
parameters[2].Value = model.reviewremarks;
parameters[3].Value = model.reviewtime;
parameters[4].Value = model.admin_operator;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_reviewremarks DataRowToModel(DataRow row)
{
M_reviewremarks model = new M_reviewremarks();
if (row != null)
{
if (row["reviewid"] != null && row["reviewid"].ToString() != "")
{
model.reviewid = int.Parse(row["reviewid"].ToString());
}
if (row["targetid"] != null && row["targetid"].ToString() != "")
{
model.targetid = int.Parse(row["targetid"].ToString());
}
if (row["tender_state"] != null && row["tender_state"].ToString() != "")
{
model.tender_state = int.Parse(row["tender_state"].ToString());
}
if (row["reviewremarks"] != null)
{
model.reviewremarks = row["reviewremarks"].ToString();
}
if (row["reviewtime"] != null && row["reviewtime"].ToString() != "")
{
model.reviewtime = DateTime.Parse(row["reviewtime"].ToString());
}
if (row["admin_operator"] != null && row["admin_operator"].ToString() != "")
{
model.admin_operator = int.Parse(row["admin_operator"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(M_reviewremarks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update hx_td_reviewremarks set ");
strSql.Append("targetid=@targetid,");
strSql.Append("tender_state=@tender_state,");
strSql.Append("reviewremarks=@reviewremarks,");
strSql.Append("reviewtime=@reviewtime,");
strSql.Append("admin_operator=@admin_operator");
strSql.Append(" where reviewid=@reviewid");
SqlParameter[] parameters =
{
new SqlParameter("@targetid", SqlDbType.Int, 4),
new SqlParameter("@tender_state", SqlDbType.Int, 4),
new SqlParameter("@reviewremarks", SqlDbType.VarChar, 1000),
new SqlParameter("@reviewtime", SqlDbType.DateTime),
new SqlParameter("@admin_operator", SqlDbType.Int, 4),
new SqlParameter("@reviewid", SqlDbType.Int, 4)
};
parameters[0].Value = model.targetid;
parameters[1].Value = model.tender_state;
parameters[2].Value = model.reviewremarks;
parameters[3].Value = model.reviewtime;
parameters[4].Value = model.admin_operator;
parameters[5].Value = model.reviewid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_reviewremarks GetModel(int reviewid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 reviewid,targetid,tender_state,reviewremarks,reviewtime,admin_operator from hx_td_reviewremarks ");
strSql.Append(" where reviewid=@reviewid");
SqlParameter[] parameters =
{
new SqlParameter("@reviewid", SqlDbType.Int, 4)
};
parameters[0].Value = reviewid;
M_reviewremarks model = new M_reviewremarks();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(M_reviewremarks model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(M_reviewremarks model)
{
return(dal.Add(model));
}
