//獲取製造日期，有效日期判斷是否日期控管
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;
}
}