public bool UpdateServiceEval(ServiceEvalInfo model)
{
DbParameter[] parms =
{
GenerateInParam("@Name", SqlDbType.NVarChar, 50, model.Name),
GenerateInParam("@Contact", SqlDbType.NVarChar, 50, model.Contact),
GenerateInParam("@Province", SqlDbType.NVarChar, 50, model.Province),
GenerateInParam("@City", SqlDbType.NVarChar, 50, model.City),
GenerateInParam("@Courier", SqlDbType.NVarChar, 250, model.Courier),
GenerateInParam("@EvalProduct", SqlDbType.Int, 4, model.EvalProduct),
GenerateInParam("@EvalLogistics", SqlDbType.Int, 4, model.EvalLogistics),
GenerateInParam("@EvalService", SqlDbType.Int, 4, model.EvalService),
GenerateInParam("@Body", SqlDbType.NText, 0, model.Body),
GenerateInParam("@CreateTime", SqlDbType.DateTime, 8, model.CreateTime),
GenerateInParam("@State", SqlDbType.Int, 4, model.State),
GenerateInParam("@WeChatName", SqlDbType.NVarChar, 250, model.WeChatName),
GenerateInParam("@WeChatOpenId", SqlDbType.NVarChar, 50, model.WeChatOpenId),
GenerateInParam("@id", SqlDbType.Int, 4, model.Id)
};
string commandText = string.Format("update {0}ServiceEval set Name=@Name,Contact=@Contact,Province=@Province,Courier=@Courier,City=@City,EvalProduct=@EvalProduct,EvalLogistics=@EvalLogistics,EvalService=@EvalService,Body=@Body,CreateTime=@CreateTime,State=@State,WeChatName=@WeChatName,weChatOpenId=@weChatOpenId where id=@id ",
RDBSHelper.RDBSTablePre);
if (RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得服务评价
/// </summary>
/// <param name="newsId">新闻id</param>
/// <returns></returns>
public static ServiceEvalInfo GetModelById(int id)
{
ServiceEvalInfo model = null;
IDataReader reader = BonSite.Core.BSData.RDBS.GetServiceEvalInfoById(id);
if (reader.Read())
{
model = BuildFromReader(reader);
}
reader.Close();
return(model);
}
public int CreateServiceEval(ServiceEvalInfo model)
{
DbParameter[] parms =
{
GenerateInParam("@Name", SqlDbType.NVarChar, 50, model.Name),
GenerateInParam("@Contact", SqlDbType.NVarChar, 50, model.Contact),
GenerateInParam("@Province", SqlDbType.NVarChar, 50, model.Province),
GenerateInParam("@City", SqlDbType.NVarChar, 50, model.City),
GenerateInParam("@Courier", SqlDbType.NVarChar, 250, model.Courier),
GenerateInParam("@EvalProduct", SqlDbType.Int, 4, model.EvalProduct),
GenerateInParam("@EvalLogistics", SqlDbType.Int, 4, model.EvalLogistics),
GenerateInParam("@EvalService", SqlDbType.Int, 4, model.EvalService),
GenerateInParam("@Body", SqlDbType.NText, 0, model.Body),
GenerateInParam("@CreateTime", SqlDbType.DateTime, 8, model.CreateTime),
GenerateInParam("@State", SqlDbType.Int, 4, model.State),
GenerateInParam("@WeChatName", SqlDbType.NVarChar, 250, model.WeChatName),
GenerateInParam("@WeChatOpenId", SqlDbType.NVarChar, 50, model.WeChatOpenId)
};
string commandText = string.Format("insert into {0}ServiceEval(Name,Contact,Province,City,Courier,EvalProduct,EvalLogistics,EvalService,Body,CreateTime,State,WeChatName,weChatOpenId) values (@Name,@Contact,@Province,@City,@Courier,@EvalProduct,@EvalLogistics,@EvalService,@Body,@CreateTime,@State,@WeChatName,@weChatOpenId) ;select @@IDENTITY;", RDBSHelper.RDBSTablePre);
return(TypeHelper.ObjectToInt(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms), -1));
}
/// <summary>
/// 通过IDataReader创建ProductFeedbacksInfo
/// </summary>
public static ServiceEvalInfo BuildFromReader(IDataReader reader)
{
ServiceEvalInfo model = new ServiceEvalInfo();
model.Id = TypeHelper.ObjectToInt(reader["Id"]);
if (reader["Name"] != null)
{
model.Name = reader["Name"].ToString();
}
else
{
model.Name = "";
}
if (reader["Contact"] != null)
{
model.Contact = reader["Contact"].ToString();
}
else
{
model.Contact = "";
}
if (reader["Province"] != null)
{
model.Province = reader["Province"].ToString();
}
else
{
model.Province = "";
}
if (reader["City"] != null)
{
model.City = reader["City"].ToString();
}
else
{
model.City = "";
}
if (reader["Courier"] != null)
{
model.Courier = reader["Courier"].ToString();
}
else
{
model.Courier = "";
}
model.EvalProduct = TypeHelper.ObjectToInt(reader["EvalProduct"]);
model.EvalLogistics = TypeHelper.ObjectToInt(reader["EvalLogistics"]);
model.EvalService = TypeHelper.ObjectToInt(reader["EvalService"]);
model.CreateTime = TypeHelper.ObjectToDateTime(reader["CreateTime"]);
if (reader["Body"] != null)
{
model.Body = reader["Body"].ToString();
}
else
{
model.Body = "";
}
model.State = TypeHelper.ObjectToInt(reader["State"]);
if (reader["WeChatName"] != null)
{
model.WeChatName = reader["WeChatName"].ToString();
}
else
{
model.WeChatName = "";
}
if (reader["WeChatOpenId"] != null)
{
model.WeChatOpenId = reader["WeChatOpenId"].ToString();
}
else
{
model.WeChatOpenId = "";
}
return(model);
}
/// <summary>
/// 更新服务评价
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(ServiceEvalInfo model)
{
return(BonSite.Core.BSData.RDBS.UpdateServiceEval(model));
}
/// <summary>
/// 创建服务评价
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Create(ServiceEvalInfo model)
{
return(BonSite.Core.BSData.RDBS.CreateServiceEval(model));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(ServiceEvalInfo model)
{
return(BonSite.Data.ServiceEval.Update(model));
}
/// <summary>
/// 新加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Create(ServiceEvalInfo model)
{
return(BonSite.Data.ServiceEval.Create(model));
}
