/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.TAB_Plan_Train GetModel(int nid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 nid,strTrainPlanGUID,strTrainTypeName,strTrainNumber,strTrainNo,dtStartTime,dtRealStartTime,strTrainJiaoluGUID,strStartStation,strEndStation,nTrainmanTypeID,nPlanType,nDragType,nKehuoID,nRemarkType,strRemark,nPlanState,dtCreateTime,strCreateSiteGUID,strCreateUserGUID,dtFirstStartTime,dtChuQinTime,nNeedRest,dtArriveTime,dtCallTime,strBak1,dtLastArriveTime,strMainPlanGUID,strPlaceID from TAB_Plan_Train "); strSql.Append(" where nid=@nid"); SqlParameter[] parameters = { new SqlParameter("@nid", SqlDbType.Int, 4) }; parameters[0].Value = nid; TF.RunSafty.Model.TAB_Plan_Train model = new TF.RunSafty.Model.TAB_Plan_Train(); DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public override string QueryResult() { JsonModel jsonModel = new JsonModel(); ParamModel param = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data); TF.RunSafty.BLL.Plan.TAB_Plan_Train bllPlan = new TF.RunSafty.BLL.Plan.TAB_Plan_Train(); TF.RunSafty.Model.TAB_Plan_Train plan = new TF.RunSafty.Model.TAB_Plan_Train(); try { DateTime dtStartTime; if (DateTime.TryParse(param.data.trainPlan.startTime, out dtStartTime)) { plan.dtStartTime = dtStartTime; } if (!string.IsNullOrEmpty(param.data.trainPlan.dragTypeID)) { plan.nDragType = int.Parse(param.data.trainPlan.dragTypeID); } if (!string.IsNullOrEmpty(param.data.trainPlan.kehuoID)) { plan.nKehuoID = int.Parse(param.data.trainPlan.kehuoID); } if (!string.IsNullOrEmpty(param.data.trainPlan.planTypeID)) { plan.nPlanType = int.Parse(param.data.trainPlan.planTypeID); } if (!string.IsNullOrEmpty(param.data.trainPlan.remarkTypeID)) { plan.nRemarkType = int.Parse(param.data.trainPlan.remarkTypeID); } if (!string.IsNullOrEmpty(param.data.trainPlan.trainmanTypeID)) { plan.nTrainmanTypeID = int.Parse(param.data.trainPlan.trainmanTypeID); } plan.strCreateSiteGUID = param.data.site.siteID; plan.strCreateUserGUID = param.data.user.userID; plan.strPlaceID = param.data.trainPlan.placeID; plan.strStartStation = param.data.trainPlan.startStationID; plan.strEndStation = param.data.trainPlan.endStationID; plan.strTrainJiaoluGUID = param.data.trainPlan.trainjiaoluID; plan.strTrainNo = param.data.trainPlan.trainNo; plan.strTrainNumber = param.data.trainPlan.trainNumber; plan.strTrainTypeName = param.data.trainPlan.trainTypeName; plan.dtCreateTime = DateTime.Now; plan.dtRealStartTime = plan.dtStartTime; string planGUID = Guid.NewGuid().ToString(); plan.strTrainPlanGUID = planGUID; plan.nPlanState = (int)TRsPlanState.psEdit; if (!string.IsNullOrEmpty(param.data.trainPlan.kaiCheTime)) { DateTime dtChuqinTime; if (DateTime.TryParse(param.data.trainPlan.kaiCheTime, out dtChuqinTime)) { plan.dtChuQinTime = dtChuqinTime; } } if (bllPlan.Add(plan) > 0) { jsonModel.data.planID = planGUID; jsonModel.result = 0; jsonModel.resultStr = "返回成功"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); } Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter).Replace(":null", ":\"\""); return(result); }
/// <summary> /// 增加一条数据 /// </summary> public int AddPlanTrain(TF.RunSafty.Model.TAB_Plan_Train model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_Train("); strSql.Append("strTrainNo,dtChuQinTime,nNeedRest,dtArriveTime,dtCallTime,nDragType,nKehuoID,nPlanType,nRemarkType,nTrainmanTypeID,strTrainJiaoluGUID,strTrainTypeName,dtStartTime,dtFirstStartTime,dtRealStartTime,nPlanState,strPlaceID,strStartStation,strEndStation,strRemark,strTrainNumber,strCreateSiteGUID,strCreateUserGUID"); strSql.Append(") values ("); strSql.Append("@strTrainNo,@dtChuQinTime,@nNeedRest,@dtArriveTime,@dtCallTime,@nDragType,@nKehuoID,@nPlanType,@nRemarkType,@nTrainmanTypeID,@strTrainJiaoluGUID,@strTrainTypeName,@dtStartTime,@dtFirstStartTime,@dtRealStartTime,@nPlanState,@strPlaceID,@strStartStation,@strEndStation,@strRemark,@strTrainNumber,@strCreateSiteGUID,@strCreateUserGUID"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@strTrainNo", SqlDbType.VarChar, 50), new SqlParameter("@dtChuQinTime", SqlDbType.DateTime), new SqlParameter("@dtArriveTime", SqlDbType.DateTime), new SqlParameter("@dtCallTime", SqlDbType.DateTime), new SqlParameter("@nDragType", SqlDbType.Int, 4), new SqlParameter("@nKehuoID", SqlDbType.Int, 4), new SqlParameter("@nNeedRest", SqlDbType.Int, 4), new SqlParameter("@nPlanType", SqlDbType.Int, 4), new SqlParameter("@nRemarkType", SqlDbType.Int, 4), new SqlParameter("@nTrainmanTypeID", SqlDbType.Int, 4), new SqlParameter("@strTrainJiaoluGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainTypeName", SqlDbType.VarChar, 50), new SqlParameter("@dtStartTime", SqlDbType.DateTime), new SqlParameter("@dtFirstStartTime", SqlDbType.DateTime), new SqlParameter("@dtRealStartTime", SqlDbType.DateTime), new SqlParameter("@nPlanState", SqlDbType.Int, 4), new SqlParameter("@strPlaceID", SqlDbType.VarChar, 50), new SqlParameter("@strStartStation", SqlDbType.VarChar, 50), new SqlParameter("@strEndStation", SqlDbType.VarChar, 50), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@strTrainNumber", SqlDbType.VarChar, 50), new SqlParameter("@strCreateSiteGUID", SqlDbType.VarChar, 50), new SqlParameter("@strCreateUserGUID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.strTrainNo; parameters[1].Value = model.dtChuQinTime; parameters[2].Value = model.dtArriveTime; parameters[3].Value = model.dtCallTime; parameters[4].Value = model.nDragType; parameters[5].Value = model.nKehuoID; parameters[6].Value = model.nNeedRest; parameters[7].Value = model.nPlanType; parameters[8].Value = model.nRemarkType; parameters[9].Value = model.nTrainmanTypeID; parameters[10].Value = model.strTrainJiaoluGUID; parameters[11].Value = model.strTrainTypeName; parameters[12].Value = model.dtStartTime; parameters[13].Value = model.dtFirstStartTime; parameters[14].Value = model.dtRealStartTime; parameters[15].Value = model.nPlanState; parameters[16].Value = model.strPlaceID; parameters[17].Value = model.strStartStation; parameters[18].Value = model.strEndStation; parameters[19].Value = model.strRemark; parameters[20].Value = model.strTrainNumber; parameters[21].Value = model.strCreateSiteGUID; parameters[22].Value = model.strCreateUserGUID; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(1); } else { return(0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.TAB_Plan_Train DataRowToModel(DataRow row) { TF.RunSafty.Model.TAB_Plan_Train model = new TF.RunSafty.Model.TAB_Plan_Train(); if (row != null) { if (row["nid"] != null && row["nid"].ToString() != "") { model.nid = int.Parse(row["nid"].ToString()); } if (row["strTrainPlanGUID"] != null) { model.strTrainPlanGUID = row["strTrainPlanGUID"].ToString(); } if (row["strTrainTypeName"] != null) { model.strTrainTypeName = row["strTrainTypeName"].ToString(); } if (row["strTrainNumber"] != null) { model.strTrainNumber = row["strTrainNumber"].ToString(); } if (row["strTrainNo"] != null) { model.strTrainNo = row["strTrainNo"].ToString(); } if (row["dtStartTime"] != null && row["dtStartTime"].ToString() != "") { model.dtStartTime = DateTime.Parse(row["dtStartTime"].ToString()); } if (row["dtRealStartTime"] != null && row["dtRealStartTime"].ToString() != "") { model.dtRealStartTime = DateTime.Parse(row["dtRealStartTime"].ToString()); } if (row["strTrainJiaoluGUID"] != null) { model.strTrainJiaoluGUID = row["strTrainJiaoluGUID"].ToString(); } if (row["strStartStation"] != null) { model.strStartStation = row["strStartStation"].ToString(); } if (row["strEndStation"] != null) { model.strEndStation = row["strEndStation"].ToString(); } if (row["nTrainmanTypeID"] != null && row["nTrainmanTypeID"].ToString() != "") { model.nTrainmanTypeID = int.Parse(row["nTrainmanTypeID"].ToString()); } if (row["nPlanType"] != null && row["nPlanType"].ToString() != "") { model.nPlanType = int.Parse(row["nPlanType"].ToString()); } if (row["nDragType"] != null && row["nDragType"].ToString() != "") { model.nDragType = int.Parse(row["nDragType"].ToString()); } if (row["nKehuoID"] != null && row["nKehuoID"].ToString() != "") { model.nKehuoID = int.Parse(row["nKehuoID"].ToString()); } if (row["nRemarkType"] != null && row["nRemarkType"].ToString() != "") { model.nRemarkType = int.Parse(row["nRemarkType"].ToString()); } if (row["strRemark"] != null) { model.strRemark = row["strRemark"].ToString(); } if (row["nPlanState"] != null && row["nPlanState"].ToString() != "") { model.nPlanState = int.Parse(row["nPlanState"].ToString()); } if (row["dtCreateTime"] != null && row["dtCreateTime"].ToString() != "") { model.dtCreateTime = DateTime.Parse(row["dtCreateTime"].ToString()); } if (row["strCreateSiteGUID"] != null) { model.strCreateSiteGUID = row["strCreateSiteGUID"].ToString(); } if (row["strCreateUserGUID"] != null) { model.strCreateUserGUID = row["strCreateUserGUID"].ToString(); } if (row["dtFirstStartTime"] != null && row["dtFirstStartTime"].ToString() != "") { //model.dtFirstStartTime=DateTime.Parse(row["dtFirstStartTime"].ToString()); DateTime dtFirstStartTime; if (DateTime.TryParse(row["dtFirstStartTime"].ToString(), out dtFirstStartTime)) { model.dtFirstStartTime = dtFirstStartTime; } } if (row["dtChuQinTime"] != null && row["dtChuQinTime"].ToString() != "") { model.dtChuQinTime = DateTime.Parse(row["dtChuQinTime"].ToString()); } if (row["nNeedRest"] != null && row["nNeedRest"].ToString() != "") { model.nNeedRest = int.Parse(row["nNeedRest"].ToString()); } if (row["dtArriveTime"] != null && row["dtArriveTime"].ToString() != "") { model.dtArriveTime = DateTime.Parse(row["dtArriveTime"].ToString()); } if (row["dtCallTime"] != null && row["dtCallTime"].ToString() != "") { model.dtCallTime = DateTime.Parse(row["dtCallTime"].ToString()); } if (row["strBak1"] != null) { model.strBak1 = row["strBak1"].ToString(); } if (row["dtLastArriveTime"] != null && row["dtLastArriveTime"].ToString() != "") { //model.dtLastArriveTime=DateTime.Parse(row["dtLastArriveTime"].ToString()); DateTime dtLastArriveTime; if (DateTime.TryParse(row["dtLastArriveTime"].ToString(), out dtLastArriveTime)) { model.dtLastArriveTime = dtLastArriveTime; } } if (row["strMainPlanGUID"] != null) { model.strMainPlanGUID = row["strMainPlanGUID"].ToString(); } if (row["strPlaceID"] != null) { model.strPlaceID = row["strPlaceID"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(TF.RunSafty.Model.TAB_Plan_Train model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TAB_Plan_Train set "); strSql.Append("strTrainTypeName=@strTrainTypeName,"); strSql.Append("strTrainNumber=@strTrainNumber,"); strSql.Append("strTrainNo=@strTrainNo,"); strSql.Append("dtRealStartTime=@dtRealStartTime,"); strSql.Append("strTrainJiaoluGUID=@strTrainJiaoluGUID,"); strSql.Append("strStartStation=@strStartStation,"); strSql.Append("strEndStation=@strEndStation,"); strSql.Append("nTrainmanTypeID=@nTrainmanTypeID,"); strSql.Append("nPlanType=@nPlanType,"); strSql.Append("nDragType=@nDragType,"); strSql.Append("nKehuoID=@nKehuoID,"); strSql.Append("nRemarkType=@nRemarkType,"); strSql.Append("strRemark=@strRemark,"); strSql.Append("dtCreateTime=@dtCreateTime,"); strSql.Append("strCreateSiteGUID=@strCreateSiteGUID,"); strSql.Append("strCreateUserGUID=@strCreateUserGUID,"); strSql.Append("dtFirstStartTime=@dtFirstStartTime,"); strSql.Append("dtChuQinTime=@dtChuQinTime,"); strSql.Append("nNeedRest=@nNeedRest,"); strSql.Append("dtArriveTime=@dtArriveTime,"); strSql.Append("dtCallTime=@dtCallTime,"); strSql.Append("strBak1=@strBak1,"); strSql.Append("dtLastArriveTime=@dtLastArriveTime,"); strSql.Append("strMainPlanGUID=@strMainPlanGUID,"); strSql.Append("strPlaceID=@strPlaceID"); strSql.Append(" where nid=@nid"); SqlParameter[] parameters = { new SqlParameter("@strTrainTypeName", SqlDbType.VarChar, 50), new SqlParameter("@strTrainNumber", SqlDbType.VarChar, 50), new SqlParameter("@strTrainNo", SqlDbType.VarChar, 50), new SqlParameter("@dtRealStartTime", SqlDbType.DateTime), new SqlParameter("@strTrainJiaoluGUID", SqlDbType.VarChar, 50), new SqlParameter("@strStartStation", SqlDbType.VarChar, 50), new SqlParameter("@strEndStation", SqlDbType.VarChar, 50), new SqlParameter("@nTrainmanTypeID", SqlDbType.Int, 4), new SqlParameter("@nPlanType", SqlDbType.Int, 4), new SqlParameter("@nDragType", SqlDbType.Int, 4), new SqlParameter("@nKehuoID", SqlDbType.Int, 4), new SqlParameter("@nRemarkType", SqlDbType.Int, 4), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@dtCreateTime", SqlDbType.DateTime), new SqlParameter("@strCreateSiteGUID", SqlDbType.VarChar, 50), new SqlParameter("@strCreateUserGUID", SqlDbType.VarChar, 50), new SqlParameter("@dtFirstStartTime", SqlDbType.DateTime), new SqlParameter("@dtChuQinTime", SqlDbType.DateTime), new SqlParameter("@nNeedRest", SqlDbType.Int, 4), new SqlParameter("@dtArriveTime", SqlDbType.DateTime), new SqlParameter("@dtCallTime", SqlDbType.DateTime), new SqlParameter("@strBak1", SqlDbType.VarChar, 50), new SqlParameter("@dtLastArriveTime", SqlDbType.DateTime), new SqlParameter("@strMainPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strPlaceID", SqlDbType.VarChar, 50), new SqlParameter("@nid", SqlDbType.Int, 4), new SqlParameter("@strTrainPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@dtStartTime", SqlDbType.DateTime), new SqlParameter("@nPlanState", SqlDbType.Int, 4) }; parameters[0].Value = model.strTrainTypeName; parameters[1].Value = model.strTrainNumber; parameters[2].Value = model.strTrainNo; parameters[3].Value = model.dtRealStartTime; parameters[4].Value = model.strTrainJiaoluGUID; parameters[5].Value = model.strStartStation; parameters[6].Value = model.strEndStation; parameters[7].Value = model.nTrainmanTypeID; parameters[8].Value = model.nPlanType; parameters[9].Value = model.nDragType; parameters[10].Value = model.nKehuoID; parameters[11].Value = model.nRemarkType; parameters[12].Value = model.strRemark; parameters[13].Value = model.dtCreateTime; parameters[14].Value = model.strCreateSiteGUID; parameters[15].Value = model.strCreateUserGUID; parameters[16].Value = model.dtFirstStartTime; parameters[17].Value = model.dtChuQinTime; parameters[18].Value = model.nNeedRest; parameters[19].Value = model.dtArriveTime; parameters[20].Value = model.dtCallTime; parameters[21].Value = model.strBak1; parameters[22].Value = model.dtLastArriveTime; parameters[23].Value = model.strMainPlanGUID; parameters[24].Value = model.strPlaceID; parameters[25].Value = model.nid; parameters[26].Value = model.strTrainPlanGUID; parameters[27].Value = model.dtStartTime; parameters[28].Value = model.nPlanState; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }