C# XBase类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中XBase类的典型用法代码示例。如果您正苦于以下问题：C# XBase类的具体用法？C# XBase怎么用？C# XBase使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

XBase类属于命名空间，在下文中一共展示了XBase类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Update

 public static int Update(XBase.Model.Office.SellReport.UserProductInfo model)
 {
     int num = 0;
     string sqlstr = "update officedba.UserProductInfo set [email protected],[email protected],[email protected],[email protected],[email protected] where [email protected]";
     TransactionManager tran = new TransactionManager();
     tran.BeginTransaction();
     SqlParameter[] param = {
                                new SqlParameter("@CompanyCD",SqlDbType.VarChar,50),
                                new SqlParameter("@productNum",SqlDbType.VarChar,50),
                                new SqlParameter("@productName",SqlDbType.VarChar,200),
                                new SqlParameter("@price",SqlDbType.Decimal),
                                new SqlParameter("@bref",SqlDbType.VarChar,500),
                                new SqlParameter("@memo",SqlDbType.VarChar,1000),
                                new SqlParameter("@id",SqlDbType.Int,4)
                            };
     param[0].Value = model.CompanyCD;
     param[1].Value = model.productNum;
     param[2].Value = model.productName;
     param[3].Value = model.price;
     param[4].Value = model.bref;
     param[5].Value = model.memo;
     param[6].Value = model.id;
     try
     {
         num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr, param);
         tran.Commit();
     }
     catch
     {
         tran.Rollback();
     }
     return num;
 }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:33，代码来源:UserProjectInfoDBHelper.cs

示例2: GetProessList

        public static DataTable GetProessList(string projectid,string summaryid, XBase.Common.UserInfoUtil userinfo)
        {
            string sqlstr = string.Empty;
            string proesslist = "0";
            if (!string.IsNullOrEmpty(summaryid))
            {
                SqlParameter[] param = {
                                           new SqlParameter("@ID",SqlDbType.VarChar,50)
                                       };
                param[0].Value = summaryid;
                DataTable dt = SqlHelper.ExecuteSql("select ProessID from officedba.ProjectConstructionDetails where ID [email protected]", param);
                if (dt != null && dt.Rows.Count > 0)
                {
                    if (dt.Rows[0]["ProessID"].ToString().Trim().Length > 0)
                    {
                        proesslist = dt.Rows[0]["ProessID"].ToString().Trim();
                    }
                }
            }
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("select A.ID,A.SummaryName,isnull(B.CheckFlag,'') checkflag from officedba.ProjectConstructionDetails A ");
            sb.AppendLine("left join ");
            sb.AppendLine("(");
	        sb.AppendLine("    select *,'checked=checked' checkflag from officedba.ProjectConstructionDetails where ID in ( "+proesslist+" )");
            sb.AppendLine(")B on A.ID=B.ID");
            sb.AppendLine("where [email protected] and [email protected]");

            SqlParameter[] parm = {
                                      new SqlParameter("@projectID",SqlDbType.VarChar,50),
                                      new SqlParameter("@companyCD",SqlDbType.VarChar,50)
                                  };
            parm[0].Value = projectid;
            parm[1].Value = userinfo.CompanyCD;
            return SqlHelper.ExecuteSql(sb.ToString(), parm);
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:35，代码来源:ProjectConstructionDBHelper.cs

示例3: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(XBase.Model.Personal.MessageBox.MyContact model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into officedba.MyContact(");
			strSql.Append("GroupID,CompanyCD,ContactID,Creator,CreateDate,ModifiedDate,ModifiedUserID)");
			strSql.Append(" values (");
			strSql.Append("@GroupID,@CompanyCD,@ContactID,@Creator,@CreateDate,@ModifiedDate,@ModifiedUserID)");
            strSql.Append(";select @[email protected]@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@GroupID", SqlDbType.Int,4),
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@ContactID", SqlDbType.Int,4),
					new SqlParameter("@Creator", SqlDbType.Int,4),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50),
                     new SqlParameter("@ID", SqlDbType.Int,0) };
			parameters[0].Value = model.GroupID;
			parameters[1].Value = model.CompanyCD;
			parameters[2].Value = model.ContactID;
			parameters[3].Value = model.Creator;
			parameters[4].Value = model.CreateDate;
			parameters[5].Value = model.ModifiedDate;
			parameters[6].Value = model.ModifiedUserID;
            parameters[7].Direction = ParameterDirection.Output;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
            return int.Parse(parameters[7].Value.ToString());
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:32，代码来源:MyContact.cs

示例4: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public void Update(XBase.Model.Personal.MessageBox.MyContact model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("update officedba.MyContact set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected] ");
			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4),
					new SqlParameter("@GroupID", SqlDbType.Int,4),
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@ContactID", SqlDbType.Int,4),
					new SqlParameter("@Creator", SqlDbType.Int,4),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50)};
			parameters[0].Value = model.ID;
			parameters[1].Value = model.GroupID;
			parameters[2].Value = model.CompanyCD;
			parameters[3].Value = model.ContactID;
			parameters[4].Value = model.Creator;
			parameters[5].Value = model.CreateDate;
			parameters[6].Value = model.ModifiedDate;
			parameters[7].Value = model.ModifiedUserID;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:35，代码来源:MyContact.cs

示例5: Update

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(XBase.Model.SystemManager.SysNotice model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update pubdba.SysNotice set ");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]");
            strSql.Append(" where [email protected] ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4),
					new SqlParameter("@Title", SqlDbType.NVarChar,50),
					new SqlParameter("@Content", SqlDbType.NText),
					new SqlParameter("@PubDate", SqlDbType.DateTime),
                     new SqlParameter("@OverDate", SqlDbType.DateTime),
					new SqlParameter("@CreatorUserID", SqlDbType.VarChar,50)};
            parameters[0].Value = model.ID;
            parameters[1].Value = model.Title;
            parameters[2].Value = model.Content;
            parameters[3].Value = model.PubDate;
            parameters[4].Value = model.OverDate;
            parameters[5].Value = model.CreatorUserID;

            SqlHelper.ExecuteSql(strSql.ToString(), parameters);
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:29，代码来源:SysNotice.cs

示例6: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(XBase.Model.Personal.MessageBox.PersonalAdviceSend model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into [officedba].PersonalAdviceSend(");
			strSql.Append("CompanyCD,AdviceType,FromUserID,DoUserID,Title,Content,CreateDate,DisplayName)");
			strSql.Append(" values (");
			strSql.Append("@CompanyCD,@AdviceType,@FromUserID,@DoUserID,@Title,@Content,@CreateDate,@DisplayName)");
            strSql.Append(";select @[email protected]@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@AdviceType", SqlDbType.Char,1),
					new SqlParameter("@FromUserID", SqlDbType.Int,4),
					new SqlParameter("@DoUserID", SqlDbType.Int,4),
					new SqlParameter("@Title", SqlDbType.VarChar,100),
					new SqlParameter("@Content", SqlDbType.VarChar,1024),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@DisplayName", SqlDbType.Char,1),
                      new SqlParameter("@ID", SqlDbType.Int,0) };
			parameters[0].Value = model.CompanyCD;
			parameters[1].Value = model.AdviceType;
			parameters[2].Value = model.FromUserID;
			parameters[3].Value = model.DoUserID;
			parameters[4].Value = model.Title;
			parameters[5].Value = model.Content;
			parameters[6].Value = model.CreateDate;
			parameters[7].Value = model.DisplayName;

            parameters[8].Direction = ParameterDirection.Output;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
            return int.Parse(parameters[8].Value.ToString());
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:35，代码来源:PersonalAdviceSend.cs

示例7: UpdateByID

        public int UpdateByID(XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity)
        {
            SqlParameter[] parameters = new SqlParameter[]{
				SqlParameterHelper.MakeInParam("@ID",SqlDbType.Int,0,entity.ID),
				SqlParameterHelper.MakeInParam("@KnowledgeNo",SqlDbType.VarChar,50,entity.KnowledgeNo),
				SqlParameterHelper.MakeInParam("@Flag",SqlDbType.Char,1,entity.Flag),
				SqlParameterHelper.MakeInParam("@TypeID",SqlDbType.Int,0,entity.TypeID),
				SqlParameterHelper.MakeInParam("@Title",SqlDbType.VarChar,100,entity.Title),
				SqlParameterHelper.MakeInParam("@Keyword",SqlDbType.VarChar,100,entity.Keyword),
				SqlParameterHelper.MakeInParam("@Content",SqlDbType.NText,0,entity.Content),
				SqlParameterHelper.MakeInParam("@IsShow",SqlDbType.Char,1,entity.IsShow),
				SqlParameterHelper.MakeInParam("@SourceFrom",SqlDbType.Char,1,entity.SourceFrom),
				SqlParameterHelper.MakeInParam("@SafeLevel",SqlDbType.Char,1,entity.SafeLevel),
				SqlParameterHelper.MakeInParam("@Author",SqlDbType.VarChar,50,entity.Author),
				SqlParameterHelper.MakeInParam("@Attachment",SqlDbType.VarChar,200,entity.Attachment),
				SqlParameterHelper.MakeInParam("@CreateUserID",SqlDbType.VarChar,20,entity.CreateUserID),
				SqlParameterHelper.MakeInParam("@CreateDate",SqlDbType.DateTime,0,entity.CreateDate),
				SqlParameterHelper.MakeInParam("@ModifiedDate",SqlDbType.DateTime,0,entity.ModifiedDate),
				SqlParameterHelper.MakeInParam("@ModifiedUserID",SqlDbType.VarChar,20,entity.ModifiedUserID),
				SqlParameterHelper.MakeInParam("@ReadTimes",SqlDbType.Int,0,entity.ReadTimes),
				SqlParameterHelper.MakeInParam("@DownloadTimes",SqlDbType.Int,0,entity.DownloadTimes) 
			};
            int result;
            Database.RunProc("[knowdba].KnowledgeWarehouse_UpdateByID", parameters, out result);
            return result;
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:26，代码来源:KnowledgeWarehouse.cs

示例8: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(XBase.Model.SystemManager.SysNotice model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into pubdba.SysNotice(");
            strSql.Append("Title,Content,PubDate,OverDate,CreatorUserID)");
            strSql.Append(" values (");
            strSql.Append("@Title,@Content,@PubDate,@OverDate,@CreatorUserID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@Title", SqlDbType.NVarChar,50),
					new SqlParameter("@Content", SqlDbType.NText),
					new SqlParameter("@PubDate", SqlDbType.DateTime),
                    new SqlParameter("@OverDate", SqlDbType.DateTime),
					new SqlParameter("@CreatorUserID", SqlDbType.VarChar,50)};
            parameters[0].Value = model.Title;
            parameters[1].Value = model.Content;
            parameters[2].Value = model.PubDate;
            parameters[3].Value = model.OverDate;
            parameters[4].Value = model.CreatorUserID;

            object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:33，代码来源:SysNotice.cs

示例9: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(XBase.Model.Personal.MessageBox.PublicNotice model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into [officedba].PublicNotice(");
			strSql.Append("CompanyCD,NewsTitle,NewsContent,IsShow,Status,Comfirmor,ComfirmDate,Creator,CreateDate)");
			strSql.Append(" values (");
			strSql.Append("@CompanyCD,@NewsTitle,@NewsContent,@IsShow,@Status,@Comfirmor,@ComfirmDate,@Creator,@CreateDate)");
			strSql.Append(";select @[email protected]@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),					
					new SqlParameter("@NewsTitle", SqlDbType.VarChar,100),
					new SqlParameter("@NewsContent", SqlDbType.VarChar,512),
					new SqlParameter("@IsShow", SqlDbType.Char,1),
					new SqlParameter("@Status", SqlDbType.Char,1),					
					new SqlParameter("@Comfirmor", SqlDbType.Int,4),
					new SqlParameter("@ComfirmDate", SqlDbType.DateTime),
					new SqlParameter("@Creator", SqlDbType.Int,4),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
                     new SqlParameter("@ID", SqlDbType.Int,0) };
			parameters[0].Value = model.CompanyCD;			
			parameters[1].Value = model.NewsTitle;
			parameters[2].Value = model.NewsContent;
			parameters[3].Value = model.IsShow;
			parameters[4].Value = model.Status;			
			parameters[5].Value = model.Comfirmor;
			parameters[6].Value = model.ComfirmDate;
			parameters[7].Value = model.Creator;
			parameters[8].Value = model.CreateDate;

            parameters[9].Direction = ParameterDirection.Output;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
            return int.Parse(parameters[9].Value.ToString());
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:37，代码来源:PublicNotice.cs

示例10: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public void Update(XBase.Model.Personal.MessageBox.PersonalAdviceSend model)
		{
			StringBuilder strSql=new StringBuilder();
            strSql.Append("update [officedba].PersonalAdviceSend set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected] ");
			SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4),
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@AdviceType", SqlDbType.Char,1),
					new SqlParameter("@FromUserID", SqlDbType.Int,4),
					new SqlParameter("@DoUserID", SqlDbType.Int,4),
					new SqlParameter("@Title", SqlDbType.VarChar,100),
					new SqlParameter("@Content", SqlDbType.VarChar,1024),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@DisplayName", SqlDbType.Char,1)};
			parameters[0].Value = model.ID;
			parameters[1].Value = model.CompanyCD;
			parameters[2].Value = model.AdviceType;
			parameters[3].Value = model.FromUserID;
			parameters[4].Value = model.DoUserID;
			parameters[5].Value = model.Title;
			parameters[6].Value = model.Content;
			parameters[7].Value = model.CreateDate;
			parameters[8].Value = model.DisplayName;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:38，代码来源:PersonalAdviceSend.cs

示例11: AddSubBudgetInfo

        public static int AddSubBudgetInfo(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo)
        {
            StringBuilder sqlstr = new StringBuilder();
            sqlstr.Append("insert into officedba.SubBudget(CompanyCD,projectid,BudgetName) values(@CompanyCD,@projectid,@BudgetName)");
            SqlParameter[] param = {
                                       new SqlParameter("@CompanyCD",SqlDbType.VarChar,50),
                                       new SqlParameter("@projectid",SqlDbType.Int),
                                       new SqlParameter("@BudgetName",SqlDbType.VarChar,200)
                                   };
            param[0].Value = userinfo.CompanyCD;
            param[1].Value = subBudgetModel.Projectid;
            param[2].Value = subBudgetModel.BudgetName;

            TransactionManager tran = new TransactionManager();
            int num = 0;
            tran.BeginTransaction();
            try
            {
                num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr.ToString(), param);
                tran.Commit();
            }
            catch
            {
                tran.Rollback();
            }
            return num;
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:27，代码来源:SubBudgetDBHelper.cs

示例12: EditSubBudget

 public static int EditSubBudget(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo)
 {
     StringBuilder sqlstr = new StringBuilder();
     sqlstr.Append("update officedba.SubBudget set [email protected],[email protected] where [email protected]");
     SqlParameter[] param = {
                                new SqlParameter("@BudgetName",SqlDbType.VarChar,200),
                                new SqlParameter("@projectid",SqlDbType.Int,4),
                                new SqlParameter("@ID",SqlDbType.Int)
                            };
     param[0].Value = subBudgetModel.BudgetName;
     param[1].Value = subBudgetModel.Projectid;
     param[2].Value = subBudgetModel.ID;
     TransactionManager tran = new TransactionManager();
     int num = 0;
     tran.BeginTransaction();
     try
     {
         num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr.ToString(), param);
         tran.Commit();
     }
     catch
     {
         tran.Rollback();
     }
     return num;
 }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:26，代码来源:SubBudgetDBHelper.cs

示例13: Add

 public static int Add(XBase.Model.Office.SellReport.UserProductInfo model)
 {
     int num = 0;
     string sqlstr = "insert into officedba.UserProductInfo(CompanyCD,productNum,productName,price,bref,memo) values(@CompanyCD,@productNum,@productName,@price,@bref,@memo)";
     TransactionManager tran = new TransactionManager();
     tran.BeginTransaction();
     SqlParameter[] param = {
                                new SqlParameter("@CompanyCD",SqlDbType.VarChar,50),
                                new SqlParameter("@productNum",SqlDbType.VarChar,50),
                                new SqlParameter("@productName",SqlDbType.VarChar,200),
                                new SqlParameter("@price",SqlDbType.Decimal),
                                new SqlParameter("@bref",SqlDbType.VarChar,500),
                                new SqlParameter("@memo",SqlDbType.VarChar,1000)
                            };
     param[0].Value = model.CompanyCD;
     param[1].Value = model.productNum;
     param[2].Value = model.productName;
     param[3].Value = model.price;
     param[4].Value = model.bref;
     param[5].Value = model.memo;
     try
     {
         num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr, param);
         tran.Commit();
     }
     catch
     {
         tran.Rollback();
     }
     return num;
 }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:31，代码来源:UserProjectInfoDBHelper.cs

示例14: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(XBase.Model.Personal.Culture.CultureType model)
		{
			StringBuilder strSql=new StringBuilder();            
            strSql.AppendLine("set @path =''");
            strSql.AppendLine("select @path=[path] from [officedba].CultureType where [email protected]");
            strSql.AppendLine("insert into [officedba].CultureType(");
			strSql.AppendLine("CompanyCD,TypeName,SupperTypeID,Path)");
			strSql.AppendLine(" values (");
			strSql.AppendLine("@CompanyCD,@TypeName,@SupperTypeID,@Path)");
            strSql.AppendLine("select @[email protected]@IDENTITY");
            strSql.AppendLine("if(@path <> '')");
            strSql.AppendLine("begin");
            strSql.AppendLine("set @[email protected]+'_'");
            strSql.AppendLine("end");
            strSql.AppendLine(";UPDATE [officedba].CultureType SET [path][email protected]+cast(@ID as varchar(10)) WHERE [email protected]");
			SqlParameter[] parameters = {
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@TypeName", SqlDbType.VarChar,100),
					new SqlParameter("@SupperTypeID", SqlDbType.Int,4),
					new SqlParameter("@Path", SqlDbType.VarChar,512),
                     new SqlParameter("@ID", SqlDbType.Int,0) };
			parameters[0].Value = model.CompanyCD;
			parameters[1].Value = model.TypeName;
			parameters[2].Value = model.SupperTypeID;
			parameters[3].Value = model.Path;

            parameters[4].Direction = ParameterDirection.Output;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
            return int.Parse(parameters[4].Value.ToString());
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:34，代码来源:CultureType.cs

示例15: GetTableList

        /// <summary>
        /// 返回自定义表列表
        /// </summary>
        /// <returns></returns>
        public static DataSet GetTableList(XBase.Common.UserInfoUtil userinfo)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@companyCD", SqlDbType.VarChar,200)
					};
            parameters[0].Value = userinfo.CompanyCD;
            return SqlHelper.ExecuteSqlX("select *,AliasTableName+'(define.'+CompanyCD+'_'+CustomTableName+')' buildTableName from defdba.CustomTable where [email protected] order by ID", parameters);
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:12，代码来源:TableReportDBHelper.cs

示例16: GetProssList

 public static DataSet GetProssList(string projectID, XBase.Common.UserInfoUtil userinfo)
 {
     SqlParameter[] param ={
                             new SqlParameter("@companyCD",SqlDbType.VarChar,50),
                             new SqlParameter("@projectid",SqlDbType.Int,4)
                         };
     param[0].Value = userinfo.CompanyCD;
     param[1].Value = projectID;
     return SqlHelper.ExecuteSqlX("exec officedba.GetProssList @companyCD,@projectid", param);
 }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:10，代码来源:ProjectGanttDBHelper.cs

示例17: InsertReport

        /// <summary>
        /// 
        /// </summary>
        /// <param name="report"></param>
        /// <param name="flag">判断是添加还是修改</param>
        /// <returns></returns>
        public static int InsertReport(ReportTableModel report,XBase.Common.UserInfoUtil userinfo,string ID,string useridlist)
        {
            int num = 0;
            StringBuilder strSql = new StringBuilder();
            if (ID == "0")  //添加
            {
                strSql.Append("insert into defdba.ReportTable(Menuname,CompanyCD,sqlstr,timeFlag,tablelist,excelhead) values(@Menuname,@CompanyCD,@SqlStr,@timeFlag,@tablelist,@excelhead)");
                strSql.Append(";select @@IDENTITY");
                SqlParameter[] parameters = {
					new SqlParameter("@Menuname", SqlDbType.VarChar,200),
                    new SqlParameter("@CompanyCD", SqlDbType.VarChar,200),
					new SqlParameter("@SqlStr", SqlDbType.Text),
					new SqlParameter("@timeFlag", SqlDbType.Int,4),
                    new SqlParameter("@tablelist", SqlDbType.VarChar,100),
                    new SqlParameter("@excelhead", SqlDbType.VarChar,100)
					};
                parameters[0].Value = report.Menuname;
                parameters[1].Value = userinfo.CompanyCD;
                parameters[2].Value = report.SqlStr;
                parameters[3].Value = report.timeFlag;
                parameters[4].Value = report.Tablelist;
                parameters[5].Value = report.Excelhead;
                num = Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), parameters));
            }
            else  //修改
            {
                strSql.Append("update defdba.ReportTable set [email protected],[email protected],[email protected],[email protected],[email protected] where [email protected]");
                SqlParameter[] parameters = {
					new SqlParameter("@Menuname", SqlDbType.VarChar,200),
                    new SqlParameter("@CompanyCD", SqlDbType.VarChar,200),
					new SqlParameter("@SqlStr", SqlDbType.Text),
					new SqlParameter("@timeFlag", SqlDbType.Int,4),
                    new SqlParameter("@tablelist", SqlDbType.VarChar,100),
                    new SqlParameter("@ID", SqlDbType.VarChar,100),
                    new SqlParameter("@excelhead", SqlDbType.VarChar,500)
					};
                parameters[0].Value = report.Menuname;
                parameters[1].Value = userinfo.CompanyCD;
                parameters[2].Value = report.SqlStr;
                parameters[3].Value = report.timeFlag;
                parameters[4].Value = report.Tablelist;
                parameters[5].Value = ID;
                parameters[6].Value = report.Excelhead;
                try
                {
                    SqlHelper.ExecuteTransSql(strSql.ToString(),parameters);
                    num = Convert.ToInt32(ID);
                }
                catch { return 0; }
            }
            //添加菜单
            CreateMenu(report.Menuname, num.ToString(), userinfo, useridlist);
            return num;

        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:61，代码来源:TableReportDBHelper.cs

示例18: Update

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(XBase.Model.Personal.Memo.PersonalMemo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update [officedba].PersonalMemo set ");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]");
            strSql.Append(" where [email protected] ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4),
					new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
					new SqlParameter("@MemoNo", SqlDbType.VarChar,50),
					new SqlParameter("@TItle", SqlDbType.VarChar,100),
					new SqlParameter("@Content", SqlDbType.NText),
					new SqlParameter("@CanViewUser", SqlDbType.VarChar,1024),
					new SqlParameter("@CanViewUserName", SqlDbType.VarChar,1024),
					new SqlParameter("@Attachment", SqlDbType.VarChar,200),
					new SqlParameter("@Memoer", SqlDbType.Int,4),
					new SqlParameter("@MemoDate", SqlDbType.DateTime),
					new SqlParameter("@Creator", SqlDbType.Int,4),
					new SqlParameter("@CreateDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
					new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50),
                    new SqlParameter("@Status", SqlDbType.VarChar,50)
                                        };
            parameters[0].Value = model.ID;
            parameters[1].Value = model.CompanyCD;
            parameters[2].Value = model.MemoNo;
            parameters[3].Value = model.TItle;
            parameters[4].Value = model.Content;
            parameters[5].Value = model.CanViewUser;
            parameters[6].Value = model.CanViewUserName;
            parameters[7].Value = model.Attachment;
            parameters[8].Value = model.Memoer;
            parameters[9].Value = model.MemoDate;
            parameters[10].Value = model.Creator;
            parameters[11].Value = model.CreateDate;
            parameters[12].Value = model.ModifiedDate;
            parameters[13].Value = model.ModifiedUserID;
            parameters[14].Value = model.Status;

            SqlHelper.ExecuteTransSql(strSql.ToString(), parameters);
        }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:57，代码来源:PersonalMemo.cs

示例19: DataList

 public static DataTable DataList(int pageindex, int pagecount, string OrderBy, XBase.Common.UserInfoUtil userinfo, ref int totalCount)
 {
     StringBuilder sqlstr = new StringBuilder();
     sqlstr.AppendLine("select id,CompanyCD,productNum,productName,convert(decimal(22,"+userinfo.SelPoint+"),price) price,bref,memo from officedba.UserProductInfo where [email protected]");
     
     SqlCommand comm = new SqlCommand();
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", userinfo.CompanyCD));
     
     comm.CommandText = sqlstr.ToString();
     return SqlHelper.PagerWithCommand(comm, pageindex, pagecount, OrderBy, ref totalCount);
 }

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:11，代码来源:UserProjectInfoDBHelper.cs

示例20: Create

		public bool Create(XBase.Model.KnowledgeCenter.KeyWordHistory entity)
		{
			SqlParameter[] parameters = new SqlParameter[]{
				SqlParameterHelper.MakeInParam("@TypeID",SqlDbType.Int,0,entity.TypeID),
				SqlParameterHelper.MakeInParam("@KeyWordName",SqlDbType.VarChar,100,entity.KeyWordName),
				SqlParameterHelper.MakeInParam("@SearchTimes",SqlDbType.Int,0,entity.SearchTimes),
                SqlParameterHelper.MakeInParam("@LastDate",SqlDbType.DateTime,0,entity.LastDate)
			};
			bool result;
			Database.RunProc("[knowdba].KeyWordHistory_Create",parameters,out result); 
			return result;
		}

开发者ID:kosmos-zhang，项目名称:erp-aspnet，代码行数:12，代码来源:KeyWordHistory.cs

注：本文中的XBase类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# XColor类代码示例发布时间：2022-05-24

C# XBMCRPC类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19155|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9981|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8320|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8690|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8632|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9649|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8615|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7994|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8647|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7530|2022-11-06

客服电话

电子邮件

C# XBase类代码示例

示例1: Update

示例2: GetProessList

示例3: Add

示例4: Update

示例5: Update

示例6: Add

示例7: UpdateByID

示例8: Add

示例9: Add

示例10: Update

示例11: AddSubBudgetInfo

示例12: EditSubBudget

示例13: Add

示例14: Add

示例15: GetTableList

示例16: GetProssList

示例17: InsertReport

示例18: Update

示例19: DataList

示例20: Create

请发表评论

全部评论

上一篇：

下一篇：

AdamWagner/stackline: Visualize yabai wi

Protocol - wiki.vg

TingsongYu/cascaded_mobilenet-v2: cascad

angular-material-extensions/password-str

CEF3中js调用delphi内部方法

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053