public ResourcePTModel GetPriceTypeSolidModel(string rptId)
{
ResourcePTModel model = new ResourcePTModel();
DataTable list = ResourcePTAction.GetList(rptId);
if (list.Rows.Count > 0)
{
if (list.Rows[0]["rptid"].ToString() != "")
{
model.rptId = list.Rows[0]["rptid"].ToString();
}
if (list.Rows[0]["rptcode"].ToString() != "")
{
model.rptCode = list.Rows[0]["rptcode"].ToString();
}
if (list.Rows[0]["rptname"].ToString() != "")
{
model.rptName = list.Rows[0]["rptname"].ToString();
}
if (list.Rows[0]["rptexplain"].ToString() != "")
{
model.rptExplain = list.Rows[0]["rptexplain"].ToString();
}
if (list.Rows[0]["rptisshow"].ToString() != "")
{
model.rptIsShow = list.Rows[0]["rptisshow"].ToString();
}
}
return(model);
}
public int Update(ResourcePTModel model)
{
int num = 0;
if (model.rptId != "")
{
num = ResourcePTAction.Update(model);
}
return(num);
}
public int Add(ResourcePTModel model)
{
int num = 0;
if (model.rptId != "")
{
num = ResourcePTAction.Add(model);
}
return(num);
}
public static int Add(ResourcePTModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Sm_Resource_PriceType(rptid,rptcode,rptname,rptexplain,rptisshow) ");
builder.Append("values(@rptid,@rptcode,@rptname,@rptexplain,@rptIsShow) ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@rptid", SqlDbType.NVarChar, 50), new SqlParameter("@rptcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@rptname", SqlDbType.NVarChar, 0x80), new SqlParameter("@rptexplain", SqlDbType.NVarChar, 0x400), new SqlParameter("@rptIsShow", SqlDbType.Int), new SqlParameter("@IsDefault", SqlDbType.Int) };
commandParameters[0].Value = model.rptId;
commandParameters[1].Value = model.rptCode;
commandParameters[2].Value = model.rptName;
commandParameters[3].Value = model.rptExplain;
commandParameters[4].Value = model.rptIsShow;
commandParameters[5].Value = model.IsDefault;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
