public override string QueryResult() { JsonModel model = new JsonModel(); ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data); TF.RunSafty.BLL.Tab_DeliverJSPrint bllPrint = new TF.RunSafty.BLL.Tab_DeliverJSPrint(); TF.RunSafty.Model.Tab_DeliverJSPrint modelPlan = new TF.RunSafty.Model.Tab_DeliverJSPrint(); try { int bPrint = bllPrint.IsJsPrintable(param.strPlanGUID, param.strTrainmanGUID, param.dtBeginWorkTime); modelPlan.StrPlanGUID = param.strPlanGUID; modelPlan.StrSiteGUID = this.cid; modelPlan.StrTrainmanGUID = param.strTrainmanGUID; model.result = "0"; model.returnStr = "返回成功"; model.bPrint = bPrint.ToString(); } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); model.result = "1"; model.returnStr = "提交失败" + ex.Message; } string result = Newtonsoft.Json.JsonConvert.SerializeObject(model); return(result); }
public Check_Out PrintCheck(string data) { Check_Out model = new Check_Out(); Check_In param = Newtonsoft.Json.JsonConvert.DeserializeObject <Check_In>(data); TF.RunSafty.BLL.Tab_DeliverJSPrint bllPrint = new TF.RunSafty.BLL.Tab_DeliverJSPrint(); TF.RunSafty.Model.Tab_DeliverJSPrint modelPlan = new TF.RunSafty.Model.Tab_DeliverJSPrint(); try { int bPrint = bllPrint.IsJsPrintable(param.strPlanGUID, param.strTrainmanGUID, param.dtBeginWorkTime); modelPlan.StrPlanGUID = param.strPlanGUID; modelPlan.StrSiteGUID = param.cid; modelPlan.StrTrainmanGUID = param.strTrainmanGUID; model.result = "0"; model.returnStr = "返回成功"; model.bPrint = bPrint.ToString(); } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); model.result = "1"; model.returnStr = "提交失败" + ex.Message; } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TF.RunSafty.Model.Tab_DeliverJSPrint model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tab_DeliverJSPrint("); strSql.Append("StrTrainmanGUID,StrPlanGUID,StrSiteGUID,dtPrintTime)"); strSql.Append(" values ("); strSql.Append("@StrTrainmanGUID,@StrPlanGUID,@StrSiteGUID,@dtPrintTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StrTrainmanGUID", SqlDbType.VarChar, 50), new SqlParameter("@StrPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@StrSiteGUID", SqlDbType.VarChar, 50), new SqlParameter("@dtPrintTime", SqlDbType.DateTime) }; parameters[0].Value = model.StrTrainmanGUID; parameters[1].Value = model.StrPlanGUID; parameters[2].Value = model.StrSiteGUID; parameters[3].Value = model.dtPrintTime; object obj = SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.Tab_DeliverJSPrint DataRowToModel(DataRow row) { TF.RunSafty.Model.Tab_DeliverJSPrint model = new TF.RunSafty.Model.Tab_DeliverJSPrint(); if (row != null) { if (row["nID"] != null && row["nID"].ToString() != "") { model.nID = int.Parse(row["nID"].ToString()); } if (row["StrTrainmanGUID"] != null) { model.StrTrainmanGUID = row["StrTrainmanGUID"].ToString(); } if (row["StrPlanGUID"] != null) { model.StrPlanGUID = row["StrPlanGUID"].ToString(); } if (row["StrSiteGUID"] != null) { model.StrSiteGUID = row["StrSiteGUID"].ToString(); } if (row["dtPrintTime"] != null && row["dtPrintTime"].ToString() != "") { model.dtPrintTime = DateTime.Parse(row["dtPrintTime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TF.RunSafty.Model.Tab_DeliverJSPrint model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tab_DeliverJSPrint set "); strSql.Append("StrTrainmanGUID=@StrTrainmanGUID,"); strSql.Append("StrPlanGUID=@StrPlanGUID,"); strSql.Append("StrSiteGUID=@StrSiteGUID,"); strSql.Append("dtPrintTime=@dtPrintTime"); strSql.Append(" where nID=@nID"); SqlParameter[] parameters = { new SqlParameter("@StrTrainmanGUID", SqlDbType.VarChar, 50), new SqlParameter("@StrPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@StrSiteGUID", SqlDbType.VarChar, 50), new SqlParameter("@dtPrintTime", SqlDbType.DateTime), new SqlParameter("@nID", SqlDbType.Int, 4) }; parameters[0].Value = model.StrTrainmanGUID; parameters[1].Value = model.StrPlanGUID; parameters[2].Value = model.StrSiteGUID; parameters[3].Value = model.dtPrintTime; parameters[4].Value = model.nID; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 保存打印记录 /// </summary> /// <param name="print"></param> public void SavePrintData(printModel print, string cid) { TF.RunSafty.Model.Tab_DeliverJSPrint modelPlan = new TF.RunSafty.Model.Tab_DeliverJSPrint(); modelPlan.StrPlanGUID = print.strPlanGUID; modelPlan.StrSiteGUID = cid; modelPlan.StrTrainmanGUID = print.strTrainmanGUID; string strPrintTime = print.dtPrintTime; DateTime dtPrint; if (DateTime.TryParse(strPrintTime, out dtPrint)) { modelPlan.dtPrintTime = dtPrint; } bllPrint.Add(modelPlan); }
public override string QueryResult() { JsonModel model = new JsonModel(); ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data); TF.RunSafty.BLL.Tab_DeliverJSPrint bllPrint = new TF.RunSafty.BLL.Tab_DeliverJSPrint(); TF.RunSafty.Model.Tab_DeliverJSPrint modelPlan = new TF.RunSafty.Model.Tab_DeliverJSPrint(); try { modelPlan.StrPlanGUID = param.PlanGUID; modelPlan.StrSiteGUID = this.cid; modelPlan.StrTrainmanGUID = param.TrainmanGUID; DateTime dtPrint; if (DateTime.TryParse(param.PrintTime, out dtPrint)) { modelPlan.dtPrintTime = dtPrint; } if (bllPrint.Add(modelPlan) > 0) { model.result = "0"; model.returnStr = "提交成功"; } else { model.result = "1"; model.returnStr = "提交失败"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); model.result = "1"; model.returnStr = "提交失败"; } string result = Newtonsoft.Json.JsonConvert.SerializeObject(model); return(result); }
public Add_Out AddtPrintRecord(string data) { Add_Out model = new Add_Out(); Add_In param = Newtonsoft.Json.JsonConvert.DeserializeObject <Add_In>(data); TF.RunSafty.BLL.Tab_DeliverJSPrint bllPrint = new TF.RunSafty.BLL.Tab_DeliverJSPrint(); TF.RunSafty.Model.Tab_DeliverJSPrint modelPlan = new TF.RunSafty.Model.Tab_DeliverJSPrint(); try { modelPlan.StrPlanGUID = param.PlanGUID; modelPlan.StrSiteGUID = param.cid; modelPlan.StrTrainmanGUID = param.TrainmanGUID; DateTime dtPrint; if (DateTime.TryParse(param.PrintTime, out dtPrint)) { modelPlan.dtPrintTime = dtPrint; } if (bllPrint.Add(modelPlan) > 0) { model.result = "0"; model.returnStr = "提交成功"; } else { model.result = "1"; model.returnStr = "提交失败"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); model.result = "1"; model.returnStr = "提交失败"; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.Tab_DeliverJSPrint GetModel(int nID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 nID,StrTrainmanGUID,StrPlanGUID,StrSiteGUID,dtPrintTime from Tab_DeliverJSPrint "); strSql.Append(" where nID=@nID"); SqlParameter[] parameters = { new SqlParameter("@nID", SqlDbType.Int, 4) }; parameters[0].Value = nID; TF.RunSafty.Model.Tab_DeliverJSPrint model = new TF.RunSafty.Model.Tab_DeliverJSPrint(); DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }