/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.TASK_SCHEME_LIST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE LHF.TASK_SCHEME_LIST SET ");
strSql.Append("SCHEMENAME=@in_SCHEMENAME,");
strSql.Append("SCHEMEBTIME=@in_SCHEMEBTIME,");
strSql.Append("SCHEMEETIME=@in_SCHEMEETIME");
strSql.Append("DISAID=@in_DISAID");
strSql.Append(" WHERE SCHEMEID=@in_SCHEMEID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SCHEMEID", SqlDbType.Int),
new SqlParameter("@in_SCHEMENAME", SqlDbType.NVarChar),
new SqlParameter("@in_SCHEMEBTIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEETIME", SqlDbType.DateTime),
new SqlParameter("@in_DISAID", SqlDbType.Int)
};
cmdParms[0].Value = model.SCHEMEID;
cmdParms[1].Value = model.SCHEMENAME;
cmdParms[2].Value = model.SCHEMEBTIME;
cmdParms[3].Value = model.SCHEMEETIME;
cmdParms[4].Value = model.DISAID;
return(DbHelperSQL.ExecuteSql(strSql.ToString()));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.TASK_SCHEME_LIST GetModel(DbDataReader dr)
{
Model.TASK_SCHEME_LIST model = new Model.TASK_SCHEME_LIST();
model.SCHEMEID = Convert.ToInt32(dr["SCHEMEID"]);
model.SCHEMENAME = Convert.ToString(dr["SCHEMENAME"]);
model.SCHEMEBTIME = Convert.ToDateTime(dr["SCHEMEBTIME"]);
model.SCHEMEETIME = Convert.ToDateTime(dr["SCHEMEETIME"]);
model.DISAID = Convert.ToInt32(dr["DISAID"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.TASK_SCHEME_LIST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.TASK_SCHEME_LIST(");
strSql.Append("SCHEMENAME,SCHEMEBTIME,SCHEMEETIME,DISAID)");
strSql.Append(" VALUES (");
strSql.Append("@in_SCHEMENAME,@in_SCHEMEBTIME,@in_SCHEMEETIME,@in_DISAID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SCHEMENAME", SqlDbType.NVarChar),
new SqlParameter("@in_SCHEMEBTIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEETIME", SqlDbType.DateTime),
new SqlParameter("@in_DISAID", SqlDbType.Int)
};
cmdParms[0].Value = model.SCHEMENAME;
cmdParms[1].Value = model.SCHEMEBTIME;
cmdParms[2].Value = model.SCHEMEETIME;
cmdParms[3].Value = model.DISAID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
