/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(Model.RegistInfo model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update RegistInfo set "); strSql.Append(" GId = @GId , "); strSql.Append(" MID = @MID , "); strSql.Append(" MEmail = @MEmail , "); strSql.Append(" MCreateTime = @MCreateTime , "); strSql.Append(" UseTime = @UseTime , "); strSql.Append(" State = @State "); strSql.Append(" where GId=@GId "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@GId", SqlDbType.VarChar, 70), new SqlParameter("@MID", SqlDbType.VarChar, 50), new SqlParameter("@MEmail", SqlDbType.VarChar, 50), new SqlParameter("@MCreateTime", SqlDbType.DateTime), new SqlParameter("@UseTime", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.Int, 4) }; parameters[0].Value = model.GId; parameters[1].Value = model.MID; parameters[2].Value = model.MEmail; parameters[3].Value = model.MCreateTime; parameters[4].Value = model.UseTime; parameters[5].Value = model.State; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.RegistInfo model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RegistInfo("); strSql.Append("GId,MID,MEmail,MCreateTime,UseTime,State"); strSql.Append(") values ("); strSql.Append("@GId,@MID,@MEmail,@MCreateTime,@UseTime,@State"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@GId", SqlDbType.VarChar, 70), new SqlParameter("@MID", SqlDbType.VarChar, 50), new SqlParameter("@MEmail", SqlDbType.VarChar, 50), new SqlParameter("@MCreateTime", SqlDbType.DateTime), new SqlParameter("@UseTime", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.Int, 4) }; parameters[0].Value = model.GId; parameters[1].Value = model.MID; parameters[2].Value = model.MEmail; parameters[3].Value = model.MCreateTime; parameters[4].Value = model.UseTime; parameters[5].Value = model.State; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 实体转换 /// <summary> private static Model.RegistInfo TranEntity(DataRow dr) { if (dr != null) { Model.RegistInfo model = new Model.RegistInfo(); model.GId = dr["GId"].ToString(); model.MID = dr["MID"].ToString(); model.MEmail = dr["MEmail"].ToString(); if (!string.IsNullOrEmpty(dr["MCreateTime"].ToString())) { model.MCreateTime = DateTime.Parse(dr["MCreateTime"].ToString()); } if (!string.IsNullOrEmpty(dr["UseTime"].ToString())) { model.UseTime = DateTime.Parse(dr["UseTime"].ToString()); } if (!string.IsNullOrEmpty(dr["State"].ToString())) { model.State = int.Parse(dr["State"].ToString()); } return(model); } else { return(null); } }
public static bool Update(Model.RegistInfo model) { return(WE_Project.DAL.RegistInfo.Update(model)); }
public static Hashtable Update(Model.RegistInfo model, Hashtable MyHs) { return(WE_Project.DAL.RegistInfo.Update(model, MyHs)); }
public static bool Insert(Model.RegistInfo model) { return(WE_Project.DAL.RegistInfo.Insert(model)); }
public static Hashtable Insert(Model.RegistInfo model, Hashtable MyHs) { return(WE_Project.DAL.RegistInfo.Insert(model, MyHs)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(Model.RegistInfo model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.RegistInfo model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }