/// <summary> /// 更新一条数据 /// </summary> public bool Update(IndustryTypeModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update industryTypetab set "); strSql.Append("industryName=@industryName,"); strSql.Append("CheckiD=@CheckiD,"); strSql.Append("classID=@classID,"); strSql.Append("Desciption=@Desciption"); strSql.Append(" where industryID=@industryID"); SqlParameter[] parameters = { new SqlParameter("@industryID", SqlDbType.Int, 4), new SqlParameter("@industryName", SqlDbType.VarChar, 50), new SqlParameter("@CheckiD", SqlDbType.Int, 4), new SqlParameter("@classID", SqlDbType.Int, 4), new SqlParameter("@Desciption", SqlDbType.VarChar, 2000) }; parameters[0].Value = model.industryID; parameters[1].Value = model.industryName; parameters[2].Value = model.CheckiD; parameters[3].Value = model.classID; parameters[4].Value = model.desc; int rows = Tz888.DBUtility.DBHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IndustryTypeModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into industryTypetab("); strSql.Append("industryName,CheckiD,classID,Desciption)"); strSql.Append(" values ("); strSql.Append("@industryName,@CheckiD,@classID,@Desciption)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@industryName", SqlDbType.VarChar, 50), new SqlParameter("@CheckiD", SqlDbType.Int, 4), new SqlParameter("@classID", SqlDbType.Int, 4), new SqlParameter("@Desciption", SqlDbType.VarChar, 2000) }; parameters[0].Value = model.industryName; parameters[1].Value = model.CheckiD; parameters[2].Value = model.classID; parameters[3].Value = model.desc; object obj = Tz888.DBUtility.DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IndustryTypeModel GetModel(int industryID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 industryID,industryName,Desciption,CheckiD,classID from industryTypetab "); strSql.Append(" where industryID=@industryID"); SqlParameter[] parameters = { new SqlParameter("@industryID", SqlDbType.Int, 4) }; parameters[0].Value = industryID; IndustryTypeModel model = new IndustryTypeModel(); DataSet ds = Tz888.DBUtility.DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["industryID"].ToString() != "") { model.industryID = int.Parse(ds.Tables[0].Rows[0]["industryID"].ToString()); } if (ds.Tables[0].Rows[0]["Desciption"].ToString() != "") { model.desc = ds.Tables[0].Rows[0]["Desciption"].ToString(); } model.industryName = ds.Tables[0].Rows[0]["industryName"].ToString(); if (ds.Tables[0].Rows[0]["CheckiD"].ToString() != "") { model.CheckiD = int.Parse(ds.Tables[0].Rows[0]["CheckiD"].ToString()); } if (ds.Tables[0].Rows[0]["classID"].ToString() != "") { model.classID = int.Parse(ds.Tables[0].Rows[0]["classID"].ToString()); } return(model); } else { return(null); } }