private static string AddLaw()
{
string strreturn;
string strTitle = NetSchool.Common.Library.GetPostBack.GetPostBackStr("title");
string strContent = Microsoft.JScript.GlobalObject.unescape(NetSchool.Common.Library.GetPostBack.GetPostBackStr("content"));
NetSchool.Model.Law lawInfo = new Model.Law();
lawInfo.LawID = Guid.NewGuid();
lawInfo.Title = strTitle;
lawInfo.Content = strContent;
lawInfo.ViewNum = 0;
lawInfo.Author = NetSchool.Common.Info.CurUserInfo.Username;
lawInfo.CreateTime = DateTime.Now;
lawInfo.EditTime = DateTime.Now;
if (NetSchool.BLL.Law.Add(lawInfo))
{
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
strreturn = JsonConvert.SerializeObject(new { state = "error", msg = "插入失败" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
return(strreturn);
}
public static bool Add(Model.Law model)
{
return(dal.Add(model));
}
public static bool Update(Model.Law model)
{
return(dal.Update(model));
}
public bool Update(Model.Law model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(updatesql, GetModelPare(model)) > 0);
}
public bool Add(Model.Law model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(insertsql, GetModelPare(model)) > 0);
}
public static SqlParameter[] GetModelPare(Model.Law model)
{
SqlParameter[] parameters =
{
new SqlParameter("@LawID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Content", SqlDbType.NText),
new SqlParameter("@Type", SqlDbType.Int, 10),
new SqlParameter("@Author", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ViewNum", SqlDbType.Int),
new SqlParameter("@Editor", SqlDbType.NVarChar),
new SqlParameter("@EditTime", SqlDbType.DateTime),
new SqlParameter("@Attachment", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.LawID;
if (string.IsNullOrWhiteSpace(model.Title))
{
parameters[1].Value = DBNull.Value;
}
else
{
parameters[1].Value = model.Title;
}
if (string.IsNullOrWhiteSpace(model.Content))
{
parameters[2].Value = DBNull.Value;
}
else
{
parameters[2].Value = model.Content;
}
parameters[3].Value = model.Type;
if (string.IsNullOrWhiteSpace(model.Author))
{
parameters[4].Value = DBNull.Value;
}
else
{
parameters[4].Value = model.Author;
}
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.ViewNum;
if (string.IsNullOrWhiteSpace(model.Editor))
{
parameters[7].Value = DBNull.Value;
}
else
{
parameters[7].Value = model.Editor;
}
parameters[8].Value = model.EditTime;
if (string.IsNullOrWhiteSpace(model.Attachment))
{
parameters[9].Value = DBNull.Value;
}
else
{
parameters[9].Value = model.Attachment;
}
return(parameters);
}
