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