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 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>
/// <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));
}
/// <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 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));
}
public static DataTable GetReportList(XBase.Common.UserInfoUtil userinfo, string menuname, int pageindex, int pagecount, string OrderBy, ref int totalCount)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.AppendLine("select ID,Menuname,CompanyCD,timeflag,tablelist,excelhead ,case when timeflag=0 then '否' else '是' end timeflagCn from defdba.ReportTable where CompanyCD=@CompanyCD");
SqlCommand comm = new SqlCommand();
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", userinfo.CompanyCD));
if (!string.IsNullOrEmpty(menuname))
{
sqlstr.AppendLine(" and Menuname like @menuname");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@menuname", "%" + menuname + "%"));
}
comm.CommandText = sqlstr.ToString();
return(SqlHelper.PagerWithCommand(comm, pageindex, pagecount, OrderBy, ref totalCount));
}
public static void BindProject(System.Web.UI.WebControls.DropDownList ddl, XBase.Common.UserInfoUtil userinfo)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.AppendLine("select ID,ProjectName from officedba.ProjectInfo");
sqlstr.AppendLine("where CompanyCD=@CompanyCD");
SqlParameter[] param =
{
new SqlParameter("@CompanyCD", SqlDbType.VarChar)
};
param[0].Value = userinfo.CompanyCD;
DataSet ds = SqlHelper.ExecuteSqlX(sqlstr.ToString(), param);
ddl.DataTextField = "ProjectName";
ddl.DataValueField = "ID";
ddl.DataSource = ds;
ddl.DataBind();
ddl.DataSource = null;
ddl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---请选择项目---", "0"));
}
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));
}
public static DataTable GetDataTableList(XBase.Common.UserInfoUtil UserInfo)
{
SqlParameter[] param =
{
new SqlParameter("@CompanyCD", SqlDbType.VarChar, 50)
};
param[0].Value = UserInfo.CompanyCD;
DataTable dt = SqlHelper.ExecuteSql("select * from defdba.CustomModule where CompanyCD=@CompanyCD", param);
if (dt != null && dt.Rows.Count > 0)
{
int dtnum = dt.Rows.Count;
for (int i = 0; i < dtnum; i++)
{
string[] arr = dt.Rows[i]["userdUserList"].ToString().Split(',');
if (dt.Rows[i]["userdUserList"].ToString().TrimEnd(',').Length < 1)
{
continue;
}
else
{
for (int j = 0; j < arr.Length; j++)
{
if (UserInfo.EmployeeID.ToString() == arr[j])
{
break;
}
if (j == arr.Length - 1)
{
dt.Rows[i].Delete();
}
}
}
}
dt.AcceptChanges();
}
return(dt);
}
public static DataTable GetPriceList(string projectid, string summaryid, string baseNum, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectBudgetDBHelper.GetPriceList(projectid, summaryid, baseNum, userinfo));
}
public static DataTable GetDataDetailByID(string id, XBase.Common.UserInfoUtil userinfo)
{
SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 50) };
param[0].Value = id;
return(SqlHelper.ExecuteSql("select id,CompanyCD,productNum,productName,convert(decimal(22," + userinfo.SelPoint + "),price) price,bref,memo from officedba.UserProductInfo where ID=@ID", param));
}
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));
}
public static DataSet GetSummaryData(string begintime, string endtime, XBase.Common.UserInfoUtil userinfo, string orderflag, int summarytype, string point)
{
StringBuilder sb = new StringBuilder();
switch (summarytype)
{
case 1: //按部门统计
sb.AppendLine("select A.DeptName,B.PriceTotal,B.NumTotal from officedba.deptinfo A");
sb.AppendLine("right join");
sb.AppendLine("(");
sb.AppendLine(" select SellDept,convert(decimal(22," + point + "),sum(sellPrice)) priceTotal,convert(decimal(22," + point + "),sum(sellNum)) NumTotal from officedba.SellReport");
sb.AppendLine(" where CompanyCD=@companyCD and convert(char(10),createdate,120) between @begintime and @endtime");
sb.AppendLine(" group by SellDept");
sb.AppendLine(")B on A.ID=B.SellDept");
if (orderflag == "0")
{
sb.AppendLine("order by B.PriceTotal desc,B.NumTotal DESC");
}
else
{
sb.AppendLine("order by B.NumTotal desc,B.PriceTotal DESC");
}
break;
case 2: //按业务员业绩统计
sb.AppendLine("select C.EmployeeName DeptName,D.priceTotal,D.NumTotal from officedba.EmployeeInfo C right join");
sb.AppendLine("(");
sb.AppendLine(" select sellerID,convert(decimal(22," + point + "),sum(B.sellPrice*A.rate)) priceTotal,convert(decimal(22," + point + "),sum(B.sellNum)) NumTotal from officedba.sellerRate A left join officedba.Sellreport B on A.sellreportID=B.ID");
sb.AppendLine(" where A.CompanyCD=@companyCD and convert(char(10),createdate,120) between @begintime and @endtime");
sb.AppendLine(" group by sellerID");
sb.AppendLine(")D on C.ID=D.sellerID");
if (orderflag == "0")
{
sb.AppendLine("order by D.PriceTotal desc,D.NumTotal DESC");
}
else
{
sb.AppendLine("order by D.NumTotal desc,D.PriceTotal DESC");
}
break;
case 3: //按产品统计
sb.AppendLine("select productName DeptName,convert(decimal(22," + point + "),sum(sellPrice)) priceTotal ,convert(decimal(22," + point + "),sum(sellNum)) NumTotal from officedba.SellReport");
sb.AppendLine("where CompanyCD=@companyCD and convert(char(10),createdate,120) between @begintime and @endtime");
sb.AppendLine("group by ProductName ");
if (orderflag == "0")
{
sb.AppendLine("order by PriceTotal desc,NumTotal DESC");
}
else
{
sb.AppendLine("order by NumTotal desc,PriceTotal DESC");
}
break;
}
SqlParameter[] param = { new SqlParameter("@companyCD", SqlDbType.VarChar, 50),
new SqlParameter("@begintime", SqlDbType.VarChar, 30),
new SqlParameter("@endtime", SqlDbType.VarChar, 30) };
param[0].Value = userinfo.CompanyCD;
param[1].Value = begintime;
param[2].Value = endtime;
return(SqlHelper.ExecuteSqlX(sb.ToString(), param));
}
public static DataSet GetBudgetItem(string projectid, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectBudgetDBHelper.GetBudgetItem(projectid, userinfo));
}
public static DataTable GetProessList(int pageindex, int pagecount, string projectid, string summaryname, string OrderBy, XBase.Common.UserInfoUtil userinfo, ref int totalCount)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("select A.*,B.ProjectName,C.EmployeeName from officedba.ProjectConstructionDetails A ");
sb.AppendLine("left join officedba.ProjectInfo B on A.ProjectID=B.ID");
sb.AppendLine("left join officedba.EmployeeInfo C on A.DutyPerson=C.ID where A.CompanyCD=@CompanyCD");
SqlCommand comm = new SqlCommand();
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", userinfo.CompanyCD));
if (projectid != "0")
{
sb.AppendLine(" and A.ProjectID=@projectID");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@projectID", projectid));
}
if (!string.IsNullOrEmpty(summaryname))
{
sb.AppendLine(" and A.SummaryName like @summaryName");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@summaryName", "%" + summaryname + "%"));
}
if (string.IsNullOrEmpty(OrderBy))
{
OrderBy = "ID";
}
comm.CommandText = sb.ToString();
return(SqlHelper.PagerWithCommand(comm, pageindex, pagecount, OrderBy, ref totalCount));
}
/// <summary>
/// 获取销售状况分析结果列表
/// </summary>
/// <param name="model">检索条件实体</param>
/// <param name="userinfo">session用户信息</param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetSalesFiguresList(XBase.Model.Office.OperatingModel.SalesFiguresAnalysisModel model, XBase.Common.UserInfoUtil userinfo, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
StringBuilder strSql = new StringBuilder();
//销售订单
strSql.AppendLine("select c.ProdNo,c.ProductName,c.Specification,");
strSql.AppendLine("isnull(d.CodeName,'') as UnitName,");
strSql.AppendLine("e.EmployeeName as DealerName,isnull(f.CustName,'') as CustName,a.seller,");
strSql.AppendLine("convert(decimal(22," + userinfo.SelPoint + "),isnull(sum(a.sProductCount),0)) as SellProductCount,");
strSql.AppendLine("convert(decimal(22," + userinfo.SelPoint + "),isnull(sum(a.sTotalFee*a.newRate),0)) as SellTotal,");
strSql.AppendLine("convert(decimal(22," + userinfo.SelPoint + "),isnull(sum(a.backCount),0)) as SellBackCount,");
strSql.AppendLine("convert(decimal(22," + userinfo.SelPoint + "),isnull(sum(a.backTotal*a.newRate),0)) as SellBackTotal");
strSql.AppendLine("from ");
strSql.AppendLine("(select s.ProductID,isnull(s.TotalFee,0) as sTotalFee ,0 as backTotal,0 as backCount,");
if (userinfo.IsMoreUnit)
{
strSql.AppendLine(" s.UsedUnitID as UnitID,isnull(s.UsedUnitCount,0) as sProductCount,");
}
else
{
strSql.AppendLine(" s.UnitID,isnull(s.ProductCount,0) as sProductCount,");
}
strSql.AppendLine(" s2.Seller,s2.CustID,s2.OrderDate as DealDate,isnull(s2.Rate,0) as newRate");
strSql.AppendLine("from officedba.sellorderdetail s ");
strSql.AppendLine("left join officedba.sellorder s2 on s2.OrderNo=s.OrderNo and s2.CompanyCD=s.CompanyCD");
strSql.AppendLine("where s2.BillStatus='2' and s.CompanyCD=@CompanyCD");
strSql.AppendLine("union all ");
//销售退货
strSql.AppendLine("select s3.ProductID,0 as sTotalFee,isnull(s3.TotalFee,0) as backTotal,");
if (userinfo.IsMoreUnit)
{
strSql.AppendLine(" isnull(s3.UsedUnitCount,0) as backCount,s3.UsedUnitID as UnitID,");
}
else
{
strSql.AppendLine(" isnull(s3.ProductCount,0) as backCount,s3.UnitID,");
}
strSql.AppendLine(" 0 as sProductCount,");
strSql.AppendLine(" s4.Seller,s4.CustID,s4.BackDate as DealDate,isnull(s4.Rate,0) as newRate");
strSql.AppendLine("from officedba.sellbackdetail s3 ");
strSql.AppendLine("left join officedba.sellback s4 on s4.BackNo=s3.BackNo and s4.CompanyCD=s3.CompanyCD");
strSql.AppendLine("where s4.BillStatus='2' and s3.CompanyCD=@CompanyCD");
strSql.AppendLine(") as a ");
strSql.AppendLine("left join officedba.productInfo c on c.ID=a.ProductID ");
strSql.AppendLine("left join officedba.CodeUnitType d on d.ID=a.UnitID");
strSql.AppendLine("left join officedba.EmployeeInfo e on e.ID=a.Seller");
strSql.AppendLine("left join officedba.CustInfo f on f.ID=a.CustID");
strSql.AppendLine(" where 1=1 ");
SqlCommand comm = new SqlCommand();
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
//物品编号
if (model.ProductNo != null)
{
strSql.AppendLine(" and c.ProdNo=@ProductNo");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProductNo", model.ProductNo));
}
//物品名称
if (model.ProductName != null)
{
strSql.AppendLine(" and c.ProductName like @ProductName");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProductName", "%" + model.ProductName + "%"));
}
//客户
if (model.CustID != null)
{
strSql.AppendLine(" and a.CustID=@CustID");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CustID", model.CustID));
}
//业务员
if (model.DealerID != null)
{
strSql.AppendLine(" and a.Seller=@Seller");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Seller", model.DealerID));
}
//开始时间
if (model.BeginDate != null)
{
strSql.AppendLine(" and a.DealDate>=@BeginDate");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@BeginDate", model.BeginDate));
}
//结束时间
if (model.EndDate != null)
{
strSql.AppendLine(" and a.DealDate<dateadd(day,-1,@EndDate)");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", model.EndDate));
}
strSql.AppendLine("group by seller,EmployeeName,CustName,c.prodNo,CodeName,ProductName,Specification");
comm.CommandText = strSql.ToString();
return(SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, OrderBy, ref totalCount));
}
public static int CreateMenu(string menuname, string reportid, XBase.Common.UserInfoUtil userinfo, string useridlist)
{
useridlist = useridlist.Trim();
try
{
string ModuleID = string.Empty;
string oldModuleID = string.Empty;
String sqlstr = "select * from defdba.CustomModule where PropertyValue = '" + "Pages/Office/DefManager/ReportTableList.aspx?reportid=" + reportid + "'";
DataTable dt = SqlHelper.ExecuteSql(sqlstr);
if (dt != null && dt.Rows.Count > 0)
{
//修改菜单
sqlstr = "update defdba.CustomModule set PropertyValue='Pages/Office/DefManager/ReportTableList.aspx?reportid=" + reportid + "',ModuleName='" + menuname + "',userdUserList='" + useridlist + "' where ModuleID=" + dt.Rows[0]["ModuleID"].ToString() + " and CompanyCD='" + userinfo.CompanyCD + "'";
SqlHelper.ExecuteSql(sqlstr);
return(1);
}
else
{
//添加菜单
string menuid = System.Configuration.ConfigurationManager.ConnectionStrings["Intelligent"].ToString();
try
{
Convert.ToInt32(menuid);
}
catch { return(0); }
string submenu = menuid + "00";
sqlstr = "select isnull(Max(ModuleID)," + submenu + ") from defdba.CustomModule where parentID='" + menuid + "' and CompanyCD='" + userinfo.CompanyCD + "'";
dt = SqlHelper.ExecuteSql(sqlstr);
if (dt != null)
{
ModuleID = Convert.ToString(Convert.ToInt32(dt.Rows[0][0].ToString()) + 1);
}
else
{
//ModuleID = "22001";
ModuleID = menuid + "01";
}
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("insert into defdba.CustomModule(CompanyCD,ModuleID,ModuleName,ParentID,ModuleType,PropertyType,PropertyValue,userdUserList) values(@companycd,@moduleID,@menuname, @menuid ,'M','link',@pathpage,@userdUserList)");
SqlParameter[] parameters =
{
new SqlParameter("@companycd", SqlDbType.VarChar, 100),
new SqlParameter("@moduleID", SqlDbType.VarChar, 100),
new SqlParameter("@menuname", SqlDbType.VarChar, 100),
new SqlParameter("@menuid", SqlDbType.VarChar, 100),
new SqlParameter("@pathpage", SqlDbType.VarChar, 200),
new SqlParameter("@userdUserList", SqlDbType.VarChar, 1000)
};
parameters[0].Value = userinfo.CompanyCD;
parameters[1].Value = ModuleID;
parameters[2].Value = menuname;
parameters[3].Value = menuid;
parameters[4].Value = "Pages/Office/DefManager/ReportTableList.aspx?reportid=" + reportid;
parameters[5].Value = useridlist;
SqlHelper.ExecuteTransSql(sqlStr.ToString(), parameters);
return(1);
}
}
catch
{
return(0);
}
}
public static DataTable GetSubBedgetGroupList(string projectID, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectBudgetDBHelper.GetSubBedgetGroupList(projectID, userinfo));
}
/// <summary>
/// 绑定项目(同时绑定对应的项目编号)
/// </summary>
/// <param name="ddl"></param>
/// <param name="userinfo"></param>
/// <param name="bindProjectNo">用来重载的任意字符串</param>
public static void BindProject(System.Web.UI.WebControls.DropDownList ddl, XBase.Common.UserInfoUtil userinfo, string bindProjectNo)
{
ProjectBudgetDBHelper.BindProject(ddl, userinfo, bindProjectNo);
}
public static int EditBudgetInfo(BudgetSummary budgetSummary, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectBudgetDBHelper.EditBudgetInfo(budgetSummary, userinfo));
}
/// <summary>
/// 获取审批流程
/// </summary>
/// <param name="ProjectID">项目ID</param>
/// <param name="userInfo">Session用户信息</param>
/// <returns></returns>
public static DataTable GetBudgetFlowStatus(string ProjectID, XBase.Common.UserInfoUtil userInfo)
{
return(ProjectBudgetDBHelper.GetBudgetFlowStatus(ProjectID, userInfo));
}
public static string GetBedgetList(string projectID, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectBudgetDBHelper.GetBedgetList(projectID, userinfo));
}
/// <summary>
/// 获取分项预算概要列表
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagecount"></param>
/// <param name="projectid"></param>
/// <param name="summaryname"></param>
/// <param name="OrderBy"></param>
/// <param name="userinfo"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetSubBudgetList(int pageindex, int pagecount, string projectid, string summaryname, string OrderBy, XBase.Common.UserInfoUtil userinfo, ref int totalCount)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine(" select a.ID,a.projectid,a.BudgetName, ");
strSql.AppendLine(" c.ProjectName,d.status ");
strSql.AppendLine(" from officedba.SubBudget a ");
strSql.AppendLine(" left join officedba.projectInfo c on a.projectid=c.ID");
strSql.AppendLine(" left join officedba.ProjectBudget d on a.ProjectID=d.ProjectID and a.companyCD=d.CompanyCD ");
strSql.AppendLine(" where a.CompanyCD=@CompanyCD ");
SqlCommand comm = new SqlCommand();
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", userinfo.CompanyCD));
if (projectid != "0")
{
strSql.AppendLine(" and a.projectid=@projectID");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@projectID", projectid));
}
if (!string.IsNullOrEmpty(summaryname))
{
strSql.AppendLine(" and a.BudgetName like @BudgetName");
comm.Parameters.Add(SqlHelper.GetParameterFromString("@BudgetName", "%" + summaryname + "%"));
}
comm.CommandText = strSql.ToString();
return(SqlHelper.PagerWithCommand(comm, pageindex, pagecount, OrderBy, ref totalCount));
}
/// <summary>
/// 获取分项预算概要列表
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagecount"></param>
/// <param name="projectid"></param>
/// <param name="summaryname"></param>
/// <param name="OrderBy"></param>
/// <param name="userinfo"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetSubBudgetList(int pageindex, int pagecount, string projectid, string summaryname, string OrderBy, XBase.Common.UserInfoUtil userinfo, ref int totalCount)
{
return(SubBudgetDBHelper.GetSubBudgetList(pageindex, pagecount, projectid, summaryname, OrderBy, userinfo, ref totalCount));
}
/// <summary>
/// 获取销售状况分析结果列表
/// </summary>
/// <param name="model">检索条件实体</param>
/// <param name="userinfo">session用户信息</param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetSalesFiguresList(XBase.Model.Office.OperatingModel.SalesFiguresAnalysisModel model, XBase.Common.UserInfoUtil userinfo, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
return(SalesFiguresAnalysisDBHelper.GetSalesFiguresList(model, userinfo, pageIndex, pageCount, OrderBy, ref totalCount));
}
public static int AddBudgetPriceInfo(BudgetPrice budgetPrice, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectBudgetDBHelper.AddBudgetPriceInfo(budgetPrice, userinfo));
}
public static DataSet GetProssList(string projectID, XBase.Common.UserInfoUtil userinfo)
{
return(ProjectGanttDBHelper.GetProssList(projectID, userinfo));
}
public static int AddSubBudgetInfo(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo)
{
return(SubBudgetDBHelper.AddSubBudgetInfo(subBudgetModel, userinfo));
}
public static int EditSubBudget(SubBudgetModel subBudgetModel, XBase.Common.UserInfoUtil userinfo)
{
return(SubBudgetDBHelper.EditSubBudget(subBudgetModel, userinfo));
}
/// <summary>
/// 根据项目获得所有分项预算概要
/// </summary>
/// <param name="userinfo">用户信息</param>
/// <param name="projectID">项目代码</param>
public static DataTable GetSubBedget(XBase.Common.UserInfoUtil userinfo, int projectID)
{
return(ProjectBudgetDBHelper.GetSubBedget(userinfo, projectID));
}
