/// <summary>
/// 花费金额
/// </summary>
/// <param name="begDate"></param>
/// <param name="endDate"></param>
/// <param name="deptCode"></param>
/// <param name="kmCode"></param>
/// <param name="strflowid"></param>
/// <returns></returns>
public decimal GetYueHfje(DateTime begDate, DateTime endDate, string deptCode, string kmCode, string strflowid)
{
DepartmentDal deptDal = new DepartmentDal();
string sql = @" select round(isnull(sum(je),0),2) from bill_ybbxmxb_fykm
where billcode in (
select billcode
from bill_ybbxmxb
where bxmxlx in (select isnull(diccode,'1')
from bill_datadic where cjys='1')
)
and fykm=@kmCode
and billCode in (
select billCode
from bill_main
where convert(varchar(10),billDate,121)>=@begDate and convert(varchar(10),billDate,121)<@endDate
and (flowid=@flowid)
and gkdept=@gkdept
)";
SqlParameter[] sps =
{
new SqlParameter("@kmCode", kmCode),
new SqlParameter("@begDate", begDate.ToString("yyyy-MM-dd")),
new SqlParameter("@endDate", endDate.ToString("yyyy-MM-dd")),
new SqlParameter("@gkdept", deptCode),
new SqlParameter("@flowid", strflowid)
};
return(Convert.ToDecimal(DataHelper.ExecuteScalar(sql, sps, false)));
}
public ActionResult GetAllDep()
{
DepartmentDal depd = new DepartmentDal();
IQueryable <Department> iq = depd.GetEntities(u => u.Dep_Id > 0);
string deplist = "";
foreach (var item in iq)
{
deplist = deplist + item.Dep_Name + "-";
}
Response.Write(deplist);
Response.End();
return(View());
}
private void BindData()
{
pager.PageSize = PagingSize;
DepartmentDal departmentDal = new DepartmentDal();
string filter = null;
if (ViewState["Filter"] != null)
{
filter = ViewState["Filter"].ToString();
}
pager.RecordCount = departmentDal.GetCount(filter);
DataTable table = departmentDal.GetAll(pageIndex, PagingSize, filter);
BindTable2GridView(gvMain, table);
}
//学院
static void GenerateDepartment(int num)
{
DepartmentDal dal = new DepartmentDal();
DbSession dbSession = new DbSession();
for (int i = 0; i < num; i++)
{
Department major = new Department();
major.DepartmentName = "Department_____" + i.ToString();
major.ModfiedOn = Convert.ToDateTime(Faker.Business.CreditCardExpiryDate());
major.CreateTime = major.ModfiedOn.Value.AddMonths(-3);
major.Status = Faker.Boolean.Next() ? (short)1 : (short)0;
dal.Add(major);
}
dbSession.SaveChanges();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
//保存修改到数据库
try
{
DepartmentDal departmentDal = new DepartmentDal();
if (ViewState["OP"].ToString() == "ADD")
{
departmentDal.Insert(txtDepartmentName.Text, txtRemark.Text);
}
else
{
departmentDal.Save(txtDepartmentID.Text, txtDepartmentName.Text, txtRemark.Text);
}
JScript.Instance.ShowMessage(UpdatePanel1, "保存数据成功。");
}
catch (Exception ex)
{
JScript.Instance.ShowMessage(UpdatePanel1, string.Format("保存数据失败，原因：'{0}'", ex.Message));
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
DepartmentDal departmentDal = new DepartmentDal();
int deleteCount = 0;
foreach (GridViewRow row in gvMain.Rows)
{
if (row.Cells[0].Controls.Count != 0 && ((CheckBox)row.Cells[0].Controls[0]).Checked)
{
departmentDal.Delete(row.Cells[2].Text);
deleteCount++;
}
}
if (deleteCount == 0)
{
JScript.Instance.ShowMessage(UpdatePanel1, "请选择要删除的记录。");
}
else
{
JScript.Instance.ShowMessage(UpdatePanel1, "删除数据成功。");
}
BindData();
}
/// <summary>
/// 查找指定条件的部门分页集合
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <param name="pager">分页对象</param>
/// <param name="tran">中间事务对象</param>
/// <returns>返回查找到的分页集合，包括按条件可查询到的所有记录数和当前分页的对象集合</returns>
public static PageList <Department> FindDepartmentList(DepartmentSearcher departmentSearcher, Pager pager, ICTransaction tran)
{
return(DepartmentDal.FindList(departmentSearcher, pager, tran));
}
/// <summary>
/// 查找指定条件的部门集合
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <returns>返回部门实体对象集合</returns>
public static IList <Department> FindDepartmentList(DepartmentSearcher departmentSearcher)
{
return(DepartmentDal.FindList(departmentSearcher));
}
/// <summary>
/// 查找指定条件的部门分页集合
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <param name="pager">分页对象</param>
/// <returns>返回查找到的分页集合，包括按条件可查询到的所有记录数和当前分页的对象集合</returns>
public static PageList <Department> FindDepartmentList(DepartmentSearcher departmentSearcher, Pager pager)
{
return(DepartmentDal.FindList(departmentSearcher, pager));
}
private DepartmentManager()
{
departmentDal = DepartmentDal.GetInstance();
}
/// <summary>
/// 查找指定ID的部门
/// </summary>
/// <param name="departmentId">部门ID</param>
/// <param name="tran">中间事务对象</param>
/// <returns>返回部门实体对象</returns>
public static Department FindDepartmentById(string departmentId, ICTransaction tran)
{
return(DepartmentDal.FindSingle(departmentId, tran));
}
/// <summary>
/// 根据指定条件查找部门分页集合
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <param name="pager">分页对象</param>
/// <param name="tran">中间事务对象</param>
/// <returns>返回查找到的分页集合，包括按条件可查询到的所有记录数和当前分页的DataTable数据</returns>
public static PageDataTable FindDepartmentDataTable(DepartmentSearcher departmentSearcher, Pager pager, ICTransaction tran)
{
return(DepartmentDal.FindDataTable(departmentSearcher, pager, tran));
}
/// <summary>
/// 新建部门
/// </summary>
/// <param name="department">部门实体对象</param>
/// <returns>返回处理后的部门实体对象</returns>
public static Department AddDepartment(Department department)
{
return(DepartmentDal.Add(department));
}
/// <summary>
/// 删除部门
/// </summary>
/// <param name="departmentId">部门ID</param>
public static void DeleteDepartment(string departmentId)
{
DepartmentDal.Delete(departmentId);
}
/// <summary>
/// 删除部门
/// </summary>
/// <param name="departmentId">部门ID</param>
/// <param name="tran">中间事务对象</param>
public static void DeleteDepartment(string departmentId, ICTransaction tran)
{
DepartmentDal.Delete(departmentId, tran);
}
/// <summary>
/// 查询部门数量
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <returns>返回查询到的数量</returns>
public static long CountDepartment(DepartmentSearcher departmentSearcher)
{
long count = DepartmentDal.Count(departmentSearcher);
return(count);
}
/// <summary>
/// 查询部门数量
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <param name="tran">中间事务对象</param>
/// <returns>返回查询到的数量</returns>
public static long CountDepartment(DepartmentSearcher departmentSearcher, ICTransaction tran)
{
long count = DepartmentDal.Count(departmentSearcher, tran);
return(count);
}
/// <summary>
/// 批量新建部门
/// </summary>
/// <param name="departmentList">部门实体对象集合</param>
/// <param name="tran">中间事务对象</param>
/// <returns>返回处理后的部门实体对象集合</returns>
public static IList <Department> AddDepartment(IList <Department> departmentList, ICTransaction tran)
{
return(DepartmentDal.Add(departmentList, tran));
}
/// <summary>
/// 批量新建部门
/// </summary>
/// <param name="departmentList">部门实体对象集合</param>
/// <returns>返回处理后的部门实体对象集合</returns>
public static IList <Department> AddDepartment(IList <Department> departmentList)
{
return(DepartmentDal.Add(departmentList));
}
/// <summary>
/// 新建部门
/// </summary>
/// <param name="department">部门实体对象</param>
/// <param name="tran">中间事务对象</param>
/// <returns>返回处理后的部门实体对象</returns>
public static Department AddDepartment(Department department, ICTransaction tran)
{
return(DepartmentDal.Add(department, tran));
}
/// <summary>
/// 根据指定条件查找部门集合
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <returns>返回一个DataTable对象</returns>
public static DataTable FindDepartmentDataTable(DepartmentSearcher departmentSearcher)
{
return(DepartmentDal.FindDataTable(departmentSearcher));
}
/// <summary>
/// 更新部门数据
/// </summary>
/// <param name="department">部门实体对象</param>
/// <param name="tran">中间事务对象</param>
public static void UpdateDepartment(Department department, ICTransaction tran)
{
DepartmentDal.Update(department, tran);
}
/// <summary>
/// 根据指定条件查找部门分页集合
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <param name="pager">分页对象</param>
/// <returns>返回查找到的分页集合，包括按条件可查询到的所有记录数和当前分页的DataTable数据</returns>
public static PageDataTable FindDepartmentDataTable(DepartmentSearcher departmentSearcher, Pager pager)
{
return(DepartmentDal.FindDataTable(departmentSearcher, pager));
}
/// <summary>
/// 更新部门数据
/// </summary>
/// <param name="departmentList">部门实体对象</param>
/// <param name="tran">中间事务对象</param>
public static void UpdateDepartment(IList <Department> departmentList, ICTransaction tran)
{
DepartmentDal.Update(departmentList, tran);
}
/// <summary>
/// 更新部门数据
/// </summary>
/// <param name="department">部门实体对象</param>
public static void UpdateDepartment(Department department)
{
DepartmentDal.Update(department);
}
public DepartmentBS()
{
deparmentDal = new DepartmentDal();
}
/// <summary>
/// 更新部门数据
/// </summary>
/// <param name="departmentList">部门实体对象</param>
public static void UpdateDepartment(IList <Department> departmentList)
{
DepartmentDal.Update(departmentList);
}
/// <summary>
/// 根据指定条件删除部门
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
/// <param name="tran">中间事务对象</param>
public static void DeleteDepartment(DepartmentSearcher departmentSearcher, ICTransaction tran)
{
DepartmentDal.Delete(departmentSearcher, tran);
}
/// <summary>
/// 根据指定条件删除部门
/// </summary>
/// <param name="departmentSearcher">部门查询对象</param>
public static void DeleteDepartment(DepartmentSearcher departmentSearcher)
{
DepartmentDal.Delete(departmentSearcher);
}
/// <summary>
/// 查找指定ID的部门
/// </summary>
/// <param name="departmentId">部门ID</param>
/// <returns>返回部门实体对象</returns>
public static Department FindDepartmentById(string departmentId)
{
return(DepartmentDal.FindSingle(departmentId));
}
