/// <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())));
}
