protected SalesorderTypeStatusInfoModel GetSalesOrderTypeStatusModelByIdFromDatabase(string usalsorder_status_id)
{
SalesorderTypeStatusInfoModel model = null;
string sql = @"
SELECT [salsorder_status_id]
,[salesorder_type_id]
,[payment_type]
,[salesorder_status_name]
,[status]
,[description]
,[sort_order]
,[created_by]
,[created_on]
,[modified_on]
,[modified_by]
,[status_code]
FROM salesorder_type_status_info WHERE salsorder_status_id = $salsorder_status_id$ ";
ParameterCollection pc = new ParameterCollection();
pc.Add("salsorder_status_id", usalsorder_status_id);
DataTable dt = ExecuteDataTable(sql, pc);
if (dt != null && dt.Rows.Count > 0)
{
model = new SalesorderTypeStatusInfoModel();
ModelConvertFrom(model, dt, 0);
}
return(model);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel();
ret = DbUtil.Current.DeleteMultiple(salesordertypestatusinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="salesordertypestatusinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(SalesorderTypeStatusInfoModel salesordertypestatusinfo, ParameterCollection pc)
{
int ret = 0;
salesordertypestatusinfo.ModifiedBy = SessionUtil.Current.UserId;
salesordertypestatusinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(salesordertypestatusinfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="salesordertypestatusinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(SalesorderTypeStatusInfoModel salesordertypestatusinfo)
{
int ret = 0;
salesordertypestatusinfo.ModifiedBy = SessionUtil.Current.UserId;
salesordertypestatusinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(salesordertypestatusinfo);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="salsorderstatusid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string salsorderstatusid)
{
int ret = 0;
SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel();
salesordertypestatusinfo.SalsorderStatusId = salsorderstatusid;
ret = DbUtil.Current.Delete(salesordertypestatusinfo);
return(ret);
}
/// <summary>
/// 编辑类型状态操作。
/// </summary>
/// <param name="statusInfo"></param>
/// <returns></returns>
public bool EditSalesOrderTypeStatusInfo(SalesorderTypeStatusInfoModel model)
{
bool result = false;
if (SalesorderTypeStatusInfoService.Instance.Update(model) > 0)
{
result = true;
GetSalesOrderTypeStatusModelById(model.SalsorderStatusId, true);
}
return(result);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <SalesorderTypeStatusInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <SalesorderTypeStatusInfoModel> salesordertypestatusinfos = new List <SalesorderTypeStatusInfoModel>();
SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(salesordertypestatusinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
salesordertypestatusinfo = new SalesorderTypeStatusInfoModel();
salesordertypestatusinfo.ConvertFrom(dt, i);
salesordertypestatusinfos.Add(salesordertypestatusinfo);
}
return(salesordertypestatusinfos);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="salsorderstatusid"></param>
/// <returns>实体</returns>
public SalesorderTypeStatusInfoModel Retrieve(string salsorderstatusid)
{
SalesorderTypeStatusInfoModel salesordertypestatusinfo = new SalesorderTypeStatusInfoModel();
salesordertypestatusinfo.SalsorderStatusId = salsorderstatusid;
DataTable dt = DbUtil.Current.Retrieve(salesordertypestatusinfo);
if (dt.Rows.Count < 1)
{
return(null);
}
salesordertypestatusinfo.ConvertFrom(dt);
return(salesordertypestatusinfo);
}
/// <summary>
/// 新建订单类型状态值。
/// </summary>
/// <param name="statusInfo"></param>
/// <returns></returns>
public bool CreateSalesOrderTypeStatusInfo(SalesorderTypeStatusInfoModel model, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
if (CheckExistSalesorderStatusName(model.SalesorderStatusName))
{
message = string.Format("操作失败，已经存在名为【{0}】状态名称", model.SalesorderStatusName);
return(false);
}
if (SalesorderTypeStatusInfoService.Instance.Create(model) > 0)
{
message = "添加成功";
result = true;
GetSalesOrderTypeStatusModelById(model.SalsorderStatusId, true);
}
return(result);
}
/// <summary>
/// 根据ID获取用户领域模型。
/// </summary>
/// <param name="userId"></param>
/// <param name="clear"></param>
/// <returns></returns>
public SalesOrderTypeStatusDomainModel GetSalesOrderTypeStatusModelById(string salsorder_status_id, bool clear)
{
if (string.IsNullOrEmpty(salsorder_status_id))
{
return(null);
}
string cacheKey = CacheKey.GetKeyDefine(CacheKey.SALESORDER_TYPE_STATUS_INFO, salsorder_status_id);
SalesOrderTypeStatusDomainModel result = CacheUtil.Get <SalesOrderTypeStatusDomainModel>(cacheKey);
if (result == null || clear)
{
SalesorderTypeStatusInfoModel basicInfo = GetSalesOrderTypeStatusModelByIdFromDatabase(salsorder_status_id);
if (basicInfo != null)
{
result = new SalesOrderTypeStatusDomainModel();
result.BasicInfo = basicInfo;
CacheUtil.Set(cacheKey, result);
}
}
return(result);
}
