/// <summary>
/// 删除资金申请记录
/// </summary>
/// <param name="billcode"></param>
public void DeleteZjsq(string billcode)
{
//删除bill_main表
MainDal mdal = new MainDal();
mdal.DeleteMain(billcode);
}
/// <summary>
/// post worker selected order data
/// </summary>
/// <param name="worker_no">worker_no</param>
/// <param name="wkaOrders">order which match to the order</param>
/// <returns>worker selected order data</returns>
public bool PostWorkerSelectedOrderData(string worker_no, List <Dictionary <string, string> > wkaOrders)
{
IMainDal dal = new MainDal();
if (string.IsNullOrWhiteSpace(worker_no))
{
return(false);
}
if (wkaOrders == null || wkaOrders.Count == 0)
{
return(false);
}
try
{
wkaOrders.ForEach(a =>
{
Dictionary <string, object> pms = new Dictionary <string, object>();
pms.Add("wka_no", a.Keys.Contains("wka_no") ? a["wka_no"] : string.Empty);
pms.Add("mo_no", a.Keys.Contains("mo_no") ? a["mo_no"] : string.Empty);
pms.Add("worker_no", worker_no);
dal.CUDByPms("Operator", "PostWorkerSelectedOrderData", pms);
});
return(true);
}
catch (Exception ex)
{
LogTool.Error(ex);
return(false);
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
MainDal dal = new MainDal();
}
/// <summary>
/// get worker selected order data
/// </summary>
/// <param name="worker_no">worker no</param>
/// <returns>worker selected order data</returns>
public List <WorkerSelectedOrderView> GetWorkerSelectedOrderData(string worker_no)
{
IMainDal dal = new MainDal();
Dictionary <string, object> pms = new Dictionary <string, object>();
pms.Add("worker_no", worker_no);
return(dal.ReadModelListByPms <WorkerSelectedOrderView>("Operator", "GetWorkerSelectedOrderData", pms));
}
/// <summary>
/// get all wkc has been selected by worker
/// </summary>
/// <param name="worker_no">current worker no</param>
/// <returns>all wkc has been selected by this worker</returns>
public List <WorkerSelectedWkcView> GetWorkerSelectedWkc(string worker_no)
{
IMainDal dal = new MainDal();
Dictionary <string, object> pms = new Dictionary <string, object>();
pms.Add("worker_no", string.Format("%{0}%", worker_no));
return(dal.ReadModelListByPms <WorkerSelectedWkcView>("Operator", "GetWorkerSelectedWkc", pms));
}
public void DeleteTravelReportBill(string billCode)
{
//删除bill_main表
MainDal mdal = new MainDal();
mdal.DeleteMain(billCode);
new Bill_TravelReportBLL().Delete(billCode);
}
/// <summary>
/// 删除出差申请单
/// </summary>
public void DeleteTravelApplicationBill(string strBillCode)
{
//删除bill_main表
MainDal mdal = new MainDal();
mdal.DeleteMain(strBillCode);
new bill_travelApplicationBLL().Delete(strBillCode);
}
/// <summary>
/// post all wkc has been selected by worker
/// </summary>
/// <param name="worker_no">current worker no</param>
/// <param name="wkaNos">wka has been selected</param>
/// <returns>is post action success</returns>
public bool PostWorkerSelectedWka(string worker_no, List <string> wkaNos)
{
IMainDal dal = new MainDal();
Dictionary <string, object> pms = new Dictionary <string, object>();
pms.Add("worker_no", worker_no);
pms.Add("wka_no", wkaNos);
return(dal.CUDByPms("Operator", "PostWorkerSelectedWka", pms) > 0);
}
/// <summary>
/// get current worker
/// </summary>
/// <param name="worker_no">worker_no</param>
/// <returns>current worker entity</returns>
public Me_worker GetCurrentWorker(string worker_no)
{
IMainDal dal = new MainDal();
Dictionary <string, object> pms = new Dictionary <string, object>();
pms.Add("worker_no", worker_no);
Me_worker tmp = dal.ReadModelByPms <Me_worker>(pms);
return(tmp);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="MainCode"></param>
/// <param name="tran"></param>
/// <returns></returns>
public int Delete(string MainCode)
{
MainDal mdal = new MainDal();
mdal.DeleteMain(MainCode);
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from bill_zfzxsqd_dz ");
strSql.Append(" where billcode=@MainCode ");
SqlParameter[] parameters =
{
new SqlParameter("@MainCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = MainCode;
return(DataHelper.ExcuteNonQuery(strSql.ToString(), parameters, false));
}
/// <summary>
/// 根据部门求话费金额
/// </summary>
/// <param name="gcbh"></param>
/// <param name="deptCode"></param>
/// <returns></returns>
//public decimal GetYueHf_dept(string gcbh, string deptCode)
//{
// string strflowid = "";
// DateTime begDate = new DateTime();
// DateTime endDate = new DateTime();
// string strcn = new ConfigBLL().GetValueByKey("CYLX");//是否是财年
// if (!string.IsNullOrEmpty(strcn) && strcn == "Y")
// {
// string strsql = " select * from bill_ysgc where gcbh='" + gcbh + "'";
// DataTable dttime = new sqlHelper.sqlHelper().GetDataTable(strsql, null);//根据计划过程获取开始结束时间
// if (dttime != null && dttime.Rows.Count > 0)
// {
// begDate = Convert.ToDateTime(dttime.Rows[0]["kssj"].ToString());
// endDate = Convert.ToDateTime(dttime.Rows[0]["jzsj"].ToString());
// }
// }
// else
// {
// string[] temp = GetYsYearMonth(gcbh);
// string[] yf = temp[2].Split('|');
// begDate = new DateTime(Int32.Parse(temp[0]), Int32.Parse(yf[0]), 1);
// endDate = new DateTime(Int32.Parse(temp[0]), Int32.Parse(yf[yf.Length - 1]), 1).AddMonths(1);
// }
// //返回花费金额
// string je = new sqlHelper.sqlHelper().GetCellValue("exec dz_deptsyje '" + begDate + "','" + endDate + "','" + deptCode + "'");
// decimal deje = 0;
// decimal.TryParse(je, out deje);
// return deje;
//}
public decimal GetYueHf_tf(string gcbh, string deptCode, string kmCode, string strdydj)
{
string strflowid = "";
DateTime begDate = new DateTime();
DateTime endDate = new DateTime();
string strcn = new ConfigBLL().GetValueByKey("CYLX");//是否是财年
if (!string.IsNullOrEmpty(strcn) && strcn == "Y" && (!string.IsNullOrEmpty(strdydj)))
{
string strsql = " select * from bill_ysgc where gcbh='" + gcbh + "'";
DataTable dttime = new sqlHelper.sqlHelper().GetDataTable(strsql, null);//根据计划过程获取开始结束时间
if (dttime != null && dttime.Rows.Count > 0)
{
begDate = Convert.ToDateTime(dttime.Rows[0]["kssj"].ToString());
endDate = Convert.ToDateTime(dttime.Rows[0]["jzsj"].ToString());
}
}
else
{
string[] temp = GetYsYearMonth(gcbh);
string[] yf = temp[2].Split('|');
begDate = new DateTime(Int32.Parse(temp[0]), Int32.Parse(yf[0]), 1);
endDate = new DateTime(Int32.Parse(temp[0]), Int32.Parse(yf[yf.Length - 1]), 1).AddMonths(1);
}
//返回花费金额
//hfje=new sqlHelper.sqlHelper().GetCellValue("exec dz_hfje '"++"','','',''")
//根据对应单据找出对应决算flowid
if (!string.IsNullOrEmpty(strdydj))
{
MainDal maindal = new MainDal();
strflowid = "tfsq";// maindal.getJSFlowId(strdydj);
return(ysDal.GetYueHfje(begDate, endDate, deptCode, kmCode, strflowid));
}
else
{
return(ysDal.GetYueHfje(begDate, endDate, deptCode, kmCode));
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public int Delete(string sqbh)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
int iRel = Delete(sqbh, tran);
MainDal mdal = new MainDal();
mdal.DeleteMain(sqbh, tran);
tran.Commit();
return(iRel);
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public int Delete(string MainCode)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
MainDal maindal = new MainDal();
maindal.DeleteMain(MainCode, tran);
int intRows = Delete(MainCode, tran);
tran.Commit();
return(intRows);
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public int Delete(string Listid)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
int row = Delete(Listid, tran);
DeleteItem(Listid, tran);
MainDal mdal = new MainDal();
mdal.DeleteMain(Listid, tran);
tran.Commit();
return(row);
}
catch
{
tran.Rollback();
throw;
}
}
}
public bool Edit(Bill_Main main, ZiChan_ChuZhiDan sqmodel)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
MainDal maindal = new MainDal();
maindal.DeleteMain(main.BillCode, tran);
Delete(main.BillCode, tran);
maindal.InsertMain(main, tran);
Add(sqmodel, tran);
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="mainModel"></param>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Bill_Main mainModel, dz_yksqd model)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
Delete(model.sqbh, tran);
MainDal maindal = new MainDal();
maindal.DeleteMain(mainModel.BillCode);
maindal.InsertMain(mainModel);
int iRel = Add(model, tran);
tran.Commit();
return(iRel);
}
catch
{
tran.Rollback();
throw;
}
}
}
public bool Add(Bill_Main main, IList <ZiChan_ChuZhiDan> czLists)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
MainDal maindal = new MainDal();
maindal.InsertMain(main, tran);
foreach (var i in czLists)
{
Add(i, tran);
}
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
throw;
}
}
}
/// <summary>
/// query record list in view model
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pms">query parameter</param>
/// <returns>view model list result</returns>
public virtual List <Dictionary <string, object> > QueryRecordList(string sqlFileName, string sqlId, Dictionary <string, object> pms)
{
IMainDal dal = new MainDal();
return(dal.ReadRecordListByPms(sqlFileName, sqlId, pms));
}
/// <summary>
///
/// </summary>
/// <param name="gcbh"></param>
/// <param name="deptCode"></param>
/// <param name="kmCode"></param>
/// <param name="billdate"></param>
/// <returns></returns>
public decimal GetYueHf(string gcbh, string deptCode, string kmCode, string strdydj)
{
string strflowid = "";
DateTime begDate = new DateTime();
DateTime endDate = new DateTime();
string strcn = new ConfigBLL().GetValueByKey("CYLX");//是否是财年
if (!string.IsNullOrEmpty(strcn) && strcn == "Y" && (!string.IsNullOrEmpty(strdydj)))
{
string strsql = " select * from bill_ysgc where gcbh='" + gcbh + "'";
DataTable dttime = new sqlHelper.sqlHelper().GetDataTable(strsql, null);//根据计划过程获取开始结束时间
if (dttime != null && dttime.Rows.Count > 0)
{
begDate = Convert.ToDateTime(dttime.Rows[0]["kssj"].ToString());
endDate = Convert.ToDateTime(dttime.Rows[0]["jzsj"].ToString());
}
}
else
{
string[] temp = GetYsYearMonth(gcbh);
string[] yf = temp[2].Split('|');
begDate = new DateTime(Int32.Parse(temp[0]), Int32.Parse(yf[0]), 1);
endDate = new DateTime(Int32.Parse(temp[0]), Int32.Parse(yf[yf.Length - 1]), 1).AddMonths(1);
}
//返回花费金额
//hfje=new sqlHelper.sqlHelper().GetCellValue("exec dz_hfje '"++"','','',''")
bool dz_syys_flg = new ConfigBLL().GetValueByKey("dz_syys_flg").Equals("1");//大智剩余预算取值方式flg 大智的取值通过存储过程 dz_hfje
if (!dz_syys_flg)
{
//根据对应单据找出对应决算flowid
if (!string.IsNullOrEmpty(strdydj))
{
MainDal maindal = new MainDal();
strflowid = maindal.getJSFlowId(strdydj);
return(ysDal.GetYueHfje(begDate, endDate, deptCode, kmCode, strflowid));
}
else
{
return(ysDal.GetYueHfje(begDate, endDate, deptCode, kmCode));
}
}
else
{
decimal deje = 0;
////string nd = "";
////string strcnyf = "";
////根据过程编号获取年月
// // exec [dz_hfje_bxd] '0119','2017','020107','2017-02'
// //string strsql_new = @"exec dz_hfje_bxd '" + begDate + "','" + endDate + "','" + deptCode + "','" + kmCode + "'";
// try
// {
// string strcnyfsql = @"select nian + '-' +right('0'+ yue,2) as cnyf ,*
// from bill_ysgc where gcbh='" + gcbh + "' and ysType = 2 ";
// DataTable dtysgc = new sqlHelper.sqlHelper().GetDataTable(strcnyfsql, null);
// if (dtysgc!=null&&dtysgc.Rows.Count>0)
// {
// nd = dtysgc.Rows[0]["nian"].ToString();
// strcnyf = dtysgc.Rows[0]["cnyf"].ToString();
// }
// IList<yskmhf> ysmxb_hf = new Bll.newysgl.bill_ysmxbBll().getkmje(deptCode, nd);
// string strje = ysmxb_hf.Where(p => p.fykm == kmCode && p.cnyf == strcnyf).Sum(p => p.je).ToString();
// if (decimal.TryParse(strje, out deje))
// {
// return deje;
// }
// else
// {
// return 0;
// }
// }
// catch (Exception)
// {
// return 0;
// }
string strsql = @"exec dz_hfje '" + begDate + "','" + endDate + "','" + deptCode + "','" + kmCode + "'";
try
{
string je = new sqlHelper.sqlHelper().GetCellValue(strsql);
if (!string.IsNullOrEmpty(je))
{
decimal.TryParse(je, out deje);
}
return(deje);
}
catch (Exception)
{
return(0);
}
}
}
/// <summary>
/// get submit source data from scada server
/// </summary>
/// <returns></returns>
public List <Mes_ua_submit> GetSubmitSourceDataFromScada()
{
IMainDal dal = new MainDal();
return(dal.ReadModelListByPms <Mes_ua_submit>("Scada", "GetSubmitSourceDataFromScada"));
}
/// <summary>
/// create model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="modelList">model list</param>
/// <returns>create model quantity</returns>
public virtual int CreateByModel <T>(List <T> modelList) where T : class
{
IMainDal dal = new MainDal();
return(dal.CreateByModel(modelList));
}
/// <summary>
/// delete model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="pms">query parameter</param>
/// <returns>delete model quantity</returns>
public virtual int DeleteModelByPms <T>(Dictionary <string, object> pms) where T : class
{
IMainDal dal = new MainDal();
return(dal.DeleteByPms(typeof(T).Name, pms));
}
/// <summary>
/// read single model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="pms">query parameter</param>
/// <returns>model list</returns>
public virtual List <T> ReadModelListByPms <T>(Dictionary <string, object> pms) where T : class
{
IMainDal dal = new MainDal();
return(dal.ReadModelListByPms <T>(pms));
}
/// <summary>
/// update model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="model">model</param>
/// <returns>update model quantity</returns>
public virtual int UpdateByModel <T>(T model) where T : class
{
IMainDal dal = new MainDal();
return(dal.UpdateByModel <T>(model));
}
/// <summary>
/// query int
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsList">query parameter list</param>
/// <returns>int result</returns>
public virtual int QueryInt(string sqlFileName, string sqlId, List <Dictionary <string, object> > pmsList)
{
IMainDal dal = new MainDal();
return(dal.CUDByPms(sqlFileName, sqlId, pmsList));
}
/// <summary>
/// read all models
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <returns>all models</returns>
public virtual List <T> Index <T>() where T : class
{
IMainDal dal = new MainDal();
return(dal.Index <T>());
}
/// <summary>
/// query object
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pms">query parameter</param>
/// <returns>object result</returns>
public virtual object QueryObj(string sqlFileName, string sqlId, Dictionary <string, object> pms)
{
IMainDal dal = new MainDal();
return(dal.QueryObj(sqlFileName, sqlId, pms));
}
/// <summary>
/// page
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="pageIndex">page index</param>
/// <param name="pageSize">page size</param>
/// <returns>page result</returns>
public virtual Tuple <int, List <T> > Page <T>(int pageIndex, int pageSize) where T : class
{
IMainDal dal = new MainDal();
return(dal.Page <T>(pageIndex, pageSize));
}
