/// <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())));
}
