public int AddApplyCity(PDT_StandardPrice_ApplyCity m)
{
#region 设置参数集
SqlParameter[] prams =
{
SQLDatabase.MakeInParam("@StandardPrice", SqlDbType.Int, 4, HeadID),
SQLDatabase.MakeInParam("@OrganizeCity", SqlDbType.Int, 4, m.OrganizeCity),
SQLDatabase.MakeInParam("@ExtPropertys", SqlDbType.VarChar, 4000, CombineExtProperty(m.ExtPropertys, m.ModelName))
};
#endregion
m.ID = SQLDatabase.RunProc(_ProcePrefix + "_AddApplyCity", prams);
return(m.ID);
}
public PDT_StandardPrice_ApplyCity GetApplyCityDetailModel(int detailid)
{
SqlDataReader dr = null;
SqlParameter[] parameters =
{
SQLDatabase.MakeInParam("@DetailID", SqlDbType.Int, 4, detailid)
};
SQLDatabase.RunProc(_ProcePrefix + "_GetApplyCityDetailModel", parameters, out dr);
PDT_StandardPrice_ApplyCity m = default(PDT_StandardPrice_ApplyCity);
if (dr.Read())
{
m = FillApplyCityModel(dr);
}
dr.Close();
return(m);
}
private PDT_StandardPrice_ApplyCity FillApplyCityModel(IDataReader dr)
{
PDT_StandardPrice_ApplyCity m = new PDT_StandardPrice_ApplyCity();
if (!string.IsNullOrEmpty(dr["ID"].ToString()))
{
m.ID = (int)dr["ID"];
}
if (!string.IsNullOrEmpty(dr["StandardPrice"].ToString()))
{
m.StandardPrice = (int)dr["StandardPrice"];
}
if (!string.IsNullOrEmpty(dr["OrganizeCity"].ToString()))
{
m.OrganizeCity = (int)dr["OrganizeCity"];
}
if (!string.IsNullOrEmpty(dr["ExtPropertys"].ToString()))
{
m.ExtPropertys = SpiltExtProperty(m.ModelName, (string)dr["ExtPropertys"]);
}
return(m);
}
public int UpdateApplyCity(PDT_StandardPrice_ApplyCity m)
{
return(_dal.UpdateApplyCity(m));
}
public int AddApplyCity(PDT_StandardPrice_ApplyCity m)
{
return(_dal.AddApplyCity(m));
}
