/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebApi_Model.T_User_SMSCode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_User_SMSCode set ");
strSql.Append("Tel=@Tel,");
strSql.Append("SendTime=@SendTime,");
strSql.Append("OverDueTime=@OverDueTime,");
strSql.Append("Code=@Code,");
strSql.Append("Type=@Type,");
strSql.Append("Message=@Message,");
strSql.Append("Active=@Active");
strSql.Append(" where CodeID=@CodeID");
SqlParameter[] parameters =
{
new SqlParameter("@Tel", SqlDbType.NVarChar, 11),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@OverDueTime", SqlDbType.DateTime),
new SqlParameter("@Code", SqlDbType.NVarChar, 6),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@Message", SqlDbType.NVarChar, 200),
new SqlParameter("@Active", SqlDbType.Int, 4),
new SqlParameter("@CodeID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Tel;
parameters[1].Value = model.SendTime;
parameters[2].Value = model.OverDueTime;
parameters[3].Value = model.Code;
parameters[4].Value = model.Type;
parameters[5].Value = model.Message;
parameters[6].Value = model.Active;
parameters[7].Value = model.CodeID;
int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_User_SMSCode DataRowToModel(DataRow row)
{
WebApi_Model.T_User_SMSCode model = new WebApi_Model.T_User_SMSCode();
if (row != null)
{
if (row["CodeID"] != null && row["CodeID"].ToString() != "")
{
model.CodeID = int.Parse(row["CodeID"].ToString());
}
if (row["Tel"] != null)
{
model.Tel = row["Tel"].ToString();
}
if (row["SendTime"] != null && row["SendTime"].ToString() != "")
{
model.SendTime = DateTime.Parse(row["SendTime"].ToString());
}
if (row["OverDueTime"] != null && row["OverDueTime"].ToString() != "")
{
model.OverDueTime = DateTime.Parse(row["OverDueTime"].ToString());
}
if (row["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["Type"] != null && row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["Message"] != null)
{
model.Message = row["Message"].ToString();
}
if (row["Active"] != null && row["Active"].ToString() != "")
{
model.Active = int.Parse(row["Active"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebApi_Model.T_User_SMSCode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_User_SMSCode(");
strSql.Append("Tel,SendTime,OverDueTime,Code,Type,Message,Active)");
strSql.Append(" values (");
strSql.Append("@Tel,@SendTime,@OverDueTime,@Code,@Type,@Message,@Active)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Tel", SqlDbType.NVarChar, 11),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@OverDueTime", SqlDbType.DateTime),
new SqlParameter("@Code", SqlDbType.NVarChar, 6),
new SqlParameter("@Type", SqlDbType.Int, 4),
new SqlParameter("@Message", SqlDbType.NVarChar, 200),
new SqlParameter("@Active", SqlDbType.Int, 4)
};
parameters[0].Value = model.Tel;
parameters[1].Value = model.SendTime;
parameters[2].Value = model.OverDueTime;
parameters[3].Value = model.Code;
parameters[4].Value = model.Type;
parameters[5].Value = model.Message;
parameters[6].Value = model.Active;
object obj = DBHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_User_SMSCode GetModel(int CodeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CodeID,Tel,SendTime,OverDueTime,Code,Type,Message,Active from T_User_SMSCode ");
strSql.Append(" where CodeID=@CodeID");
SqlParameter[] parameters =
{
new SqlParameter("@CodeID", SqlDbType.Int, 4)
};
parameters[0].Value = CodeID;
WebApi_Model.T_User_SMSCode model = new WebApi_Model.T_User_SMSCode();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
