Ejemplo n.º 1
0
        public bool InfoFavoriteOrgInsert(Tz888.Model.CollectionModel model)
        {
            bool bl = true;
            int  rowsAffected;

            SqlParameter[] parameters =
            {
                new SqlParameter("@LoginName",        SqlDbType.Char,     16),
                new SqlParameter("@IndustryBID",      SqlDbType.Char,     10),
                new SqlParameter("@ContactLoginName", SqlDbType.Char,     16),
                new SqlParameter("@CollectOrgType",   SqlDbType.TinyInt,   1),
                new SqlParameter("@CollectOrgName",   SqlDbType.VarChar, 100),
                new SqlParameter("@CountryCode",      SqlDbType.Char,     10),
                new SqlParameter("@ProvinceID",       SqlDbType.Char,     10),
                new SqlParameter("@CityID",           SqlDbType.Char,     10),
                new SqlParameter("@CountyID",         SqlDbType.Char,     10),
                new SqlParameter("@Remrk",            SqlDbType.VarChar, 200)
            };
            parameters[0].Value = model.LoginName;
            parameters[1].Value = model.IndustryBID;
            parameters[2].Value = model.ContactLoginName;
            parameters[3].Value = model.CollectOrgType;
            parameters[4].Value = model.CollectOrgName;
            parameters[5].Value = model.CountryCode;
            parameters[6].Value = model.ProvinceID;
            parameters[7].Value = model.CityID;
            parameters[8].Value = model.CountyID;
            parameters[9].Value = model.Remrk;

            try
            {
                DbHelperSQL.RunProcedure("UP_OrgCollectionTab_ADD", parameters, out rowsAffected);
            }
            catch
            {
                bl = false;
            }
            return(bl);
        }
Ejemplo n.º 2
0
 public bool InfoFavoriteOrgInsert(Tz888.Model.CollectionModel model)
 {
     return(dal.InfoFavoriteOrgInsert(model));
 }