//RF直接庫調
public HttpResponseBase RFKT()
{
string json = string.Empty;
IialgQuery q = new IialgQuery();
uint id = 0; DateTime dt = new DateTime(); int sun = 0;
try
{
if (uint.TryParse(Request.Params["item_id"].ToString(), out id))
{//商品id
q.item_id = id;
}
if (DateTime.TryParse(Request.Params["made_date"].ToString(), out dt))
{//商品製造日期
q.made_dt = dt;
}
if (int.TryParse(Request.Params["prod_qty"].ToString(), out sun))
{//商品原有數量
q.qty_o = sun;
}
if (int.TryParse(Request.Params["pnum"].ToString(), out sun))
{//商品撿貨數量
q.pnum = sun;
}
if (!string.IsNullOrEmpty(Request.Params["loc_id"].ToString()))
{//商品撿貨數量
q.loc_id = Request.Params["loc_id"];
}
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
q.order_id = Request.Params["order_id"];
}
q.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
//進行庫調
_iagMgr = new IialgMgr(mySqlConnectionString);
if (q.loc_id == "YY999999")
{
json = "{success:false}";
}
else
{
int result = _iagMgr.addIialgIstock(q);
if (result == 2)
{
json = "{success:true,msg:2}";
}
if (result == 100)
{
json = "{success:true,msg:100}";
}
}
}
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase aboutmadetime()
{
string jsonStr = string.Empty;
int result = 0;
DataTable dt = new DataTable();
try
{
int userId = (Session["caller"] as Caller).user_id;
DateTime nowtimes = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
int type_id = 0;//類型
int days = 0;
int row_id = int.Parse(Request.Params["row_id"]);
string cde_dtormade_dt = Request.Params["cde_dtormade_dt"];
string y_cde_dtormade_dt = string.Empty;
if (!string.IsNullOrEmpty(Request.Params["y_cde_dtormade_dt"]))
{
y_cde_dtormade_dt = Request.Params["y_cde_dtormade_dt"];//原來的日期
}
if (!string.IsNullOrEmpty(Request.Params["type_id"]))
{
type_id = Convert.ToInt32(Request.Params["type_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["datetimeday"]))
{
days = Convert.ToInt32(Request.Params["datetimeday"]);
}
IinvdQuery invd = new IinvdQuery();
IinvdQuery newinvd = new IinvdQuery();
IialgQuery ialg = new IialgQuery();
newinvd.change_user = userId;
newinvd.change_dtim = DateTime.Now;
if (!string.IsNullOrEmpty(Request.Params["sloc_id"]))
{
invd.plas_loc_id = Convert.ToString(Request.Params["sloc_id"]).ToUpper();
ialg.loc_id = invd.plas_loc_id;
}
if (!string.IsNullOrEmpty(Request.Params["prod_id"]))
{
invd.item_id = Convert.ToUInt32(Request.Params["prod_id"]);
ialg.item_id = invd.item_id;
}
if (!string.IsNullOrEmpty(Request.Params["prod_qtys"]))
{
invd.prod_qty = Convert.ToInt32(Request.Params["prod_qtys"]);
ialg.qty_o = invd.prod_qty;
}
if (!string.IsNullOrEmpty(Request.Params["remarks"]))
{
invd.remarks = Request.Params["remarks"];
ialg.remarks = invd.remarks;
}
if (!string.IsNullOrEmpty(Request.Params["po_id"]))
{
ialg.po_id = Request.Params["po_id"];
}
if (!string.IsNullOrEmpty(Request.Params["iarc_id"]))
{
ialg.iarc_id = Request.Params["iarc_id"];
}
if (!string.IsNullOrEmpty(Request.Params["doc_no"]))
{
ialg.doc_no = Request.Params["doc_no"];
}
ialg.create_user = userId;
invd.change_user = userId;
ialg.create_dtim = DateTime.Now;
invd.change_dtim = DateTime.Now;
invd.row_id = row_id;
if (type_id == 1)//表示編輯的是製造日期
{
invd.made_date = DateTime.Parse(cde_dtormade_dt);
invd.cde_dt = invd.made_date.AddDays(days);//有效日期
if (invd.made_date > nowtimes)//已經過期
{
jsonStr = "{success:true,msg:1}";//1表示有效日期不能小於當前日期
}
else
{
_ipalet = new PalletMoveMgr(mySqlConnectionString);
_iialgMgr = new IialgMgr(mySqlConnectionString);
result = _ipalet.selectcount(invd);
#region 往iialg表中插入時間修改記錄
ialg.made_dt = DateTime.Parse(y_cde_dtormade_dt);//原來的日期
ialg.c_made_dt = DateTime.Parse(cde_dtormade_dt);//改后的日期
ialg.cde_dt = DateTime.Parse(y_cde_dtormade_dt).AddDays(days);//原來的有效日期
ialg.c_cde_dt = DateTime.Parse(cde_dtormade_dt).AddDays(days);//修改后的有效日期
ialg.adj_qty = 0;
if (string.IsNullOrEmpty(ialg.iarc_id))
{
ialg.iarc_id = "PC";
}
_iialgMgr.insertiialg(ialg);//往iialg中插入數據,用來記錄數據
#endregion
if (result > 0)//大於0表示裡面存在一樣子的值
{
dt = _ipalet.selectrow_id(invd);//獲取這個重複的row_id
newinvd.row_id = Convert.ToInt32(dt.Rows[0][0]);
newinvd.prod_qty = Convert.ToInt32(dt.Rows[0][1]) + invd.prod_qty;
if (_ipalet.UpdateordeleteIinvd(invd, newinvd) > 0)
{
jsonStr = "{success:true,msg:2}";//修改成功
}
else
{
jsonStr = "{success:false,msg:3}";//修改失敗
}
}
else
{
if (_ipalet.updatemadedate(invd) > 0)
{
jsonStr = "{success:true,msg:2}";//修改成功
}
else
{
jsonStr = "{success:false,msg:3}";//修改失敗
}
}
}
}
else if (type_id == 2)//表示有效日期
{
invd.cde_dt = DateTime.Parse(cde_dtormade_dt);
invd.made_date = invd.cde_dt.AddDays(days * (-1));
if (invd.made_date > nowtimes)
{
jsonStr = "{success:true,msg:1}";//1表示有效日期不能小於當前日期
}
else
{
_ipalet = new PalletMoveMgr(mySqlConnectionString);
_iialgMgr = new IialgMgr(mySqlConnectionString);
result = _ipalet.selectcount(invd);
#region 往iialg表中插入時間修改記錄
ialg.cde_dt = DateTime.Parse(y_cde_dtormade_dt);//原來的有效日期日期
ialg.c_cde_dt = DateTime.Parse(cde_dtormade_dt);//改后的有效日期日期
ialg.made_dt = DateTime.Parse(y_cde_dtormade_dt).AddDays(days * (-1));//原來的製造日期
ialg.c_made_dt = DateTime.Parse(cde_dtormade_dt).AddDays(days * (-1));//修改后製造日期
ialg.adj_qty = 0;
if (string.IsNullOrEmpty(ialg.iarc_id))
{
ialg.iarc_id = "PC";
}
_iialgMgr.insertiialg(ialg);//往iialg中插入數據,用來記錄數據
#endregion
if (result > 0)//大於0表示裡面存在一樣子的值
{
dt = _ipalet.selectrow_id(invd);//獲取這個重複的row_id
newinvd.row_id = Convert.ToInt32(dt.Rows[0][0]);
newinvd.prod_qty = Convert.ToInt32(dt.Rows[0][1]) + invd.prod_qty;
if (_ipalet.UpdateordeleteIinvd(invd, newinvd) > 0)
{
jsonStr = "{success:true,msg:2}";//修改成功
}
else
{
jsonStr = "{success:false,msg:3}";//修改失敗
}
}
else
{
if (_ipalet.updatemadedate(invd) > 0)
{
jsonStr = "{success:true,msg:2}";//修改成功
}
else
{
jsonStr = "{success:false,msg:3}";//修改失敗
}
}
}
}
}
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.ToString());
this.Response.End();
return this.Response;
}
// 庫調匯出
public void IialgExcel()
{
string json = string.Empty;
IialgQuery q = new IialgQuery();
try
{
uint id;
if (uint.TryParse(Request.Params["item_id"], out id))//獲取參數
{
q.item_id = id;
}
if (!string.IsNullOrEmpty(Request.Params["loc_id"]))
{
q.loc_id = Request.Params["loc_id"].ToString().ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["po_id"]))
{
q.po_id = Request.Params["po_id"].ToString();
}
//if (!string.IsNullOrEmpty(Request.Params["iarc_id"]))
//{
// q.iarc_id = Request.Params["iarc_id"].ToString();
//}
if (Request.Params["doc_userid"].ToString() != "-1")//by zhaozhi0623j add 20151006
{
q.doc_userid = int.Parse(Request.Params["doc_userid"]);
}
if (!string.IsNullOrEmpty(Request.Params["doc_no"].Trim().ToUpper()))//by zhaozhi0623j add 20151006
{
q.doc_no = Request.Params["doc_no"].Trim().ToUpper();
}
DateTime time = DateTime.MinValue;
if (DateTime.TryParse(Request.Params["starttime"].ToString(), out time))
{
q.starttime = time;
}
if (DateTime.TryParse(Request.Params["endtime"].ToString(), out time))
{
q.endtime = time;
}
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
DataTable dtHZ = new DataTable();
string newExcelName = string.Empty;
#region 表頭
dtHZ.Columns.Add("編號", typeof(String));
dtHZ.Columns.Add("庫存調整單號", typeof(String));
dtHZ.Columns.Add("主料位", typeof(String));
dtHZ.Columns.Add("調整料位", typeof(String));
dtHZ.Columns.Add("商品細項編號", typeof(String));
dtHZ.Columns.Add("商品名稱", typeof(String));
dtHZ.Columns.Add("商品規格", typeof(String));
dtHZ.Columns.Add("製造日期", typeof(String));
dtHZ.Columns.Add("有效日期", typeof(String));
dtHZ.Columns.Add("新製造日期", typeof(String));
dtHZ.Columns.Add("新有效日期", typeof(String));
dtHZ.Columns.Add("調整前數量", typeof(String));
dtHZ.Columns.Add("調整數量", typeof(String));
dtHZ.Columns.Add("調整后數量", typeof(String));
dtHZ.Columns.Add("調整原因", typeof(String));
dtHZ.Columns.Add("調整日期", typeof(String));
dtHZ.Columns.Add("調整人員", typeof(String));
dtHZ.Columns.Add("前置單號", typeof(String));
dtHZ.Columns.Add("備註欄", typeof(String));
#endregion
List<IialgQuery> store = new List<IialgQuery>();
_iagMgr = new IialgMgr(mySqlConnectionString);
q.IsPage = false;
store = _iagMgr.GetExportIialgList(q);
int i = 1;
foreach (var item in store)
{
DataRow dr = dtHZ.NewRow();
dr[0] = i++;
dr[1] = item.doc_no;
dr[2] = item.loc_id;
dr[3] = item.loc_R;
dr[4] = item.item_id;
dr[5] = item.product_name;
dr[6] = item.prod_sz;
dr[7] = item.made_dt;
dr[8] = item.cde_dt;
if (item.c_made_dt > DateTime.MinValue)
{
dr[9] = item.c_made_dt;
}
else
{
dr[9] = "";
}
if (item.c_cde_dt > DateTime.MinValue)
{
dr[10] = item.c_cde_dt;
}
else
{
dr[10] = "";
}
dr[11] = item.qty_o;
dr[12] = item.adj_qty;
dr[13] = item.qty_o + item.adj_qty;
dr[14] = item.iarc_id;
dr[15] = item.create_dtim;
dr[16] = item.name;
dr[17] = item.po_id;
dr[18] = item.remarks;
dtHZ.Rows.Add(dr);
}
if (System.IO.File.Exists(newExcelName))
{
System.IO.File.Delete(newExcelName);
}
string fileName = "庫存調整歷史記錄_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
string fileNametwo = "庫存調整歷史記錄_" + DateTime.Now.ToString("yyyyMMddHHmm");
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, fileNametwo);
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
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);
json = "{success:false,data:[]}";
}
}
public HttpResponseBase GetkutiaoUser() //by zhaozhi0623j add 庫調人員列表
{
string json = string.Empty;
try
{
_iagMgr = new IialgMgr(mySqlConnectionString);
List<ManageUser> store = new List<ManageUser>();
store = _iagMgr.GetkutiaoUser();
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
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);
json = "{success:false,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase InsertkucunMessage()
{
int j = 0;
string json = string.Empty;//json字符串
int iialgtotal = 0;
int iinvdtotal = 0;
try
{
if (Request.Files["ImportFileMsg"] != null && Request.Files["ImportFileMsg"].ContentLength > 0)//判斷文件是否為空
{
HttpPostedFileBase excelFile = Request.Files["ImportFileMsg"];//獲取文件流
FileManagement fileManagement = new FileManagement();//實例化 FileManagement
//string fileLastName = excelFile.FileName.Substring((excelFile.FileName).LastIndexOf('.')).ToLower().Trim();
string fileLastName = excelFile.FileName;
string newExcelName = Server.MapPath(excelPath) + "Kucuntiaozheng" + fileManagement.NewFileName(excelFile.FileName);//處理文件名，獲取新的文件名
excelFile.SaveAs(newExcelName);//上傳文件
DataTable dt = new DataTable();
NPOI4ExcelHelper helper = new NPOI4ExcelHelper(newExcelName);
dt = helper.SheetData();
DataRow[] dr = dt.Select(); //定义一个DataRow数组,读取ds里面所有行
int rowsnum = dt.Rows.Count;
if (rowsnum == 0)
{
json = "{success:true,iialgtotal:\"" + 0 + "\",iinvdtotal:\"" + 0 + "\",msg:\"" + "匯入盤點報表中沒有數據" + "\"}";
}
if (dr[0][0].ToString().Trim() == "編號" && dr[0][1].ToString().Trim() == "料位" && dr[0][2].ToString().Trim() == "料位狀態" && dr[0][11].ToString().Trim() == "有效日期" && dt.Columns.Count == 12)
{
_iagMgr = new IialgMgr(mySqlConnectionString);
j = _iagMgr.HuiruInsertiialg(dr, out iialgtotal, out iinvdtotal);
if (j > 0)
{
json = "{success:true,iialgtotal:\"" + iialgtotal + "\",iinvdtotal:\"" + iinvdtotal + "\",msg:\"" + "匯入盤點報表對照表成功!" + "\"}";
}
else
{
json = "{success:true,iialgtotal:\"" + iialgtotal + "\",iinvdtotal:\"" + iinvdtotal + "\",msg:\"" + "匯入數據標準不對,請嚴格按照模板匯入!" + "\"}";
}
}
else
{
json = "{success:true,iialgtotal:\"" + 0 + "\",iinvdtotal:\"" + 0 + "\",msg:\"" + "匯入盤點報表格式不正確!" + "\"}";
}
}
}
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);
json = "{success:false,msg:\"" + ex.ToString() + "\"}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//庫調記錄列表
public HttpResponseBase GetIialgList()
{
string json = string.Empty;
IialgQuery q = new IialgQuery();
q.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
q.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
uint id;
int rid = 0;
if (uint.TryParse(Request.Params["item_id"].ToUpper(), out id))//獲取參數
{
q.item_id = id;
}
if (!string.IsNullOrEmpty(Request.Params["loc_id"]))
{
q.loc_id = Request.Params["loc_id"].ToString().ToUpper();
}
if (!string.IsNullOrEmpty(Request.Params["po_id"]))
{
q.po_id = Request.Params["po_id"].ToString();
}
if (Request.Params["doc_userid"].ToString() != "-1")
{
q.doc_userid = int.Parse(Request.Params["doc_userid"]);
}
//if (!string.IsNullOrEmpty(Request.Params["iarc_id"]))
//{
// q.iarc_id = Request.Params["iarc_id"].ToString();
//}
DateTime time = DateTime.MinValue;
if (DateTime.TryParse(Request.Params["starttime"].ToString(), out time))
{
q.starttime = time;
}
if (DateTime.TryParse(Request.Params["endtime"].ToString(), out time))
{
q.endtime = time;
}
if (!string.IsNullOrEmpty(Request.Params["doc_no"].Trim().ToUpper()))//by zhaozhi0623j add 20151006
{
q.doc_no = Request.Params["doc_no"].Trim().ToUpper();
}
try
{
List<IialgQuery> store = new List<IialgQuery>();
_iagMgr = new IialgMgr(mySqlConnectionString);
int totalCount = 0;
store = _iagMgr.GetIialgList(q, out totalCount);
foreach (var item in store)
{
item.id = rid++;
item.qty = item.qty_o + item.adj_qty;
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,'msg':'user',totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
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);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public void KTPrintPDF()
{
PdfHelper pdf = new PdfHelper();
List<string> pdfList = new List<string>();
float[] arrColWidth = new float[] { 60, 60, 100, 60, 50, 30, 60, 60, 60, 60 };
int index = 0;
string newFileName = string.Empty;
string newName = string.Empty;
string json = string.Empty;
IialgQuery q = new IialgQuery();
if (!string.IsNullOrEmpty(Request.Params["KT_NO"].Trim().ToUpper()))//by zhaozhi0623j add 20151006
{
q.doc_no = Request.Params["KT_NO"].Trim().ToUpper();
}
try
{
List<IialgQuery> store = new List<IialgQuery>();
_iagMgr = new IialgMgr(mySqlConnectionString);
int totalCount = 0;
q.IsPage = false;
store = _iagMgr.GetIialgList(q, out totalCount);
int rid = 0;
DataTable _dtBody = new DataTable();
if (store.Count > 0)
{
_dtBody.Columns.Add("商品細項編號", typeof(string));
_dtBody.Columns.Add("主料位", typeof(string));
_dtBody.Columns.Add("商品名稱", typeof(string));
_dtBody.Columns.Add("規格", typeof(string));
_dtBody.Columns.Add("調整原因", typeof(string));
_dtBody.Columns.Add("數量", typeof(string));
_dtBody.Columns.Add("调整料位", typeof(string));
_dtBody.Columns.Add("有效日期", typeof(string));
_dtBody.Columns.Add("前置單號", typeof(string));
_dtBody.Columns.Add("備註", typeof(string));
for (int i = 0; i < store.Count; i++)
{
store[i].id = rid++;
store[i].qty = store[i].qty_o + store[i].adj_qty;
DataRow newRow = _dtBody.NewRow();
newRow["商品細項編號"] = store[i].item_id;
newRow["主料位"] = store[i].loc_id;
newRow["商品名稱"] = store[i].product_name;
newRow["規格"] = string.IsNullOrEmpty(store[i].prod_sz) ? " " : store[i].prod_sz;
newRow["調整原因"] = string.IsNullOrEmpty(store[i].iarc_id) ? " " : store[i].iarc_id;
newRow["數量"] = store[i].adj_qty;
newRow["调整料位"] = store[i].loc_R;
newRow["有效日期"] = store[i].cde_dt.ToString("yyyy-MM-dd").Substring(0, 10) == "0001-01-01" ? " " : store[i].cde_dt.ToString("yyyy-MM-dd").Substring(0, 10);
newRow["前置單號"] = string.IsNullOrEmpty(store[i].po_id) ? " " : store[i].po_id;
newRow["備註"] = string.IsNullOrEmpty(store[i].remarks) ? " " : store[i].remarks;
_dtBody.Rows.Add(newRow);
}
}
string UsingName = " ";
String UsingTime = " ";
if (store.Count > 0)
{
UsingName = store[0].name;
UsingTime = store[0].create_dtim.ToString("yyyy/MM/dd");
}
BaseFont bf = BaseFont.CreateFont("C:\\WINDOWS\\Fonts\\simsun.ttc,1", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
iTextSharp.text.Font fontChinese = new iTextSharp.text.Font(bf, 8, iTextSharp.text.Font.UNDERLINE, iTextSharp.text.BaseColor.RED);
iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 12, iTextSharp.text.Font.BOLD, new iTextSharp.text.BaseColor(0, 0, 0));//黑
string filename = "庫存調整" + DateTime.Now.ToString("yyyyMMddHHmmss");
Document document = new Document(PageSize.A4.Rotate());
string newPDFName = Server.MapPath(excelPath) + filename;
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(newPDFName, FileMode.Create));
document.Open();
#region 庫存調整單頭
PdfPTable ptable = new PdfPTable(10);
ptable.WidthPercentage = 100;//表格寬度
ptable.SetTotalWidth(arrColWidth);
PdfPCell cell = new PdfPCell();
cell = new PdfPCell(new Phrase("執行人員:" + UsingName, new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 8;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("執行日期:" + UsingTime, new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 2;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
cell.Colspan = 8;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 4)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
//cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" 庫存調整單", new iTextSharp.text.Font(bf, 15)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 3;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("單號" + ":" + q.doc_no, new iTextSharp.text.Font(bf, 10)));// ipoStore[a].po_type_desc
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.Colspan = 7;
cell.DisableBorderSide(1);
cell.DisableBorderSide(2);
cell.DisableBorderSide(4);
// cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 4)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
cell.Colspan = 10;
cell.DisableBorderSide(1);
//cell.DisableBorderSide(2);
// cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品細項編號", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("主料位", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("商品名稱", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("規格", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("調整原因", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("數量", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
//cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("调整料位", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("有效日期", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("前置單號", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("備註", new iTextSharp.text.Font(bf, 10)));
cell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//cell.DisableBorderSide(1);
// cell.DisableBorderSide(2);
//cell.DisableBorderSide(4);
//cell.DisableBorderSide(8);
ptable.AddCell(cell);
//cell.UseAscender = true;
//cell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
//cell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
//cell.BorderWidth = 0.1f;
//cell.BorderColor = new BaseColor(0, 0, 0);
#endregion
#region 庫存調整單尾
PdfPTable ptablefoot = new PdfPTable(10);
ptablefoot.WidthPercentage = 100;//表格寬度
ptablefoot.SetTotalWidth(arrColWidth);
PdfPCell footcell = new PdfPCell();
footcell.UseAscender = true;
footcell.HorizontalAlignment = Element.ALIGN_CENTER;//字體垂直居中
footcell.VerticalAlignment = Element.ALIGN_MIDDLE;//字體水平居中
footcell.BorderWidth = 0.1f;
footcell.BorderColor = new BaseColor(0, 0, 0);
footcell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 15)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居左
//footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 10;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase("印表日期:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居右
// footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 2;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居右
// footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 1;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase("印表人:" + (System.Web.HttpContext.Current.Session["caller"] as Caller).user_username, new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_RIGHT;//水平居右
footcell.Colspan = 2;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase(" ", new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_LEFT;//字體水平居右
// footcell.HorizontalAlignment = Element.ALIGN_LEFT;//水平居右
footcell.Colspan = 3;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
footcell = new PdfPCell(new Phrase("主管簽核:__________________", new iTextSharp.text.Font(bf, 10)));
footcell.VerticalAlignment = Element.ALIGN_RIGHT;//字體水平居右
footcell.Colspan = 2;
footcell.DisableBorderSide(1);
footcell.DisableBorderSide(2);
footcell.DisableBorderSide(4);
footcell.DisableBorderSide(8);
ptablefoot.AddCell(footcell);
#endregion
if (store.Count == 0)
{
document = new Document(PageSize.A4.Rotate());
if (!document.IsOpen())
{
document.Open();
}
cell = new PdfPCell(new Phrase(" ", font));
cell.Colspan = 4;
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
cell.DisableBorderSide(8);
ptable.AddCell(cell);
cell = new PdfPCell(new Phrase("此庫調單庫調數據不存在!", font));
cell.Colspan = 7;
cell.DisableBorderSide(4);
cell.VerticalAlignment = Element.ALIGN_CENTER;//字體水平居左
ptable.AddCell(cell);
// document.Add(ptable);
//document.Add(ptablefoot);
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 10, uint.Parse(store.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
else
{
newFileName = newPDFName + "_part" + index++ + "." + "pdf";
pdf.ExportDataTableToPDF(_dtBody, false, newFileName, arrColWidth, ptable, ptablefoot, "", "", 10, uint.Parse(store.Count.ToString()));/*第一7是列，第二個是行*/
pdfList.Add(newFileName);
}
//newFileName = newPDFName + "_part" + index++ + "." + "pdf";
//pdf.ExportDataTableToPDF(newFileName, ptable, "", "");
//pdfList.Add(newFileName);
//document.Add(ptable);
//document.NewPage();
newFileName = newPDFName + "." + "pdf";
pdf.MergePDF(pdfList, newFileName);
Response.Clear();
Response.Charset = "gb2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attach-ment;filename=" + filename + ".pdf");
Response.WriteFile(newFileName);
}
catch (Exception)
{
throw;
}
}
public HttpResponseBase InsertIialg()
{
string json = string.Empty;
IialgQuery iagQuery = new IialgQuery();
Iinvd invd = new Iinvd();
int result = 0;
try
{
invd.row_id = Convert.ToInt32(Request.Params["row_id"]);//行號碼
_iinvd = new IinvdMgr(mySqlConnectionString);
DataTable dt = _iinvd.GetRowMsg(invd);//首先根據row_id 獲取到製造日期和有效日期
iagQuery.made_dt = Convert.ToDateTime(dt.Rows[0]["made_date"]);//製造日期
iagQuery.cde_dt = Convert.ToDateTime(dt.Rows[0]["cde_dt"]);//有效日期
if (!string.IsNullOrEmpty(Request.Params["item_id"]))//商品細項編號
{
iagQuery.item_id = Convert.ToUInt32(Request.Params["item_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["po_id"]))
{
iagQuery.po_id = Request.Params["po_id"];//採購單編號
}
if (!string.IsNullOrEmpty(Request.Params["iarc_id"]))
{
iagQuery.iarc_id = Request.Params["iarc_id"];//庫調原因
}
if (!string.IsNullOrEmpty(Request.Params["ktloc_id"]))
{
iagQuery.loc_id = Request.Params["ktloc_id"].ToUpper();//料位編號
}
if (!string.IsNullOrEmpty(Request.Params["doc_no"]))
{
iagQuery.doc_no = Request.Params["doc_no"];//庫調單號
}
if (!string.IsNullOrEmpty(Request.Params["remarks"]))
{
iagQuery.remarks = Request.Params["remarks"];//庫調單號
}
if (!string.IsNullOrEmpty(Request.Params["made_date"]))//創建時間
{
iagQuery.made_dt = Convert.ToDateTime(Request.Params["made_date"]);
}
if (!string.IsNullOrEmpty(Request.Params["end_date"]))//有效日期
{
iagQuery.cde_dt = Convert.ToDateTime(Request.Params["end_date"]);//庫調單號
}
int kucuncount = Convert.ToInt32(Request.Params["benginnumber"]);//庫存數量
int tiaozhengcount = Convert.ToInt32(Request.Params["changenumber"]);//調整數量
int kucuntype = Convert.ToInt32(Request.Params["kutiaotype"]);//庫存類型
if (kucuntype == 1)
{
iagQuery.adj_qty = tiaozhengcount; //調整庫存
}
else
{
iagQuery.adj_qty = tiaozhengcount * (-1);//調整庫存
}
iagQuery.qty_o = kucuncount;//原來庫存
iagQuery.create_dtim = DateTime.Now;
iagQuery.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
if (!string.IsNullOrEmpty(Request.Params["ktloc_id"]))
{
iagQuery.loc_id = Request.Params["ktloc_id"];
}
if (!string.IsNullOrEmpty(Request.Params["doc_no"]))
{
iagQuery.doc_no = Request.Params["doc_no"];
}
_iagMgr = new IialgMgr(mySqlConnectionString);
result = _iagMgr.insertiialg(iagQuery);
if (result > 0)
{
json = "{success:true}";//返回json數據
}
else
{
json = "{success:false}";//返回json數據
}
}
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);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase KutiaoAddorReduce()
{
string jsonStr = String.Empty;
_iinvd = new IinvdMgr(mySqlConnectionString);
_iagMgr = new IialgMgr(mySqlConnectionString);
Iinvd invd = new Iinvd();
iialg iag = new iialg();
IstockChange Icg = new IstockChange();
ProductItem Proitems = new ProductItem();
int results = 0;
try
{
invd.row_id = Convert.ToInt32(Request.Params["row_id"]);//行號碼
int resultcount = 0;
int kucuncount = Convert.ToInt32(Request.Params["benginnumber"]);//庫存數量
int tiaozhengcount = Convert.ToInt32(Request.Params["changenumber"]);
int kucuntype = Convert.ToInt32(Request.Params["kutiaotype"]);
if (!string.IsNullOrEmpty(Request.Params["item_id"]))//商品細項編號
{
Icg.item_id = Convert.ToUInt32(Request.Params["item_id"]);
Proitems.Item_Id = Icg.item_id;
}
int oldsumcount = _iinvd.GetProqtyByItemid(Convert.ToInt32(Icg.item_id));//總庫存
string iarc_id = "";
if (!string.IsNullOrEmpty(Request.Params["iarcid"]))
{
iarc_id = Request.Params["iarcid"];//庫調原因
}
#region 庫存調整的時候，商品庫存也要調整
_proditemMgr = new ProductItemMgr(mySqlConnectionString);
int item_stock = 0;
#endregion
if (kucuntype == 1)//表示選擇了加
{
resultcount = kucuncount + tiaozhengcount;
item_stock = tiaozhengcount;
}
else//表示選擇了減號
{
resultcount = kucuncount - tiaozhengcount;
item_stock = -tiaozhengcount;
}
Proitems.Item_Stock = item_stock;
invd.prod_qty = resultcount;//此時為更改后的庫存
invd.change_dtim = DateTime.Now;
invd.change_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
Icg.sc_trans_type = 2;
Icg.sc_num_old = oldsumcount;
Icg.sc_time = DateTime.Now;
Icg.sc_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
if (!string.IsNullOrEmpty(Request.Params["po_id"]))
{
Icg.sc_cd_id = Request.Params["po_id"];//採購單編號
}
if (!string.IsNullOrEmpty(Request.Params["doc_no"]))
{
Icg.sc_trans_id = Request.Params["doc_no"];//庫調單號
}
if (!string.IsNullOrEmpty(Request.Params["remarks"]))
{
Icg.sc_note = Request.Params["remarks"];//備註
}
_istockMgr = new IstockChangeMgr(mySqlConnectionString);
int j = _iinvd.kucunTiaozheng(invd); //更改iloc表中的狀態並且在iialg表中插入數據
string path = "/WareHouse/KutiaoAddorReduce";
Caller call = new Caller();
call = (System.Web.HttpContext.Current.Session["caller"] as Caller);
int k = 0;
if (iarc_id == "NE" || iarc_id == "RF")//庫存調整-不改動前台庫存
{
k = 1;
}
else
{
k = _proditemMgr.UpdateItemStock(Proitems, path, call);
}
int newsumcount = _iinvd.GetProqtyByItemid(Convert.ToInt32(Icg.item_id));//總庫存
Icg.sc_num_chg = newsumcount - oldsumcount;
Icg.sc_num_new = newsumcount;
Icg.sc_istock_why = 2;
if (oldsumcount != newsumcount)
{
results = _istockMgr.insert(Icg);
}
else
{
results = 1;
}
if (j > 0 && results > 0 && k > 0)
{
jsonStr = "{success:true}";
}
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;
}
// 更新表Iinvd庫存鎖的狀態
public JsonResult UpdateIinvdActive()
{
string jsonStr = string.Empty;
try
{
_iinvd = new IinvdMgr(mySqlConnectionString);
Iinvd nvd = new Iinvd();
IialgQuery q = new IialgQuery();
_iagMgr = new IialgMgr(mySqlConnectionString);
int id = Convert.ToInt32(Request.Params["id"]);
string active = Request.Params["active"];
string lock_id = Request.Params["lock_id"];
if (!string.IsNullOrEmpty(Request.Params["po_id"].ToString()))
{
q.po_id = Request.Params["po_id"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["remarks"].ToString()))
{
q.remarks = Request.Params["remarks"].ToString();
}
if (active == "H")
{
nvd.ista_id = "A";
nvd.qity_id = 0;
}
else if (active == "A")
{
nvd.qity_id = Convert.ToInt32(lock_id);
nvd.ista_id = "H";
}
nvd.row_id = id;
nvd.change_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
nvd.change_dtim = DateTime.Now;
if (_iinvd.UpdateIinvdLock(nvd, q) > 0)
{
//加鎖成功往iialg插入一條數據;解鎖不需要記錄
if (active == "A")
{
Iinvd store = _iinvd.GetIinvd(nvd).FirstOrDefault();
q.loc_id = store.plas_loc_id;
q.item_id = store.item_id;
q.iarc_id = "KS";
q.qty_o = store.prod_qty;
q.type = 1;
q.adj_qty = -store.prod_qty;
q.create_dtim = DateTime.Now;
q.create_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
q.made_dt = store.made_date;
q.cde_dt = store.cde_dt;
if (_iagMgr.insertiialg(q) > 0)
{
Caller call = new Caller();
call = (System.Web.HttpContext.Current.Session["caller"] as Caller);
ProductItem proitem = new ProductItem();
_proditemMgr = new ProductItemMgr(mySqlConnectionString);
int item_stock = store.prod_qty;
proitem.Item_Stock = -item_stock;
proitem.Item_Id = store.item_id;
string path = "/WareHouse/KutiaoAddorReduce";
_proditemMgr.UpdateItemStock(proitem, path, call);
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
else
{
Iinvd store = _iinvd.GetIinvd(nvd).FirstOrDefault();
q.loc_id = store.plas_loc_id;
q.item_id = store.item_id;
q.iarc_id = "KS";
q.qty_o = 0;
q.type = 1;
q.adj_qty = store.prod_qty;
q.create_dtim = DateTime.Now;
q.create_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
q.made_dt = store.made_date;
q.cde_dt = store.cde_dt;
if (_iagMgr.insertiialg(q) > 0)
{
Caller call = new Caller();
call = (System.Web.HttpContext.Current.Session["caller"] as Caller);
ProductItem proitem = new ProductItem();
_proditemMgr = new ProductItemMgr(mySqlConnectionString);
int item_stock = store.prod_qty;
proitem.Item_Stock = item_stock;
proitem.Item_Id = store.item_id;
string path = "/WareHouse/KutiaoAddorReduce";
_proditemMgr.UpdateItemStock(proitem, path, call);
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
}
else
{
return Json(new { 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);
return Json(new { success = "false" });
}
}
public HttpResponseBase InsertIinvd()
{
string jsonStr = String.Empty;
Int64 aaa = 0; //無用變數
uint p = 0; //無用變數
try
{
Iinvd m = new Iinvd();
IialgQuery ia = new IialgQuery();
Iupc iu = new Iupc();
ProductItem proitem = new ProductItem();
Caller call = new Caller();
IstockChangeQuery stock = new IstockChangeQuery();
call = (System.Web.HttpContext.Current.Session["caller"] as Caller);
string path = "";
_iinvd = new IinvdMgr(mySqlConnectionString);
_iagMgr = new IialgMgr(mySqlConnectionString);
_IiupcMgr = new IupcMgr(mySqlConnectionString);
#region 獲取數據往
if (Int64.TryParse(Request.Params["item_id"].ToString(), out aaa))
{
if (uint.TryParse(Request.Params["item_id"].ToString(), out p))
{
m.item_id = uint.Parse(Request.Params["item_id"].ToString());
}
if (Request.Params["item_id"].ToString().Length > 6)
{
m.item_id = uint.Parse(_iinvd.Getprodubybar(Request.Params["item_id"].ToString()).Rows[0]["item_id"].ToString());
}
}
else
{
if (Request.Params["item_id"].ToString().Length > 6)
{
m.item_id = uint.Parse(_iinvd.Getprodubybar(Request.Params["item_id"].ToString()).Rows[0]["item_id"].ToString());
}
}
m.dc_id = 1;
m.whse_id = 1;
m.prod_qty = Int32.Parse(Request.Params["prod_qty"].ToString());//數量
DateTime today = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime dtime;
if (DateTime.TryParse(Request.Params["startTime"].ToString(), out dtime))
{//用戶填寫創建時間算出有效日期
DateTime start = DateTime.Parse(Request.Params["startTime"].ToString());
m.made_date = start;
if (uint.TryParse(Request.Params["cde_dt_incr"].ToString(), out p))
{
m.cde_dt = start.AddDays(Int32.Parse(Request.Params["cde_dt_incr"].ToString()));
}
else
{
m.cde_dt = DateTime.Now;
}
}
else
{
if (DateTime.TryParse(Request.Params["cde_dt"].ToString(), out dtime))
{//用戶填寫有效日期算出製造日期
m.cde_dt = DateTime.Parse(Request.Params["cde_dt"].ToString());//有效時間
if (uint.TryParse(Request.Params["cde_dt_incr"].ToString(), out p))
{
m.made_date = m.cde_dt.AddDays(-Int32.Parse(Request.Params["cde_dt_incr"].ToString()));
}
else
{
m.made_date = today;
}
}
else
{
m.cde_dt = today;
m.made_date = today;
}
}
m.cde_dt = DateTime.Parse(m.cde_dt.ToShortDateString());
m.made_date = DateTime.Parse(m.made_date.ToShortDateString());
m.plas_loc_id = Request.Params["plas_loc_id"].ToString().ToUpper();//上架料位
string loc_id = Request.Params["loc_id"].ToString().ToUpper();
m.change_dtim = DateTime.Now;//編輯時間
m.receipt_dtim = DateTime.Now;//收貨時間
m.create_user = (Session["caller"] as Caller).user_id;
#endregion
#region 獲取數據添加打iialg
ia.loc_id = m.plas_loc_id.ToString().ToUpper();
ia.item_id = m.item_id;
stock.sc_trans_type = 0;
if (!string.IsNullOrEmpty(Request.Params["iarc_id"].ToString()))
{
ia.iarc_id = Request.Params["iarc_id"].ToString();
}
else
{
ia.iarc_id = "PC";
stock.sc_trans_type = 1;//收貨上架
}
//if (ia.iarc_id == "DR" || ia.iarc_id == "KR")
//{
// type = 2;//RF理貨
//}
ia.create_dtim = DateTime.Now;
ia.create_user = m.create_user;
ia.doc_no = "P" + DateTime.Now.ToString("yyyyMMddHHmmss");
if (!string.IsNullOrEmpty(Request.Params["doc_num"]))
{
ia.doc_no = Request.Params["doc_num"];
stock.sc_trans_id = ia.doc_no;//交易單號
}
if (!string.IsNullOrEmpty(Request.Params["Po_num"]))
{
ia.po_id = Request.Params["Po_num"];
stock.sc_cd_id = ia.po_id;//前置單號
}
if (!string.IsNullOrEmpty(Request.Params["remark"]))
{
ia.remarks = Request.Params["remark"];
stock.sc_note = ia.remarks;//備註
}
ia.made_dt = m.made_date;
ia.cde_dt = m.cde_dt;
#endregion
#region 獲取店內條碼-=添加條碼
if (!string.IsNullOrEmpty(Request.Params["vendor_id"].ToString()))
{
iu.upc_id = CommonFunction.GetUpc(m.item_id.ToString(), Request.Params["vendor_id"].ToString(), m.cde_dt.ToString("yyMMdd"));
}
iu.item_id = m.item_id;
iu.upc_type_flg = "2";//店內碼
iu.create_user = m.create_user;
string result = _IiupcMgr.IsExist(iu);//是否有重複的條碼
if (result == "0")
{
if (_IiupcMgr.Insert(iu) < 1)
{
jsonStr = "{success:true,msg:2}";
}
}
#endregion
#region 新增/編輯
#region 庫存調整的時候，商品庫存也要調整
_proditemMgr = new ProductItemMgr(mySqlConnectionString);
int item_stock = m.prod_qty;
proitem.Item_Stock = item_stock;
proitem.Item_Id = m.item_id;
#endregion
if (_iinvd.IsUpd(m, stock) > 0)
{//編輯
ia.qty_o = _iinvd.Selnum(m);
ia.adj_qty = m.prod_qty;
m.prod_qty = ia.qty_o + m.prod_qty;
if (m.prod_qty >= 0)
{
if (_iinvd.Upd(m) > 0)
{
if (Request.Params["iialg"].ToString() == "Y")
{//
if (ia.iarc_id != "PC" && ia.iarc_id != "NE")//------------庫存調整的時候商品庫存也更改，收貨上架的時候不更改,RF理貨的時候也是不更改
{
path = "/WareHouse/KutiaoAddorReduce";
_proditemMgr.UpdateItemStock(proitem, path, call);
}
if (_iagMgr.insertiialg(ia) > 0)
{
jsonStr = "{success:true,msg:0}";//更新成功
}
else
{
jsonStr = "{success:false,msg:1}";//更新失敗
}
}
else
{
jsonStr = "{success:true,msg:0}";//更新成功
}
}
else
{
jsonStr = "{success:false,msg:1}";//更新失敗
}
}
else
{
jsonStr = "{success:false,msg:1}";//庫存為負數
}
}
else
{//新增
m.ista_id = "A";
m.create_dtim = DateTime.Now; //創建時間
if (_iinvd.Insert(m) > 0)
{
_IlocMgr = new IlocMgr(mySqlConnectionString);
Iloc loc = new BLL.gigade.Model.Iloc();
loc.change_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
loc.change_dtim = DateTime.Now;
loc.loc_id = m.plas_loc_id.ToString().ToUpper();
if (loc_id.Trim() != m.plas_loc_id.Trim())//判斷如果是主料位不需要進行多餘的操作
{
if (_IlocMgr.SetIlocUsed(loc) > 0)
{
if (Request.Params["iialg"].ToString() == "Y")
{
if (ia.iarc_id != "PC" && ia.iarc_id != "NE")//------------庫存調整的時候商品庫存也更改，收貨上架的時候不更改,RF理貨的時候也是不更改
{
path = "/WareHouse/KutiaoAddorReduce";
_proditemMgr.UpdateItemStock(proitem, path, call);
}
ia.qty_o = 0;
ia.adj_qty = m.prod_qty;
if (_iagMgr.insertiialg(ia) > 0)
{
jsonStr = "{success:true,msg:0}";//更新成功
}
else
{
jsonStr = "{success:false,msg:1}";//更新失敗
}
}
else
{
jsonStr = "{success:true,msg:0}";//新增成功
}
}
else
{
jsonStr = "{success:false,msg:1}";//新增失敗
}
}
else
{
if (Request.Params["iialg"].ToString() == "Y")
{
if (ia.iarc_id != "PC" && ia.iarc_id != "NE")//------------庫存調整的時候商品庫存也更改，收貨上架的時候不更改,RF理貨的時候也是不更改
{
path = "/WareHouse/KutiaoAddorReduce";
_proditemMgr.UpdateItemStock(proitem, path, call);
}
ia.qty_o = 0;
ia.adj_qty = m.prod_qty;
if (_iagMgr.insertiialg(ia) > 0)
{
jsonStr = "{success:true,msg:0}";//更新成功
}
else
{
jsonStr = "{success:false,msg:1}";//更新失敗
}
}
else
{
jsonStr = "{success:true,msg:0}";//新增成功
}
}
}
else
{
jsonStr = "{success:false,msg:1}";
}
}
#endregion
}
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.ToString());
this.Response.End();
return this.Response;
}
public JsonResult IinvdSave()
{
bool falg = false;
string message ="保存失敗";
try
{
string row_id = "";
int prod_qty = 0;
if (Request.Params["rowid"].Length > 5)
{
row_id = Request.Params["rowid"].Substring(5);
}
string changeStore = Request.Params["changeStore"];
int temp1=0;
if (int.TryParse(changeStore, out temp1))
{
if (temp1 < 0)
{
falg = false;
message = "庫存不能小於1";
}
else
{
_iinvd = new IinvdMgr(mySqlConnectionString);
IinvdQuery iinvd = new IinvdQuery();
iinvd.pwy_dte_ctl = Request.Params["pwy_dte_ctl"];
if (!string.IsNullOrEmpty(Request.Params["loc_id"]))
{
iinvd.plas_loc_id = Request.Params["loc_id"];
}
int id = 0;
if (int.TryParse(row_id, out id))
{
iinvd.row_id = id;
}
if (int.TryParse(changeStore, out id))
{
iinvd.prod_qty = id;
}
if (!string.IsNullOrEmpty(Request.Params["item_id"]))
{
if (int.TryParse(Request.Params["item_id"], out id))
{
iinvd.item_id = uint.Parse(Request.Params["item_id"]);
}
}
iinvd.create_user = (Session["caller"] as Caller).user_id;
iinvd.create_dtim = DateTime.Now;
iinvd.change_user = iinvd.create_user;
iinvd.change_dtim = iinvd.create_dtim;
iinvd.prod_qtys = _iinvd.GetProd_qty(Convert.ToInt32(iinvd.item_id), iinvd.plas_loc_id, "", iinvd.row_id.ToString());
if (iinvd.pwy_dte_ctl == "Y")
{
List<DateTime> list = new List<DateTime>();
list=_iinvd.GetCde_dt(iinvd.row_id);
if(list.Count>0)
{
iinvd.cde_dt = list[0];
iinvd.made_date = list[1];
}
}
else
{
iinvd.made_date = iinvd.create_dtim;
iinvd.cde_dt = iinvd.create_dtim;
}
if (iinvd.row_id != 0)
{
if (iinvd.pwy_dte_ctl == "Y")
{
prod_qty = _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id, iinvd.pwy_dte_ctl, iinvd.row_id.ToString());
if (prod_qty == iinvd.prod_qty)
{
falg = true;
return Json(new { success = falg, message = message });
}
else if (_iinvd.SaveIinvd(iinvd) == 1)
{
falg = true;
}
}
if (iinvd.pwy_dte_ctl == "N" || iinvd.pwy_dte_ctl == "")
{
iinvd.row_id = 0;
if (iinvd.prod_qtys < iinvd.prod_qty)
{
iinvd.ista_id = "A";
iinvd.prod_qty = iinvd.prod_qty - iinvd.prod_qtys;
iinvd.cde_dt = DateTime.Now;
int result=_iinvd.GetIinvdCount(iinvd);
if (result>1)
{
prod_qty = result - 1;
falg = true;
}
else
{
if (_iinvd.Insert(iinvd) == 1)
{
falg = true;
}
}
}
else if (iinvd.prod_qtys> iinvd.prod_qty)
{
if (_iinvd.SaveIinvd(iinvd) == 1)
{
falg = true;
return Json(new { success = falg, message = message });
}
}
else if (iinvd.prod_qtys == iinvd.prod_qty)
{
falg = true;
return Json(new { success = falg, message = message });
}
}
IialgQuery iialg = new IialgQuery();
iialg.cde_dt = iinvd.cde_dt;
iialg.qty_o = prod_qty;//原始庫存數量
iialg.loc_id = iinvd.plas_loc_id;
iialg.item_id = iinvd.item_id;
iialg.iarc_id = "循環盤點";
if (iinvd.pwy_dte_ctl == "Y")
{
iialg.adj_qty = iinvd.prod_qty - prod_qty;
}
else
{
iialg.adj_qty = iinvd.prod_qty-prod_qty;//轉移數量
}
iialg.create_dtim = DateTime.Now;
iialg.create_user = iinvd.create_user;
iialg.type = 2;
iialg.doc_no = "C" + DateTime.Now.ToString("yyyyMMddHHmmss");
iialg.made_dt = iinvd.made_date;
iialg.cde_dt = iinvd.cde_dt;
_iialgMgr = new IialgMgr(mySqlConnectionString);
_iialgMgr.insertiialg(iialg);
IstockChangeQuery istock = new IstockChangeQuery();
istock.sc_trans_id = iialg.doc_no;
istock.item_id = iinvd.item_id;
istock.sc_istock_why = 2;
istock.sc_trans_type = 2;
istock.sc_num_old = iinvd.prod_qtys;//原始庫存數量
istock.sc_num_chg = iialg.adj_qty;//轉移數量
istock.sc_num_new = _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id,"","");//結餘數量
istock.sc_time = iinvd.create_dtim;
istock.sc_user = iinvd.create_user;
istock.sc_note = "循環盤點";
IstockChangeMgr istockMgr = new IstockChangeMgr(mySqlConnectionString);
istockMgr.insert(istock);
}
else
{
return Json(new { success = falg });
}
}
}
else {
message = "庫存不能小於1";
}
}
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);
}
return Json(new { success = falg,message=message });
}
public HttpResponseBase SaveIinvd()
{
string json = "{success:false,message:'系統異常'}";
try
{
int temp = 0;
if (int.TryParse(Request.Params["prod_qty"], out temp))
{
if (temp > 0)
{
IinvdQuery iinvd = new IinvdQuery();
if (!string.IsNullOrEmpty(Request.Params["loc_id"]))
{
iinvd.plas_loc_id = Request.Params["loc_id"];
}
if (!string.IsNullOrEmpty(Request.Params["item_id"]))
{
if (int.TryParse(Request.Params["item_id"], out temp))
{
iinvd.item_id = uint.Parse(Request.Params["item_id"]);
}
}
#region 判斷是否指定主料位
IlocQuery ilocquery = new IlocQuery();
_IiplasMgr = new IplasMgr(mySqlConnectionString);
IplasQuery iplasquery = new IplasQuery();
iplasquery.item_id = iinvd.item_id;
IIlocImplMgr ilocMgr = new IlocMgr(mySqlConnectionString);
IplasDao iplasdao = new IplasDao(mySqlConnectionString);
int total = 0;
ilocquery.loc_id = iinvd.plas_loc_id;
ilocquery.lcat_id = "0";
ilocquery.lsta_id = "";
ilocquery.IsPage = false;
List<IlocQuery> listiloc = ilocMgr.GetIocList(ilocquery, out total);
if (listiloc.Count > 0)
{
string lcat_id = listiloc.Count == 0 ? "" : listiloc[0].lcat_id;
if (lcat_id == "S")
{
string item_id = iplasdao.Getlocid(ilocquery.loc_id);
if (item_id == "")
{
Iplas iplas = new Iplas();
if (int.TryParse(Request.Params["item_id"], out temp))
{
iplas.item_id = uint.Parse(Request.Params["item_id"]);
if (_IiplasMgr.IsTrue(iplas) == "false")
{
json = "{success:false,message:'不存在該商品編號'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
if (_IiplasMgr.GetIplasid(iplasquery) > 0)
{
json = "{success:false,message:'此商品主料位非該料位'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
Iloc iloc = new Iloc();
iloc.loc_id = iinvd.plas_loc_id;
if (_IiplasMgr.GetLocCount(iloc) <= 0)
{
json = "{success:false,message:'該料位已鎖定或被指派'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
iplas.loc_id = iloc.loc_id;
iplas.loc_stor_cse_cap = 100;
iplas.create_user = (Session["caller"] as Caller).user_id;
iplas.create_dtim = DateTime.Now;
iplas.change_user = (Session["caller"] as Caller).user_id;
iplas.change_dtim = DateTime.Now;
_IiplasMgr.InsertIplas(iplas);
}
}
}
}
#endregion
iinvd.create_user = (Session["caller"] as Caller).user_id;
iinvd.create_dtim = DateTime.Now;
iinvd.change_user = iinvd.create_user;
iinvd.change_dtim = iinvd.create_dtim;
iinvd.ista_id = "A";
if (!string.IsNullOrEmpty(Request.Params["loc_id"]))
{
iinvd.plas_loc_id = Request.Params["loc_id"];
}
int change_prod_qty = int.Parse(Request.Params["prod_qty"]);
iinvd.prod_qty = change_prod_qty;
if (!string.IsNullOrEmpty(Request.Params["st_qty"]))
{
if (int.TryParse(Request.Params["st_qty"], out temp))
{
iinvd.st_qty = int.Parse(Request.Params["st_qty"]);
}
}
if (!string.IsNullOrEmpty(Request.Params["item_id"]))
{
if (int.TryParse(Request.Params["item_id"], out temp))
{
iinvd.item_id = uint.Parse(Request.Params["item_id"]);
}
}
DateTime date = DateTime.Now;
if (DateTime.TryParse(Request.Params["datetimepicker1"], out date))
{
iinvd.made_date = date;
}
else
{
iinvd.made_date = DateTime.Now;
}
_iinvd = new IinvdMgr(mySqlConnectionString);
if (Request.Params["pwy_dte_ctl"] == "Y")
{
iinvd.pwy_dte_ctl = "Y";
IProductExtImplMgr productExt = new ProductExtMgr(mySqlConnectionString);
int Cde_dt_incr = productExt.GetCde_dt_incr((int)iinvd.item_id);
iinvd.cde_dt = date.AddDays(Cde_dt_incr);
}
else
{
iinvd.cde_dt = DateTime.Now;
}
iinvd.prod_qtys = _iinvd.GetProd_qty(Convert.ToInt32(iinvd.item_id), iinvd.plas_loc_id, "", iinvd.row_id.ToString());
IialgQuery iialg = new IialgQuery();
iialg.cde_dt = iinvd.cde_dt;
int prod_qty = 0;// _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id, "", "");
int row = _iinvd.GetIinvdCount(iinvd);
if (row > 1)
{
prod_qty = row - 1;
json = "{success:true}";
}
else
{
if (_iinvd.Insert(iinvd) == 1)
{
json = "{success:true}";
}
}
iialg.qty_o = prod_qty;
iialg.loc_id = iinvd.plas_loc_id;
iialg.item_id = iinvd.item_id;
iialg.iarc_id = "循環盤點";
iialg.adj_qty = change_prod_qty;
iialg.create_dtim = DateTime.Now;
iialg.create_user = iinvd.create_user;
iialg.type = 2;
iialg.doc_no = "C" + DateTime.Now.ToString("yyyyMMddHHmmss");
iialg.made_dt = iinvd.made_date;
iialg.cde_dt = iinvd.cde_dt;
_iialgMgr = new IialgMgr(mySqlConnectionString);
_iialgMgr.insertiialg(iialg);
IstockChangeQuery istock = new IstockChangeQuery();
istock.sc_trans_id = iialg.doc_no;
istock.item_id = iinvd.item_id;
istock.sc_istock_why = 2;
istock.sc_trans_type = 2;
istock.sc_num_old = iinvd.prod_qtys;
istock.sc_num_chg = iialg.adj_qty;
istock.sc_num_new = _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id,"N","");
istock.sc_time = iinvd.create_dtim;
istock.sc_user = iinvd.create_user;
istock.sc_note = "循環盤點";
IstockChangeMgr istockMgr = new IstockChangeMgr(mySqlConnectionString);
istockMgr.insert(istock);
}
else
{
json = "{success:false,message:'庫存不能小於1'}";
}
}
else
{
json = "{success:false,message:'庫存請輸入數字'}";
}
}
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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}