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