C# XYECOM类代码示例

    protected override void InitPageValue(XYECOM.Web.BasePage.MyDictionary table)
    {
        string type = table["XY"].ToLower();
        if ("BrandPageList".ToLower() == type)
        {
            this.tbpagenum.Text = table["调用数量"];
            this.tbpagetitlenum.Text = table["标题字数"];
            this.ddlpageorder.SelectedValue = table["排序字段"];
            this.ddlpagedesc.SelectedValue = table["排序方式"];
            this.ddlpagedatetype.SelectedValue = table["日期格式"];
            this.tbpageproductnum.Text = table["品牌描述显示字数"];
            this.tbpagecorporationnum.Text = table["公司名称字数"];

            ClientScript.RegisterStartupScript(GetType(), "page", "myclick(\"li_page\",\"click\");", true);
        }
        if ("BrandList".ToLower() == type)
        {
            this.hidptid.Value = table["信息类别"];
            this.tbnum.Text = table["调用数量"];
            this.tbtitlenum.Text = table["标题字数"];
            this.tbclicknum.Text = table["点击次数"];
            this.ddlorderColumuName.SelectedValue = table["排序字段"];
            this.ddlorder.SelectedValue = table["排序方式"];
            this.chkUserGradeOrder.Checked = (table["优先以会员等级排序"] == "1");
            this.ddldatetype.SelectedValue = table["日期格式"];
            this.tbinfonum.Text = table["品牌描述显示字数"];
            this.tbcorporationNum.Text = table["公司名称字数"];
            this.ddlCommend.SelectedValue = table["是否推荐"];
            this.ddlimg.SelectedValue = table["是否显示缩略图"];

            ClientScript.RegisterStartupScript(GetType(), "page", "myclick(\"li_base\",\"click\");", true);
        }
    }

        /// <summary>
        /// ��ȡ������ı�ʶ����
        /// </summary>
        /// <returns>������ı�ʾ����</returns>
        public static string GetDescTableName(XYECOM.Model.AttachmentItem item)
        {
            if (item == XYECOM.Model.AttachmentItem.Exhibition) return "i_showinfo";
            if (item == XYECOM.Model.AttachmentItem.Individual) return "u_individual";
            if (item == XYECOM.Model.AttachmentItem.Investment) return "i_invitebusinessmaninfo";
            if (item == XYECOM.Model.AttachmentItem.Venture) return "i_demand";
            if (item == XYECOM.Model.AttachmentItem.News) return "n_news";
            if (item == XYECOM.Model.AttachmentItem.Service) return "i_serviceinfo";
            if (item == XYECOM.Model.AttachmentItem.Supply) return "i_supply";
            if (item == XYECOM.Model.AttachmentItem.Topic) return "xy_topic";
            if (item == XYECOM.Model.AttachmentItem.User) return "u_user";
            if (item == XYECOM.Model.AttachmentItem.Certificate) return "U_Certificate";
            if (item == XYECOM.Model.AttachmentItem.FriendLink) return "b_FriendLink";
            if (item == XYECOM.Model.AttachmentItem.Banner) return "u_banner";
            if (item == XYECOM.Model.AttachmentItem.Logo) return "u_logo";
            if (item == XYECOM.Model.AttachmentItem.PartLabel) return "xy_partlabel";
            if (item == XYECOM.Model.AttachmentItem.BaikeImg) return "baike";
            if (item == XYECOM.Model.AttachmentItem.Gift) return "xy_gift";
            if (item == XYECOM.Model.AttachmentItem.ClassAds) return "XY_ClassAds";
            if (item == XYECOM.Model.AttachmentItem.CustomRanking) return "xy_rankinguserinfo";
            if (item == XYECOM.Model.AttachmentItem.xy_userbrand) return "xy_userbrand";
            if (item == XYECOM.Model.AttachmentItem.XY_Brand) return "xy_brand";
            if (item == XYECOM.Model.AttachmentItem.UserVideo) return "Video";
            if (item == XYECOM.Model.AttachmentItem.Slides) return "Slides";
            if (item == XYECOM.Model.AttachmentItem.TeamBuy) return "TeamBuy";
            if (item == XYECOM.Model.AttachmentItem.ForeclosedInfo) return "ForeclosedInfo";
            if (item == XYECOM.Model.AttachmentItem.CreditInfo) return "CreditInfo";

            return "";
        }

        protected override void InitPageValue(XYECOM.Web.BasePage.MyDictionary table)
        {
            string type = table["XY"].ToLower();
            if ("UserNewsList".ToLower() == type)
            {
                this.hdgetid.Value = table["资讯栏目"];
                this.tbnum.Text = table["调用数量"];
                this.tbtitlenum.Text = table["标题字数"];
                this.tbclicknum.Text = table["点击次数"];
                this.ddlorderColumuName.SelectedValue = table["排序字段"];
                this.ddlorder.SelectedValue = table["排序方式"];
                this.ddldatetype.SelectedValue = table["日期格式"];
                this.ddlCommend.SelectedValue = table["是否推荐"];
                this.tbcontentnum.Text = table["导读显示字数"];
                //this.ddlimg.SelectedValue = table["是否为图片资讯"];
                //this.rbtcobyes.Checked

                ClientScript.RegisterStartupScript(GetType(), "base", "myclick(\"li_base\",\"click\");", true);

            }
            if ("UserNewsPageList".ToLower() == type)
            {
                this.tbpagenum.Text = table["调用数量"];
                tbpagetitlenum.Text = table["标题字数"];
                ddlpagedatetype.SelectedValue = table["日期格式"];
                ddlpageorder.SelectedValue = table["排序字段"];
                ddlpagedesc.SelectedValue = table["排序方式"];
                tbpageproductnum.Text = table["导读显示字数"];
                ClientScript.RegisterStartupScript(GetType(), "page", "myclick(\"li_page\",\"click\");", true);
            }
        }

        /// <summary>
        /// ����֤����Ϣ
        /// </summary>
        /// <param name="Cet"></param>
        /// <param name="CE_ID">id</param>
        /// <returns></returns>
        public int Insert(XYECOM.Model.CertificateInfo info, out long ceInfoid)
        {
            SqlParameter[] Parame = new SqlParameter[]
            {
                new SqlParameter("@CE_ID",SqlDbType.BigInt),
                new SqlParameter("@U_ID",info.U_ID),
                new SqlParameter("@CE_Name",info.CE_Name),
                new SqlParameter("@CE_Organ",info.CE_Organ),
                new SqlParameter("@CE_Begin",info.CE_Begin),
                new SqlParameter("@CE_Upto",info.CE_Upto),
                new SqlParameter("@CE_Type",info.CE_Type),
                new SqlParameter("@CE_Isopen",info.CE_Isopen)

            };
               Parame[0].Direction = ParameterDirection.Output;

               int rowAffected = XYECOM.Core.Data.SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure,"XYP_InsertCertificate", Parame);

               if (rowAffected >= 0)
               {
               if (Parame[0].Value != null && Parame[0].Value.ToString() != "")
                   ceInfoid = (long)Parame[0].Value;
               else
                   ceInfoid = 0;
               }
               else
               {
               ceInfoid = -1;
               }

               return rowAffected;
        }

        /// <summary>
        /// 审核临时词条
        /// </summary>
        /// <param name="tmpInfo">待审核的临时词条</param>
        /// <returns>返回影响行数</returns>
        public int CheckUpLemma(XYECOM.Model.TmpLemmaInfo tmpInfo)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                    new SqlParameter("@LemmaTmpId",tmpInfo.LemmaTmpId),
                    new SqlParameter("@LemmaId",tmpInfo.LemmaId),
                    new SqlParameter("@LemmaName",tmpInfo.LemmaName),
                    new SqlParameter("@Reference",tmpInfo.Reference),
                    new SqlParameter("@LemmaCategory",tmpInfo.LemmaCategory),
                    new SqlParameter("@ExtendRead",tmpInfo.ExtendRead),
                    new SqlParameter("@LemmaStatus",tmpInfo.LemmaStatus),
                    new SqlParameter("@Creator",tmpInfo.Creator),
                    new SqlParameter("@CreateTime",tmpInfo.CreateTime),
                    new SqlParameter("@Synonyms",tmpInfo.Synonyms),
                    new SqlParameter("@EnName",tmpInfo.EnName),
                    new SqlParameter("@FailReason",tmpInfo.FailReason),
                    new SqlParameter("@FailTime",tmpInfo.FailTime),
                    new SqlParameter("@PassTime",tmpInfo.PassTime),
                    new SqlParameter("@ModiyDate",tmpInfo.ModiyDate),
                    new SqlParameter("@Content",tmpInfo.Content),
                    new SqlParameter("@Modifier",tmpInfo.Modifier),
                    new SqlParameter("@ModifyReason",tmpInfo.ModifyReason),
                    new SqlParameter("@BrowseTimes",tmpInfo.BrowseTimes),
                    new SqlParameter("@EditTimes",tmpInfo.EditTimes)
            };

            return XYECOM.Core.Data.SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_CheckUpLemma", param);
        }

 /// <summary>
 /// ���
 /// </summary>
 /// <param name="ei">ʵ�����</param>
 /// <returns>-3��ʾ�����Ѿ������</returns>
 public int Insert(XYECOM.Model.UserInputMoneyInfo ei)
 {
     if (!DAL.CheckOrder(ei.OrderID,ei.U_ID))
         return DAL.Insert(ei);
     else
         return -3;
 }

        protected override void InitPageValue(XYECOM.Web.BasePage.MyDictionary table)
        {
            string type = table["XY"].ToLower();
            if ("TeamBuyList".ToLower() == type)
            {
                tbnum.Text = table["调用数量"];
                tbtitlenum.Text = table["标题字数"];
                ddlOrderColumuName.SelectedValue = table["排序字段"];
                ddlOrderType.SelectedValue = table["排序方式"];
                ddldatetype.SelectedValue = table["日期格式"];
                tbinfonum.Text = table["信息描述字数"];
                ddlIsPlat.SelectedValue = table["是否是平台团购"];
                this.ddlCommend.SelectedValue = table["是否推荐"];
                this.ddlUserCommend.SelectedValue = table["是否用户推荐"];

                ClientScript.RegisterStartupScript(GetType(), "base", "myclick(\"li_base\",\"click\");", true);
            }
            if ("TeamBuyPageList".ToLower() == type)
            {
                this.tbpagenum.Text = table["调用数量"];
                tbpagetitlenum.Text = table["标题字数"];
                ddlPageOrderColumnName.SelectedValue = table["排序字段"];
                ddlPageOrderType.SelectedValue = table["排序方式"];
                ddlIsPlat1.SelectedValue = table["是否是平台团购"];
                ddlpagedatetype.SelectedValue = table["日期格式"];
                tbpageproductnum.Text = table["信息描述字数"];
                ClientScript.RegisterStartupScript(GetType(), "page", "myclick(\"li_page\",\"click\");", true);
            }
        }

 /// <summary>
 /// ���¾�·
 /// </summary>
 /// <param name="userdata">���ݶ���</param>
 /// <returns>Ӱ������</returns>
 public int Update(XYECOM.Model.UserData userdata)
 {
     SqlParameter[] parm = new SqlParameter[]
     {
         new SqlParameter("@uid",userdata.Uid),
         new SqlParameter("@companyids",userdata.Companyids)
     };
     return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_UpdateUserData", parm);
 }

 /// <summary>
 /// ����һ�����߸���һ����վ���������
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public int InsertAndUpdate(XYECOM.Model.UserAnnounceInfo info)
 {
     SqlParameter[] parm = new SqlParameter[]
     {
         new SqlParameter("@Centent",info.Centent),
         new SqlParameter("@UserID",info.UserID)
     };
     return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_InsertAndUpdateUserAnnounce", parm);
 }

        /// <summary>
        /// 插入记录
        /// </summary>
        /// <param name="et">数据对象</param>
        /// <returns>受影响行数</returns>
        public int Insert(XYECOM.Model.FinanceTypeInfo et)
        {
            SqlParameter[] parm = new SqlParameter[]
            {
                new  SqlParameter ("@FT_Type",et .FT_Type )
            };

            return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_InsertFinanceType", parm);
        }

 /// <summary>
 /// ��Ӽӹ���Ϣ
 /// </summary>
 /// <param name="info">ʵ����</param>
 /// <returns>��Ӱ�������</returns>
 public int Insert(XYECOM.Model.DemandInfo info, out int infoId)
 {
     infoId = 0;
     if (info == null)
     {
         return 0;
     }
     return DAL.Insert(info, out infoId);
 }

        /// <summary>
        /// ��ӽ�ɫ
        /// </summary>
        /// <param name="er">ʵ����</param>
        /// <returns>��Ӱ�������</returns>
        public int Insert(XYECOM.Model.RoleInfo er)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@value",er.UR_Name),
                new SqlParameter("@TableName","b_Role")
            };

            return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_InsertRole", param);
        }

        /// <summary>
        ///  添加新闻栏目信息
        /// </summary>
        /// <param name="nt">实体类NewsTitles</param>
        /// <param name="nt_id">所添加的新闻栏目的ID值</param>
        /// <returns>数字，大于或等于0表示添加成功</returns>
        public int Insert(XYECOM.Model.User.UserNewsTitleInfo info, out int nt_id)
        {
            if (info == null)
            {
                nt_id = 0;
                return 0;
            }

            return DAL.Insert(info, out nt_id);
        }

        /// <summary>
        /// �޸�ָ����������Դ��Ϣ
        /// </summary>
        /// <param name="no">Ҫ�޸ĵ�������Դ��Ϣ����</param>
        /// <returns>���֣����ڻ����0���޸ijɹ�</returns>
        public int Update(XYECOM.Model.NewsOriginInfo no)
        {
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@NO_ID",no.NO_ID),
                new SqlParameter("@NO_Name",no.NO_Name)
            };

            return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "XYP_UpdateNewsOrigin", param);
        }

 /// <summary>
 /// 插入信息
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public int Insert(XYECOM.Model.SupplyBuyInfo info)
 {
     int num = 0;
     string sql =string.Format(@"insert into i_SupplyBuy
                             (Uid,Title,KeyWord,Contetns,[Name],Tel,AuditingState,Emergency,BuyNum,Area_ID)
                              values ({0},'{1}','{2}','{3}','{4}','{5}',{6},{7},{8},{9})"
                             , info.Uid,info.Title,info.KeyWord,info.Contents,info.U_name,info.Tel,info.State,info.Emergency,info.BuyNum,info.Area_id);
     num = XYECOM.Core.Data.SqlHelper.ExecuteNonQuery(sql);
     return num;
 }