/// <summary> /// 实体转换 /// <summary> private static WE_Project.Model.EPConfig TranEntity(DataRow dr) { if (dr != null) { WE_Project.Model.EPConfig model = new WE_Project.Model.EPConfig(); if (!string.IsNullOrEmpty(dr["EPState"].ToString())) { model.EPState = bool.Parse(dr["EPState"].ToString()); } if (!string.IsNullOrEmpty(dr["EPTimeOut"].ToString())) { model.EPTimeOut = int.Parse(dr["EPTimeOut"].ToString()); } if (!string.IsNullOrEmpty(dr["EPTimeOutCount"].ToString())) { model.EPTimeOutCount = int.Parse(dr["EPTimeOutCount"].ToString()); } if (!string.IsNullOrEmpty(dr["EPTimeOutJXCount"].ToString())) { model.EPTimeOutJXCount = int.Parse(dr["EPTimeOutJXCount"].ToString()); } model.EPJYMAgencyTypeStr = dr["EPJYMAgencyTypeStr"].ToString(); if (!string.IsNullOrEmpty(dr["EPStartTime"].ToString())) { model.EPStartTime = DateTime.Parse(dr["EPStartTime"].ToString()); } if (!string.IsNullOrEmpty(dr["EPEndTime"].ToString())) { model.EPEndTime = DateTime.Parse(dr["EPEndTime"].ToString()); } if (!string.IsNullOrEmpty(dr["EPJYType"].ToString())) { model.EPJYType = int.Parse(dr["EPJYType"].ToString()); } if (!string.IsNullOrEmpty(dr["EPJYMinMoney"].ToString())) { model.EPJYMinMoney = int.Parse(dr["EPJYMinMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["EPJYBaseMoney"].ToString())) { model.EPJYBaseMoney = int.Parse(dr["EPJYBaseMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["EPTakeOffMoney"].ToString())) { model.EPTakeOffMoney = decimal.Parse(dr["EPTakeOffMoney"].ToString()); } model.EPMoneyStr = dr["EPMoneyStr"].ToString(); model.EPProtocol = dr["EPProtocol"].ToString(); model.EPMoneyType = dr["EPMoneyType"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(WE_Project.Model.EPConfig model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update EPConfig set "); strSql.Append(" EPState = @EPState , "); strSql.Append(" EPTimeOut = @EPTimeOut , "); strSql.Append(" EPTimeOutCount = @EPTimeOutCount , "); strSql.Append(" EPTimeOutJXCount = @EPTimeOutJXCount , "); strSql.Append(" EPJYMAgencyTypeStr = @EPJYMAgencyTypeStr , "); strSql.Append(" EPStartTime = @EPStartTime , "); strSql.Append(" EPEndTime = @EPEndTime , "); strSql.Append(" EPJYType = @EPJYType , "); strSql.Append(" EPJYMinMoney = @EPJYMinMoney , "); strSql.Append(" EPJYBaseMoney = @EPJYBaseMoney , "); strSql.Append(" EPMoneyStr = @EPMoneyStr , "); strSql.Append(" EPProtocol = @EPProtocol , "); strSql.Append(" EPMoneyType = @EPMoneyType, "); strSql.Append(" EPTakeOffMoney = @EPTakeOffMoney "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@EPState", SqlDbType.Bit, 1), new SqlParameter("@EPTimeOut", SqlDbType.Int, 4), new SqlParameter("@EPTimeOutCount", SqlDbType.Int, 4), new SqlParameter("@EPTimeOutJXCount", SqlDbType.Int, 4), new SqlParameter("@EPJYMAgencyTypeStr", SqlDbType.VarChar, 100), new SqlParameter("@EPStartTime", SqlDbType.DateTime), new SqlParameter("@EPEndTime", SqlDbType.DateTime), new SqlParameter("@EPJYType", SqlDbType.Int, 4), new SqlParameter("@EPJYMinMoney", SqlDbType.Int, 4), new SqlParameter("@EPJYBaseMoney", SqlDbType.Int, 4), new SqlParameter("@EPMoneyStr", SqlDbType.VarChar, 100), new SqlParameter("@EPProtocol", SqlDbType.Text), new SqlParameter("@EPMoneyType", SqlDbType.VarChar, 50), new SqlParameter("@EPTakeOffMoney", SqlDbType.Decimal) }; parameters[0].Value = model.EPState; parameters[1].Value = model.EPTimeOut; parameters[2].Value = model.EPTimeOutCount; parameters[3].Value = model.EPTimeOutJXCount; parameters[4].Value = model.EPJYMAgencyTypeStr; parameters[5].Value = model.EPStartTime; parameters[6].Value = model.EPEndTime; parameters[7].Value = model.EPJYType; parameters[8].Value = model.EPJYMinMoney; parameters[9].Value = model.EPJYBaseMoney; parameters[10].Value = model.EPMoneyStr; parameters[11].Value = model.EPProtocol; parameters[12].Value = model.EPMoneyType; parameters[13].Value = model.EPTakeOffMoney; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
public static bool Update(WE_Project.Model.EPConfig model) { return(WE_Project.DAL.EPConfig.Update(model)); }
public static Hashtable Update(WE_Project.Model.EPConfig model, Hashtable MyHs) { return(WE_Project.DAL.EPConfig.Update(model, MyHs)); }
public static bool Insert(WE_Project.Model.EPConfig model) { return(WE_Project.DAL.EPConfig.Insert(model)); }
public static Hashtable Insert(WE_Project.Model.EPConfig model, Hashtable MyHs) { return(WE_Project.DAL.EPConfig.Insert(model, MyHs)); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(WE_Project.Model.EPConfig model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }