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