public async Task <bool> UpdateGeneralBeautyServerCodeTmpAsync(ThirdPartyBeautyPackageConfigModel model)
{
#region SQL
string sql = @"
Update [Tuhu_groupon].[dbo].[ThirdPartyBeautyPackageConfig] WITH(ROWLOCK)
SET
[IsActive]=@IsActive
,CooperateId=@CooperateId
,[UpdatedDateTime]=GetDate()
,[PackageName]=@PackageName
,[AppId]=@AppId
,[Description]=@Description
WHERE PackageId=@PackageId";
#endregion
using (var conn = new SqlConnection(strConn_Write))
{
var sqlPara = new[]
{
new SqlParameter("PackageId", model.PackageId),
new SqlParameter("IsActive", model.IsActive),
new SqlParameter("PackageName", model.PackageName),
new SqlParameter("AppId", model.AppId),
new SqlParameter("Description", model.Description),
new SqlParameter("CooperateId", model.CooperateId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPara) > 0);
}
}
/// <summary>
/// 保存通用服务码配置模板
/// </summary>
/// <returns></returns>
public async Task <JsonResult> SaveGeneralBeautyServerCodeTmp(ThirdPartyBeautyPackageConfigModel model)
{
bool result = false;
if (model == null)
{
return(Json(new { Result = result }));
}
model.CreatedUser = User.Identity.Name;
result = await GeneralBeautyServerCodeManager.Instanse.SaveGeneralBeautyServerCodeTmpAsync(model);
return(Json(new { Result = result }));
}
/// <summary>
/// 获取美容通用服务码模板详情
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="appId"></param>
/// <param name="settlementMethod"></param>
/// <param name="count"></param>
/// <returns></returns>
public ThirdPartyBeautyPackageConfigModel GetGeneralBeautyServerCodeTmpDetail(Guid packageId)
{
ThirdPartyBeautyPackageConfigModel result = null;
try
{
result = _DalGeneralBeautyServerCode.GetGeneralBeautyServerCodeTmpDetail(packageId);
}
catch (Exception ex)
{
_logger.Error(ex.Message, ex);
}
return(result);
}
public ThirdPartyBeautyPackageConfigModel GetGeneralBeautyServerCodeTmpDetail(Guid packageId)
{
#region SQL
string sql = @"SELECT [PKID]
,[PackageId]
,[IsActive]
,[CreatedUser]
,[CreatedDateTime]
,[UpdatedDateTime]
,[CooperateId]
,[PackageName]
,[Description]
,[SettlementMethod]
,[AppId]
FROM [Tuhu_groupon].[dbo].[ThirdPartyBeautyPackageConfig] WITH(NOLOCK)
WHERE PackageId=@PackageId";
#endregion
ThirdPartyBeautyPackageConfigModel result = null;
using (var conn = new SqlConnection(strConn_OnlyRead))
{
var sqlPara = new[]
{
new SqlParameter("PackageId", packageId)
};
var row = SqlHelper.ExecuteDataRow(conn, CommandType.Text, sql, sqlPara);
if (row != null)
{
result = new ThirdPartyBeautyPackageConfigModel
{
PKID = row.GetValue <Int32>("PKID"),
AppId = row.GetValue <String>("AppId"),
PackageName = row.GetValue <String>("PackageName"),
PackageId = row.GetValue <Guid>("PackageId"),
IsActive = row.GetValue <Boolean>("IsActive"),
CreatedUser = row.GetValue <String>("CreatedUser"),
CreatedDateTime = row.GetValue <DateTime>("CreatedDateTime"),
UpdatedDateTime = row.GetValue <DateTime>("UpdatedDateTime"),
CooperateId = row.GetValue <Int32>("CooperateId"),
Description = row.GetValue <String>("Description"),
SettlementMethod = row.GetValue <String>("SettlementMethod"),
}
}
;
}
return(result);
}
public async Task <bool> SaveGeneralBeautyServerCodeTmpAsync(ThirdPartyBeautyPackageConfigModel model)
{
#region SQL
string sql = @"
Insert Into [Tuhu_groupon].[dbo].[ThirdPartyBeautyPackageConfig]
([PackageId]
,[IsActive]
,[IsDeleted]
,[CreatedUser]
,[CreatedDateTime]
,[UpdatedDateTime]
,[CooperateId]
,[PackageName]
,[AppId]
,[Description]
,[SettlementMethod])
values
(@PackageId
,@IsActive
,0
,@CreatedUser
,GetDate()
,GetDate()
,@CooperateId
,@PackageName
,@AppId
,@Description
,@SettlementMethod
)";
#endregion
using (var conn = new SqlConnection(strConn_Write))
{
var sqlPara = new[]
{
new SqlParameter("PackageId", model.PackageId),
new SqlParameter("IsActive", model.IsActive),
new SqlParameter("CreatedUser", model.CreatedUser),
new SqlParameter("CooperateId", model.CooperateId),
new SqlParameter("PackageName", model.PackageName),
new SqlParameter("Description", model.Description),
new SqlParameter("AppId", model.AppId),
new SqlParameter("SettlementMethod", model.SettlementMethod)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPara) > 0);
}
}
/// <summary>
/// 保存美容通用服务码模板
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <bool> SaveGeneralBeautyServerCodeTmpAsync(ThirdPartyBeautyPackageConfigModel model)
{
var result = false;
try
{
if (model.PKID > 0)
{
result = await _DalGeneralBeautyServerCode.UpdateGeneralBeautyServerCodeTmpAsync(model);
}
else
{
model.PackageId = Guid.NewGuid();
result = await _DalGeneralBeautyServerCode.SaveGeneralBeautyServerCodeTmpAsync(model);
}
}
catch (Exception ex)
{
_logger.Error(ex.Message, ex);
}
return(result);
}
