public int AddMD_BulkShipTo(MD_BulkShipTo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SIDE_MD_BulkShipTo(BRANCH_EN,BRANCH_CN,BLR,Province,City,StoreFormat,WHS_Channel,Bulk_Ship_to_Code_Core,Bulk_Ship_to_Code_Originals,Bulk_Ship_to_Code_Neo,Bulk_Ship_to_Code_Kids )");
strSql.Append(" values (@BRANCH_EN,@BRANCH_CN,@BLR,@Province,@City,@StoreFormat,@WHS_Channel,@Bulk_Ship_to_Code_Core,@Bulk_Ship_to_Code_Originals,@Bulk_Ship_to_Code_Neo,@Bulk_Ship_to_Code_Kids )");
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@BRANCH_EN", model.BRANCH_EN, DbType.String, ParameterDirection.Input);
parameters.Add("@BRANCH_CN", model.BRANCH_CN, DbType.String, ParameterDirection.Input);
parameters.Add("@WHS_Channel", model.WHS_Channel, DbType.String, ParameterDirection.Input);
parameters.Add("@BLR", model.BLR, DbType.String, ParameterDirection.Input);
parameters.Add("@City", model.City, DbType.String, ParameterDirection.Input);
parameters.Add("@Province", model.Province, DbType.String, ParameterDirection.Input);
parameters.Add("@StoreFormat", model.StoreFormat, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Core", model.Bulk_Ship_to_Code_Core, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Originals", model.Bulk_Ship_to_Code_Originals, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Neo", model.Bulk_Ship_to_Code_Neo, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Kids", model.Bulk_Ship_to_Code_Kids, DbType.String, ParameterDirection.Input);
using (IDbConnection conn = DataBaseConfig.GetSqlConnection())
{
return(conn.Execute(strSql.ToString(), parameters));
}
}
public int UpdateMD_BulkShipTo(MD_BulkShipTo model)
{
string updateSql = @"update SIDE_MD_BulkShipTo set BRANCH_EN=@BRANCH_EN,City=@City, BRANCH_CN=@BRANCH_CN,BLR=@BLR,Province=@Province,StoreFormat=@StoreFormat, WHS_Channel=@WHS_Channel, Bulk_Ship_to_Code_Core=@Bulk_Ship_to_Code_Core, Bulk_Ship_to_Code_Originals=@Bulk_Ship_to_Code_Originals, Bulk_Ship_to_Code_Neo=@Bulk_Ship_to_Code_Neo, Bulk_Ship_to_Code_Kids=@Bulk_Ship_to_Code_Kids WHERE ID=@ID";
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@ID", model.ID, DbType.Int32, ParameterDirection.Input);
parameters.Add("@BRANCH_EN", model.BRANCH_EN, DbType.String, ParameterDirection.Input);
parameters.Add("@BRANCH_CN", model.BRANCH_CN, DbType.String, ParameterDirection.Input);
parameters.Add("@WHS_Channel", model.WHS_Channel, DbType.String, ParameterDirection.Input);
parameters.Add("@BLR", model.BLR, DbType.String, ParameterDirection.Input);
parameters.Add("@City", model.City, DbType.String, ParameterDirection.Input);
parameters.Add("@Province", model.Province, DbType.String, ParameterDirection.Input);
parameters.Add("@StoreFormat", model.StoreFormat, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Core", model.Bulk_Ship_to_Code_Core, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Originals", model.Bulk_Ship_to_Code_Originals, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Neo", model.Bulk_Ship_to_Code_Neo, DbType.String, ParameterDirection.Input);
parameters.Add("@Bulk_Ship_to_Code_Kids", model.Bulk_Ship_to_Code_Kids, DbType.String, ParameterDirection.Input);
using (IDbConnection conn = DataBaseConfig.GetSqlConnection())
{
return(conn.Execute(updateSql, parameters));
}
}
public OkObjectResult EditMD_BulkShipTo(MD_BulkShipTo entity)
{
ResultModel result = new ResultModel();
try
{
result.IsSuccess = false;
int Total = 0;
//获取customerInfo
#region 验证 ship to Code 的输入是否正确
if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Core))
{
entity.Bulk_Ship_to_Code_Core = entity.Bulk_Ship_to_Code_Core.ToUpper();
if (entity.Bulk_Ship_to_Code_Core != "TBD")
{
string[] codelist = entity.Bulk_Ship_to_Code_Core.Split('/');
foreach (string Code in codelist)
{
string Productchannel = PosRepository.GetProductchannel(Code);
if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToString().ToLower() != "core")
{
result.Message = "Bulk Ship to Code(Core) is Error!";
return(Ok(result));
}
}
}
}
if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Originals))
{
entity.Bulk_Ship_to_Code_Originals = entity.Bulk_Ship_to_Code_Originals.ToUpper();
if (entity.Bulk_Ship_to_Code_Originals != "TBD")
{
string[] codelist = entity.Bulk_Ship_to_Code_Originals.Split('/');
foreach (string Code in codelist)
{
string Productchannel = PosRepository.GetProductchannel(Code);
if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "originals")
{
result.Message = "Bulk Ship to Code(Originals) is Error!";
return(Ok(result));
}
}
}
}
if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Neo))
{
entity.Bulk_Ship_to_Code_Neo = entity.Bulk_Ship_to_Code_Neo.ToUpper();
if (entity.Bulk_Ship_to_Code_Neo != "TBD")
{
string[] codelist = entity.Bulk_Ship_to_Code_Neo.Split('/');
foreach (string Code in codelist)
{
string Productchannel = PosRepository.GetProductchannel(Code);
if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "neo")
{
result.Message = "Bulk Ship to Code(Neo) is Error!";
return(Ok(result));
}
}
}
}
if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Kids))
{
entity.Bulk_Ship_to_Code_Kids = entity.Bulk_Ship_to_Code_Kids.ToUpper();
if (entity.Bulk_Ship_to_Code_Kids != "TBD")
{
string[] codelist = entity.Bulk_Ship_to_Code_Kids.Split('/');
foreach (string Code in codelist)
{
string Productchannel = PosRepository.GetProductchannel(Code);
if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "kids")
{
result.Message = "Bulk Ship to Code(Kids) is Error!";
return(Ok(result));
}
}
}
}
#endregion
//string sqlstr = "select count(ID) from SIDE_MD_BulkShipTo where BRANCH_CN=@BRANCH_CN and BRANCH_EN=@BRANCH_EN and WHS_Channel=@WHS_Channel ";
//if (entity.ID > 0)
//{
// sqlstr = sqlstr + " and ID<>@ID ";
//}
//DynamicParameters parameters = new DynamicParameters();
//parameters.Add("@ID", entity.ID, DbType.Int32, ParameterDirection.Input);
//parameters.Add("@BRANCH_CN", entity.BRANCH_CN, DbType.String, ParameterDirection.Input);
//parameters.Add("@BRANCH_EN", entity.BRANCH_EN, DbType.String, ParameterDirection.Input);
//parameters.Add("@WHS_Channel", entity.WHS_Channel, DbType.String, ParameterDirection.Input);
//using (IDbConnection conn = DataBaseConfig.GetSqlConnection())
//{
// Total = (Int32)conn.ExecuteScalar(sqlstr, parameters);
//}
if (Total > 0)
{
result.IsSuccess = false;
result.Message = "Already exist";
result.StatusCode = "-4";
}
else
{
if (entity.ID == 0)
{
int row = masterdataRepository.AddMD_BulkShipTo(entity);
result.StatusCode = row.ToString();
result.Message = "OK";
result.IsSuccess = true;
}
else
{
int row = masterdataRepository.UpdateMD_BulkShipTo(entity);
result.StatusCode = row.ToString();
result.Message = "OK";
result.IsSuccess = true;
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.IsSuccess = false;
}
return(Ok(result));
}
