//獲取製造日期,有效日期判斷是否日期控管 public HttpResponseBase JudgeDate() { string jsonStr = "{success:false}"; DateTime dt = new DateTime(); DataTable data = new DataTable(); _iinvd = new IinvdMgr(mySqlConnectionString); int day = 0; try { string dtstring = Request.Params["dtstring"].ToString(); if (DateTime.TryParse(Request.Params["startTime"].ToString(), out dt)) { #region 編號獲取數據 if (!int.TryParse(Request.Params["item_id"].ToString(), out day)) {//獲取條碼 data = _iinvd.Getprodubybar(Request.Params["item_id"].ToString()); } else {//獲取商品編號 data = _iinvd.Getprodu(int.Parse(Request.Params["item_id"].ToString())); } #endregion DateTime dts = DateTime.Parse(Request.Params["startTime"].ToString()); if (data.Rows.Count > 0) {//該商品有數據才往下進行 if (data.Rows[0]["pwy_dte_ctl"].ToString() == "Y") {//需要日期控管才進行操作] DateTime dte = dts, dtss, dtee; dt = DateTime.Now; if (dtstring == "1" || dtstring == "2") { if (dtstring == "1") {//根據製造日期求出有效期 dte = dts.AddDays(int.Parse(data.Rows[0]["cde_dt_incr"].ToString()));//製造日期+保質期=有效期 } if (dtstring == "2") {//根據有效日期求出製造日期 dts = dte.AddDays(-int.Parse(data.Rows[0]["cde_dt_incr"].ToString())); } // if (dts > dt) { jsonStr = "{success:true,msg:'1'}"; } else { dtss = dts.AddDays(int.Parse(data.Rows[0]["cde_dt_var"].ToString()));//製造時間+允出天數 dtee = dt.AddDays(int.Parse(data.Rows[0]["cde_dt_shp"].ToString()));//今天+允出天數 if (dt > dtss) { jsonStr = "{success:true,msg:'2'}"; if (dtee > dte) { jsonStr = "{success:true,msg:'3'}"; if (dte < dt) { jsonStr = "{success:true,msg:'4',dte:'" + dte.ToShortDateString() + "'}"; } } } else { //有效期匯出 jsonStr = "{success:true,msg:'5',dts:'" + dts.ToString("yyyy-MM-dd") + "',dte:'" + dte.ToString("yyyy-MM-dd") + "'}"; } } } else { jsonStr = "{success:false}"; } } else { if (dts > DateTime.Now) { jsonStr = "{success:true,msg:'1'}"; } } } else { if (dts > DateTime.Now) { jsonStr = "{success:true,msg:'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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
//public HttpResponseBase SaveWhyLock() //{ // string json = string.Empty; // try // { // Iinvd Iinvd = new Iinvd(); // _iinvd = new IinvdMgr(mySqlConnectionString); // json = "{success:true}"; // } // 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 GetAseldListByJobidorOrderid() //{ // string json = string.Empty; // AseldQuery asequery = new AseldQuery(); // try // { // List<AseldQuery> store = new List<AseldQuery>(); // _iasdMgr = new AseldMgr(mySqlConnectionString); // store = _iasdMgr.GetAseldList(asequery); // 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,totalCount:0,data:[]}"; // } // this.Response.Clear(); // this.Response.Write(json); // this.Response.End(); // return this.Response; //} #endregion #region 公共方法 //商品顯示加規格 public string GetProductSpec(string id) { DataTable dt = new DataTable(); _iinvd = new IinvdMgr(mySqlConnectionString); int item_id = 0; string spec = string.Empty; if (int.TryParse(id, out item_id) && id.Length == 6) {//獲取商品編號 dt = _iinvd.Getprodu(item_id); } if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(dt.Rows[0]["spec_name"].ToString())) { spec += dt.Rows[0]["spec_name"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[0]["spec_name1"].ToString())) { if (spec.Length > 0) { spec += ","; } spec += dt.Rows[0]["spec_name1"].ToString(); } if (spec.Length > 0) { spec = "(" + spec + ")"; } return spec; } else { return spec; } }