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; }
/// <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 @ID=@@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()); }
public static int EditSubBudget(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo) { StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("update officedba.SubBudget set BudgetName=@BudgetName,projectid=@projectid where ID=@ID"); 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; }
/// <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 @ID=@@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()); }
/// <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 id=@SupperTypeID"); strSql.AppendLine("insert into [officedba].CultureType("); strSql.AppendLine("CompanyCD,TypeName,SupperTypeID,Path)"); strSql.AppendLine(" values ("); strSql.AppendLine("@CompanyCD,@TypeName,@SupperTypeID,@Path)"); strSql.AppendLine("select @ID=@@IDENTITY"); strSql.AppendLine("if(@path <> '')"); strSql.AppendLine("begin"); strSql.AppendLine("set @path=@path+'_'"); strSql.AppendLine("end"); strSql.AppendLine(";UPDATE [officedba].CultureType SET [path]=@path+cast(@ID as varchar(10)) WHERE ID=@ID"); 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> public void Update(XBase.Model.Personal.MessageBox.PersonalAdviceSend model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update [officedba].PersonalAdviceSend set "); strSql.Append("CompanyCD=@CompanyCD,"); strSql.Append("AdviceType=@AdviceType,"); strSql.Append("FromUserID=@FromUserID,"); strSql.Append("DoUserID=@DoUserID,"); strSql.Append("Title=@Title,"); strSql.Append("Content=@Content,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("DisplayName=@DisplayName"); strSql.Append(" where ID=@ID "); 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 Update(XBase.Model.Office.SellReport.UserProductInfo model) { int num = 0; string sqlstr = "update officedba.UserProductInfo set productNum=@productNum,productName=@productName,price=@price,bref=@bref,memo=@memo where id=@id"; 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 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; }
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 =@ID", 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 A.projectID=@projectID and A.CompanyCD=@companyCD"); 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 void Update(XBase.Model.Personal.MessageBox.MyContact model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update officedba.MyContact set "); strSql.Append("GroupID=@GroupID,"); strSql.Append("CompanyCD=@CompanyCD,"); strSql.Append("ContactID=@ContactID,"); strSql.Append("Creator=@Creator,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID"); strSql.Append(" where ID=@ID "); 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("Title=@Title,"); strSql.Append("Content=@Content,"); strSql.Append("PubDate=@PubDate,"); strSql.Append("OverDate=@OverDate,"); strSql.Append("CreatorUserID=@CreatorUserID"); strSql.Append(" where ID=@ID "); 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.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 @ID=@@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 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); } }
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> /// <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 CompanyCD=@companyCD order by ID", parameters); }
public bool Equals(XBase obj) { return (this.BaseNeptun == obj.BaseNeptun && this.BaseEducationProgram == obj.BaseEducationProgram && this.BaseName == obj.BaseName && this.Curriculum == obj.Curriculum); }
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); }
/// <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 Menuname=@menuname,timeFlag=@timeFlag,sqlstr=@SqlStr,tablelist=@tablelist,excelhead=@excelhead where ID=@id"); 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; }
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 CompanyCD=@CompanyCD"); 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); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(XBase.Model.Personal.Memo.PersonalMemo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [officedba].PersonalMemo set "); strSql.Append("CompanyCD=@CompanyCD,"); strSql.Append("MemoNo=@MemoNo,"); strSql.Append("TItle=@TItle,"); strSql.Append("Content=@Content,"); strSql.Append("CanViewUser=@CanViewUser,"); strSql.Append("CanViewUserName=@CanViewUserName,"); strSql.Append("Attachment=@Attachment,"); strSql.Append("Memoer=@Memoer,"); strSql.Append("MemoDate=@MemoDate,"); strSql.Append("Creator=@Creator,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID,"); strSql.Append("Status=@Status"); strSql.Append(" where ID=@ID "); 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); }
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; }
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeType entity) { SqlParameter[] parameters = new SqlParameter[]{ SqlParameterHelper.MakeInParam("@Flag",SqlDbType.Char,1,entity.Flag), SqlParameterHelper.MakeInParam("@TypeName",SqlDbType.VarChar,100,entity.TypeName), SqlParameterHelper.MakeInParam("@SupperTypeID",SqlDbType.Int,0,entity.SupperTypeID), SqlParameterHelper.MakeInParam("@ModifiedDate",SqlDbType.DateTime,0,entity.ModifiedDate), SqlParameterHelper.MakeInParam("@ModifiedUserID",SqlDbType.VarChar,20,entity.ModifiedUserID) }; bool result; Database.RunProc("[knowdba].KnowledgeType_Create",parameters,out result); return result; }
/// <summary> /// 增加一条数据 /// </summary> public void Add(XBase.Model.Decision.CustAnalysis model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into statdba.DataCustAnalysis("); strSql.Append("CustNo,CustName,CompanyCD,CreateDate,CompanyType,StaffCount,SetupDate,CapitalScale,SaleroomY,SetupMoney,ArrearageCount,ArrearagePrice,BuyCount,BuyPrice,RefundmentCount,RefundmentPrice,ComplainCount,CustGrade,CustProint)"); strSql.Append(" values ("); strSql.Append("@CustNo,@CustName,@CompanyCD,@CreateDate,@CompanyType,@StaffCount,@SetupDate,@CapitalScale,@SaleroomY,@SetupMoney,@ArrearageCount,@ArrearagePrice,@BuyCount,@BuyPrice,@RefundmentCount,@RefundmentPrice,@ComplainCount,@CustGrade,@CustProint)"); SqlParameter[] parameters = { new SqlParameter("@CustNo", SqlDbType.NVarChar,50), new SqlParameter("@CustName", SqlDbType.NVarChar,100), new SqlParameter("@CompanyCD", SqlDbType.NVarChar,50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@CompanyType", SqlDbType.Int,4), new SqlParameter("@StaffCount", SqlDbType.Int,4), new SqlParameter("@SetupDate", SqlDbType.Int,4), new SqlParameter("@CapitalScale", SqlDbType.Int,4), new SqlParameter("@SaleroomY", SqlDbType.Int,4), new SqlParameter("@SetupMoney", SqlDbType.Int,4), new SqlParameter("@ArrearageCount", SqlDbType.Int,4), new SqlParameter("@ArrearagePrice", SqlDbType.Decimal,13), new SqlParameter("@BuyCount", SqlDbType.Int,4), new SqlParameter("@BuyPrice", SqlDbType.Decimal,13), new SqlParameter("@RefundmentCount", SqlDbType.Int,4), new SqlParameter("@RefundmentPrice", SqlDbType.Decimal,13), new SqlParameter("@ComplainCount", SqlDbType.Int,4), new SqlParameter("@CustGrade", SqlDbType.NVarChar,100), new SqlParameter("@CustProint", SqlDbType.Int,4)}; parameters[0].Value = model.CustNo; parameters[1].Value = model.CustName; parameters[2].Value = model.CompanyCD; parameters[3].Value = model.CreateDate; parameters[4].Value = model.CompanyType; parameters[5].Value = model.StaffCount; parameters[6].Value = model.SetupDate; parameters[7].Value = model.CapitalScale; parameters[8].Value = model.SaleroomY; parameters[9].Value = model.SetupMoney; parameters[10].Value = model.ArrearageCount; parameters[11].Value = model.ArrearagePrice; parameters[12].Value = model.BuyCount; parameters[13].Value = model.BuyPrice; parameters[14].Value = model.RefundmentCount; parameters[15].Value = model.RefundmentPrice; parameters[16].Value = model.ComplainCount; parameters[17].Value = model.CustGrade; parameters[18].Value = model.CustProint; Database.RunSql(strSql.ToString(),parameters); }
public bool Create(XBase.Model.KnowledgeCenter.SubscribeHistory entity) { SqlParameter[] parameters = new SqlParameter[]{ SqlParameterHelper.MakeInParam("@CompanyCD",SqlDbType.VarChar,8,entity.CompanyCD), SqlParameterHelper.MakeInParam("@Receiver",SqlDbType.VarChar,20,entity.Receiver), SqlParameterHelper.MakeInParam("@KnowledgeID",SqlDbType.Int,0,entity.KnowledgeID), SqlParameterHelper.MakeInParam("@SendDate",SqlDbType.DateTime,0,entity.SendDate), SqlParameterHelper.MakeInParam("@KeyWordID",SqlDbType.VarChar,50,entity.KeyWordID), SqlParameterHelper.MakeInParam("@KeyWordName",SqlDbType.VarChar,50,entity.KeyWordName) }; bool result; Database.RunProc("[knowdba].SubscribeHistory_Create",parameters,out result); return result; }
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeRequire entity) { SqlParameter[] parameters = new SqlParameter[]{ SqlParameterHelper.MakeInParam("@CompanyCD",SqlDbType.VarChar,8,entity.CompanyCD), SqlParameterHelper.MakeInParam("@SendDate",SqlDbType.DateTime,0,entity.SendDate), SqlParameterHelper.MakeInParam("@SendUserID",SqlDbType.VarChar,20,entity.SendUserID), SqlParameterHelper.MakeInParam("@Content",SqlDbType.NVarChar,200,entity.Content), SqlParameterHelper.MakeInParam("@FeeBackStatus",SqlDbType.Char,1,entity.FeeBackStatus), SqlParameterHelper.MakeInParam("@FeeBackDate",SqlDbType.DateTime,0,entity.FeeBackDate), SqlParameterHelper.MakeInParam("@FeeBackUserID",SqlDbType.VarChar,20,entity.FeeBackUserID) }; bool result; Database.RunProc("[knowdba].KnowledgeRequire_Create",parameters,out result); return result; }
public int UpdateByID(XBase.Model.KnowledgeCenter.KeyWordPrepare entity) { SqlParameter[] parameters = new SqlParameter[]{ SqlParameterHelper.MakeInParam("@ID",SqlDbType.Int,0,entity.ID), SqlParameterHelper.MakeInParam("@TypeID",SqlDbType.Int,0,entity.TypeID), SqlParameterHelper.MakeInParam("@KeyWordName",SqlDbType.VarChar,100,entity.KeyWordName), 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) }; int result; Database.RunProc("[knowdba].KeyWordPrepare_UpdateByID",parameters,out result); return result; }
public static string StorageReturnUpdate(XBase.Model.Office.StorageManager.StorageReturn sr, List<XBase.Model.Office.StorageManager.StorageReturnDetail> srdList, Hashtable ht) { // return "1|"; //定义返回变量 string res = string.Empty; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //获取当前用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //执行操作 try { //执行操作 res = XBase.Data.Office.StorageManager.StorageReturnDBHelper.StorageReturnUpdate(sr, srdList,ht); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (res.Split('|')[0] == "1") { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(sr.ReturnNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return res; }
public static void BindUnit(System.Web.UI.WebControls.DropDownList ddl, XBase.Common.UserInfoUtil userinfo) { string sqlstr = "select ID,CodeName from officedba.CodeUnitType where UsedStatus=1 and CompanyCD=@CompanyCD"; SqlParameter[] param = { new SqlParameter("@CompanyCD",SqlDbType.VarChar) }; param[0].Value = userinfo.CompanyCD; DataSet ds = SqlHelper.ExecuteSqlX(sqlstr, param); ddl.DataTextField = "CodeName"; ddl.DataValueField = "ID"; ddl.DataSource = ds; ddl.DataBind(); ddl.DataSource = null; ddl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---请选择单位---", "0")); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(XBase.Model.Personal.MessageBox.MessageInputBox model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update officedba.MessageInputBox set "); strSql.Append("CompanyCD=@CompanyCD,"); strSql.Append("Title=@Title,"); strSql.Append("Content=@Content,"); strSql.Append("FromID=@FromID,"); strSql.Append("SendUserID=@SendUserID,"); strSql.Append("ReceiveUserID=@ReceiveUserID,"); strSql.Append("Status=@Status,"); strSql.Append("ReadDate=@ReadDate,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("MsgURL=@MsgURL,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4), new SqlParameter("@CompanyCD", SqlDbType.VarChar,8), new SqlParameter("@Title", SqlDbType.VarChar,100), new SqlParameter("@Content", SqlDbType.VarChar,1024), new SqlParameter("@FromID", SqlDbType.Int,4), new SqlParameter("@SendUserID", SqlDbType.Int,4), new SqlParameter("@ReceiveUserID", SqlDbType.Int,4), new SqlParameter("@Status", SqlDbType.Char,1), new SqlParameter("@ReadDate", SqlDbType.DateTime), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@MsgURL", SqlDbType.VarChar,200), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,10)}; parameters[0].Value = model.ID; parameters[1].Value = model.CompanyCD; parameters[2].Value = model.Title; parameters[3].Value = model.Content; parameters[4].Value = model.FromID; parameters[5].Value = model.SendUserID; parameters[6].Value = model.ReceiveUserID; parameters[7].Value = model.Status; parameters[8].Value = model.ReadDate; parameters[9].Value = model.CreateDate; parameters[10].Value = model.MsgURL; parameters[11].Value = model.ModifiedDate; parameters[12].Value = model.ModifiedUserID; SqlHelper.ExecuteSql(strSql.ToString(),parameters); }
public bool Create(XBase.Model.KnowledgeCenter.MyKeyWord entity) { SqlParameter[] parameters = new SqlParameter[]{ SqlParameterHelper.MakeInParam("@CompanyCD",SqlDbType.VarChar,8,entity.CompanyCD), SqlParameterHelper.MakeInParam("@TypeID",SqlDbType.Int,0,entity.TypeID), SqlParameterHelper.MakeInParam("@KeyType",SqlDbType.Char,1,entity.KeyType), SqlParameterHelper.MakeInParam("@KeyWordID",SqlDbType.Int,0,entity.KeyWordID), SqlParameterHelper.MakeInParam("@KeyWordName",SqlDbType.VarChar,100,entity.KeyWordName), SqlParameterHelper.MakeInParam("@Creator",SqlDbType.VarChar,20,entity.Creator), SqlParameterHelper.MakeInParam("@CreateDate",SqlDbType.DateTime,0,entity.CreateDate), SqlParameterHelper.MakeInParam("@ModifiedDate",SqlDbType.DateTime,0,entity.ModifiedDate), SqlParameterHelper.MakeInParam("@ModifiedUserID",SqlDbType.VarChar,20,entity.ModifiedUserID) }; bool result; Database.RunProc("[knowdba].MyKeyWord_Create",parameters,out result); return result; }
public bool Create(XBase.Model.KnowledgeCenter.MyCollector entity) { SqlParameter[] parameters = new SqlParameter[]{ SqlParameterHelper.MakeInParam("@Flag",SqlDbType.Char,1,entity.Flag), SqlParameterHelper.MakeInParam("@KnowledgeID",SqlDbType.Int,0,entity.KnowledgeID), SqlParameterHelper.MakeInParam("@Owner",SqlDbType.VarChar,20,entity.Owner), SqlParameterHelper.MakeInParam("@SourceType",SqlDbType.Char,1,entity.SourceType), SqlParameterHelper.MakeInParam("@CreateDate",SqlDbType.DateTime,0,entity.CreateDate), SqlParameterHelper.MakeInParam("@ReadStatus",SqlDbType.Char,1,entity.ReadStatus), SqlParameterHelper.MakeInParam("@ReadDate",SqlDbType.DateTime,0,entity.ReadDate), SqlParameterHelper.MakeInParam("@ModifiedDate",SqlDbType.DateTime,0,entity.ModifiedDate), SqlParameterHelper.MakeInParam("@ModifiedUserID",SqlDbType.VarChar,20,entity.ModifiedUserID) }; bool result; Database.RunProc("[knowdba].MyCollector_Create",parameters,out result); return result; }
public override XBase Add(XBase value) { return(Add(value as DElementList) as XBase); }
public override XBase Add(XBase value) { DElement e = value as DElement; return(Add(e)); }