/// <summary>
/// 向三方订单渠道链接表添加渠道链接
/// </summary>
/// <param name="linkmodel"></param>
/// <returns></returns>
public static bool AddThirdPartyOrderChannellink(ThirdPartyOrderChannellinkModel linkmodel)
{
try
{
return(DataAccess.DAO.DALThirdPartyOrderChannelLink.AddThirdPartyOrderChannellink(linkmodel));
}
catch (Exception ex)
{
Logger.Error("AddThirdPartyOrderChannellink", ex);
throw ex;
}
}
/// <summary>
/// 向三方订单渠道链接表添加渠道链接
/// </summary>
/// <param name="linkmodel"></param>
/// <returns></returns>
public static bool AddThirdPartyOrderChannellink(ThirdPartyOrderChannellinkModel linkmodel)
{
bool isSuccess = true;
var result = 0;
string source = string.Empty;
string conn = ConnectionHelper.GetDecryptConn("ThirdParty");
using (var db = new SqlDbHelper(conn))
{
db.BeginTransaction();
string Sql = @"INSERT INTO Tuhu_thirdparty.[dbo].[tbl_ThirdPartyOrderChannellink]
( [OrderChanneID]
,[OrderChannelEngName]
,[BusinessType]
,[Status]
,[InitialPagelink]
,[FinalPagelink]
,[IsAggregatePage]
,[IsAuthorizedLogin]
,[IsPartnerReceivSilver]
,[IsOrderBack]
,[IsViewOrders]
,[IsViewCoupons]
,[IsContactUserService]
,[IsBackTop]
,[CreateBy]
,[LastUpdateBy]
,[CreateDatetime]
,[LastUpdateDateTime]
)
VALUES ( @OrderChanneID ,
@OrderChannelEngName,
@BusinessType ,
@Status ,
@InitialPagelink ,
@FinalPagelink ,
@IsAggregatePage ,
@IsAuthorizedLogin ,
@IsPartnerReceivSilver ,
@IsOrderBack ,
@IsViewOrders ,
@IsViewCoupons ,
@IsContactUserService ,
@IsBackTop ,
@CreateBy ,
@LastUpdateBy ,
GETDATE() ,
GETDATE()
)
SELECT SCOPE_IDENTITY();";
var parameters = new[]
{
new SqlParameter("@OrderChanneID", linkmodel.OrderChanneID),
new SqlParameter("@OrderChannelEngName", linkmodel.OrderChannelEngName),
new SqlParameter("@BusinessType", linkmodel.BusinessType),
new SqlParameter("@Status", 1),
new SqlParameter("@InitialPagelink", linkmodel.InitialPagelink),
new SqlParameter("@FinalPagelink", linkmodel.FinalPagelink),
new SqlParameter("@IsAggregatePage", linkmodel.IsAggregatePage),
new SqlParameter("@IsAuthorizedLogin", linkmodel.IsAuthorizedLogin),
new SqlParameter("@IsPartnerReceivSilver", linkmodel.IsPartnerReceivSilver),
new SqlParameter("@IsOrderBack", linkmodel.IsOrderBack),
new SqlParameter("@IsViewOrders", linkmodel.IsViewOrders),
new SqlParameter("@IsViewCoupons", linkmodel.IsViewCoupons),
new SqlParameter("@IsContactUserService", linkmodel.IsContactUserService),
new SqlParameter("@IsBackTop", linkmodel.IsBackTop),
new SqlParameter("@CreateBy", linkmodel.CreateBy),
new SqlParameter("@LastUpdateBy", linkmodel.LastUpdateBy)
};
result = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, Sql, parameters));
if (result < 0)
{
db.Rollback();
isSuccess = false;
}
else
{
db.Commit();
}
return(isSuccess);
}
}
