public HttpResponseBase GetDepStore()
{
string json = string.Empty;
List<EmsDepRelation> store = new List<EmsDepRelation>();
EmsDepRelation query = new EmsDepRelation();
query.dep_name = "請選擇...";
try
{
emsDepRelation = new EmsDepRelationMgr(mySqlConnectionString);
store= emsDepRelation.GetDepStore();
store.Insert(0, query);
json = "{success:true,data:" + JsonConvert.SerializeObject(store, Formatting.Indented) + "}";
}
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 EmsDepRelationList()
{
List<EmsDepRelation> store = new List<EmsDepRelation>();
EmsDepRelation query = new EmsDepRelation();
int totalCount = 0;
string json = string.Empty;
emsDepRelation = new EmsDepRelationMgr(mySqlConnectionString);
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
try
{
if (!string.IsNullOrEmpty(Request.Params["dep_code"]))
{
query.relation_dep = Convert.ToInt32(Request.Params["dep_code"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_type"]))
{
query.re_type = Convert.ToInt32(Request.Params["relation_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["datatype"]))
{
query.datatype = Convert.ToInt32(Request.Params["datatype"]);
}
if (!string.IsNullOrEmpty(Request.Params["date"]))
{
query.date = Convert.ToDateTime(Request.Params["date"]);
}
query.create_user = (Session["caller"] as Caller).user_id;
query.update_user = (Session["caller"] as Caller).user_id;
query.predate = DateTime.Now.AddDays(-1);
store=emsDepRelation.EmsDepRelationList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";
}
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 SaveEmsDep()
{
EmsDepRelation query = new EmsDepRelation();
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.Params["relation_dep"]))
{
query.relation_dep = Convert.ToInt32(Request.Params["relation_dep"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_type"]))
{
query.relation_type = Convert.ToInt32(Request.Params["relation_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_year"]))
{
query.relation_year = Convert.ToInt32(Request.Params["relation_year"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_month"]))
{
query.relation_month = Convert.ToInt32(Request.Params["relation_month"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_day"]))
{
query.relation_day = Convert.ToInt32(Request.Params["relation_day"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_order_cost"]))
{
query.relation_order_cost = Convert.ToInt32(Request.Params["relation_order_cost"]);
}
if (!string.IsNullOrEmpty(Request.Params["relation_order_count"]))
{
query.relation_order_count = Convert.ToInt32(Request.Params["relation_order_count"]);
}
query.create_user = (Session["caller"] as Caller).user_id;
query.update_user = (Session["caller"] as Caller).user_id;
emsDepRelation = new EmsDepRelationMgr(mySqlConnectionString);
json= emsDepRelation.SaveEmsDepRe(query);
}
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:true,msg:2}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase EditEmsDepR()
{
string json = string.Empty;
EmsDepRelation query = new EmsDepRelation();
try
{
if (!string.IsNullOrEmpty(Request.Params["relation_id"]))
{
query.relation_id = Convert.ToInt32(Request.Params["relation_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["emsDep"]))
{
query.emsdep = (Request.Params["emsDep"]);
}
if (!string.IsNullOrEmpty(Request.Params["value"]))
{
query.value = Convert.ToInt32(Request.Params["value"]);
}
query.update_user = (Session["caller"] as Caller).user_id;
emsDepRelation=new EmsDepRelationMgr (mySqlConnectionString);
json = emsDepRelation.EditEmsDepR(query);
}
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;
}