private static string AddCompany()
{
string strreturn;
string strCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("company");
string strTerritory = NetSchool.Common.Library.GetPostBack.GetPostBackStr("territory");
NetSchool.Model.EduCompany eduCompanyInfo = new Model.EduCompany();
eduCompanyInfo.Id = Guid.NewGuid();
eduCompanyInfo.Company = strCompany;
eduCompanyInfo.Territory = strTerritory;
eduCompanyInfo.CreateTime = DateTime.Now;
eduCompanyInfo.CreatedTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
if (NetSchool.BLL.EduCompany.Add(eduCompanyInfo))
{
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 SqlParameter[] GetModelPare(Model.EduCompany model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Company", SqlDbType.NVarChar),
new SqlParameter("@Territory", SqlDbType.NVarChar),
new SqlParameter("@CreatedTime", SqlDbType.Int, 10),
new SqlParameter("@CreateTime", SqlDbType.Date)
};
parameters[0].Value = model.Id;
if (string.IsNullOrWhiteSpace(model.Company))
{
parameters[1].Value = DBNull.Value;
}
else
{
parameters[1].Value = model.Company;
}
if (string.IsNullOrWhiteSpace(model.Territory))
{
parameters[2].Value = DBNull.Value;
}
else
{
parameters[2].Value = model.Territory;
}
parameters[3].Value = model.CreatedTime;
parameters[4].Value = model.CreateTime;
return(parameters);
}
public static bool Add(Model.EduCompany model)
{
return(dal.Add(model));
}
public static bool Update(Model.EduCompany model)
{
return(dal.Update(model));
}
public bool Update(Model.EduCompany model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(updatesql, GetModelPare(model)) > 0);
}
public bool Add(Model.EduCompany model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(insertsql, GetModelPare(model)) > 0);
}
