/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhongLi.Model.PhoneCode model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@Phone", SqlDbType.NVarChar, 50), new SqlParameter("@VerCode", SqlDbType.NVarChar, 50), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@SendType", SqlDbType.Int, 4) }; parameters[0].Value = model.Phone; parameters[1].Value = model.VerCode; parameters[2].Value = model.SendTime; parameters[3].Value = model.SendType; DbHelperSQL.RunProcedure("PhoneCode_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ZhongLi.Model.PhoneCode model) { SqlParameter[] parameters = { new SqlParameter("@Phone", SqlDbType.NVarChar, 50), new SqlParameter("@VerCode", SqlDbType.NVarChar, 50), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@SendType", SqlDbType.Int, 4) }; parameters[0].Value = model.Phone; parameters[1].Value = model.VerCode; parameters[2].Value = model.SendTime; parameters[3].Value = model.SendType; DbHelperSQL.RunProcedure("PhoneCode_ADD", parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.PhoneCode GetModel(string Phone) { SqlParameter[] parameters = { new SqlParameter("@Phone", SqlDbType.NVarChar, 50) }; parameters[0].Value = Phone; ZhongLi.Model.PhoneCode model = new ZhongLi.Model.PhoneCode(); DataSet ds = DbHelperSQL.RunProcedure("PhoneCode_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.PhoneCode DataRowToModel(DataRow row) { ZhongLi.Model.PhoneCode model = new ZhongLi.Model.PhoneCode(); if (row != null) { if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["VerCode"] != null) { model.VerCode = row["VerCode"].ToString(); } if (row["SendTime"] != null && row["SendTime"].ToString() != "") { model.SendTime = DateTime.Parse(row["SendTime"].ToString()); } if (row["SendType"] != null && row["SendType"].ToString() != "") { model.SendType = int.Parse(row["SendType"].ToString()); } } return(model); }