public Response updateCompany(string token, [FromBody] Aden.Model.Common.Company lines)
{
Response response = new Response();
if (string.IsNullOrEmpty(token) || !token.Equals(_token))
{
response.code = "404";
response.message = "Invalid token";
}
else
{
int intExCount = 0;
intExCount = CompanyHelper.updateCompany(lines);
if (intExCount == 0)
{
response.code = "500";
response.message = "process failed";
}
else
{
response.code = "200";
}
}
return(response);
}
/// <summary>
/// updateCompany by Angel Jiang
/// </summary>
/// <returns></returns>
public int updateCompany(Aden.Model.Common.Company lines)
{
string sql = "update company set interBranchOP='{0}',interBranchOR='{1}',interCompanyOP='{2}',interCompanyOR='{3}', "
+ "companyGroup='{4}',supplierCode='{5}', "
+ "customCode='{6}' where Company='{7}' and status=1";
StringBuilder sbSqlFinal = new StringBuilder();
StringBuilder sbSqlwork = new StringBuilder();
foreach (Company item in lines.lines)
{
sbSqlwork = new StringBuilder();
sbSqlwork.AppendFormat(sql, item.interBranchOP, item.interBranchOR, item.interCompanyOP, item.interCompanyOR,
item.companyGroup, item.supplierCode, item.customerCode, item.companyCode);
sbSqlFinal.Append(sbSqlwork.ToString());
}
return(SqlServerHelper.Execute(SqlServerHelper.salesorderConn(), sbSqlFinal.ToString()));
}
/// <summary>
/// updateCompany by Angel Jiang
/// </summary>
/// <param name="lines"></param>
/// <returns></returns>
public static int updateCompany(Aden.Model.Common.Company lines)
{
int intExCount = 0;
try
{
if (lines == null)
{
throw new Exception("updateCompany is null");
}
intExCount = factory.updateCompany(lines);
}
catch (Exception ex)
{
LogHelper.WriteLog(new Log()
{
message = ex.Message
}, "updateCompany");
}
return(intExCount);
}
