C# XBase类代码示例

 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;
 }

        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);
        }

		/// <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());
		}

		/// <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);
		}

        /// <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);
        }

		/// <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());
		}

        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;
        }

        /// <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);
            }
        }

		/// <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());
		}

		/// <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);
		}

        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;
        }

 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;
 }

 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;
 }

		/// <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());
		}

        /// <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);
        }