public bool AddTransmitConfig(Model_TransmitConfig model) { string newGUID = Guid.NewGuid().ToString(); string strSql = @"insert into [TAB_System_TransmitConfig] ([strWorkShopGUID],[nPost]) values (@strWorkShopGUID,@nPost)"; SqlParameter[] sqlParams = { new SqlParameter("strWorkShopGUID", model.strWorkShopGUID), new SqlParameter("nPost", model.nPost) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0); }
public bool UpdateTransmitConfig(Model_TransmitConfig model) { string newGUID = Guid.NewGuid().ToString(); string strSql = @"update TAB_System_TransmitConfig set strWorkShopGUID=@strWorkShopGUID,nPost=@nPost where nid=@nid"; SqlParameter[] sqlParams = { new SqlParameter("strWorkShopGUID", SqlDbType.VarChar, 50, model.strWorkShopGUID), new SqlParameter("@nPost", model.nPost), new SqlParameter("nid", model.nId) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0); }