//刪除沒有商品佔據的主料位
public HttpResponseBase DeleteIplasById()
{
string jsonStr = String.Empty;
_IlocMgr = new IlocMgr(mySqlConnectionString);
_IiplasMgr = new IplasMgr(mySqlConnectionString);
Iloc loc = new Iloc();
IplasQuery plasQuery = new IplasQuery();
IinvdQuery nvdQery = new IinvdQuery();
try
{
string str = Request.Params["loc_id"].ToString().ToUpper();//獲取類型
str = str.Substring(0, str.LastIndexOf(","));
int sum = 0;
string[] strs = str.Split(',');
for (int i = 0; i < strs.Length; i++)
{
nvdQery.loc_id = strs[i];
sum = sum + _IiplasMgr.GetIinvdItemId(nvdQery);
}
if (sum > 0)
{
jsonStr = "{success:true,sum:" + sum + "}";//大於0表示算選包含庫存量
}
else
{
int counts = 0;
for (int i = 0; i < strs.Length; i++)
{
plasQuery.loc_id = strs[i];
counts = counts + _IiplasMgr.DeleteIplasById(plasQuery);
}
if (counts > 0)
{
jsonStr = "{success:true,count:" + counts + "}";
}
else
{
jsonStr = "{success:false}";
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}