public bool updateTran(TB_Good model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
public bool updateTran(TB_ToInvoice model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
model.State = eform.state;
objCommand.Parameters.Clear();
model.UpAccount = accountXishu(model, eform, objCommand);
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
//判断是否是删除 -到款单删除
if (eform.proId == 38 && eform.state == "通过")
{
//及到款单删除会有两个层面，
//1，预付款模式，这时只需要在审批的最后一个流程总经理点确定时，删除相应的到款单；并弹出一个提示框，该预付到款单已删除，点确定，完成。
//2，发票到款模式，我们需要在最后一个审批流程点确定时，删除相应项目编号针对该发票号的发票签回单（如果有在审批执行中或已完成审批的），再删除该项目编号针对该发票号的到款单，
//并弹出一个提示框，该发票到款单已删除，点确定，完成。
if (model.BusType == 0)//实际发票到款
{
//删除发票签回单（如果有）
string deleteFPBack = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0}));", model.FPId);
deleteFPBack += string.Format("delete tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0});", model.FPId);
deleteFPBack += string.Format("delete Sell_OrderFPBacks where Id in (select id from Sell_OrderFPBack where PId={0});delete Sell_OrderFPBack where PId={0};", model.FPId);
objCommand.CommandText = deleteFPBack;
objCommand.ExecuteNonQuery();
}
//删除发票删除单 审批流
string deleteFPDelete = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId in (26,34,37) and allE_id={0});", model.Id);
deleteFPDelete += string.Format("delete tb_EForm where proId in (27,38) and allE_id={0};", model.Id);
objCommand.CommandText = deleteFPDelete;
objCommand.ExecuteNonQuery();
string DeleteAll = string.Format("delete from [TB_ToInvoice] where id={0};", model.Id);
objCommand.CommandText = DeleteAll;
objCommand.ExecuteNonQuery();
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
public bool updateTran(VAN_OA.Model.JXC.TB_SupplierAdvancePayment model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <SupplierToInvoiceView> orders, string IDS)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
TB_SupplierAdvancePaymentsService OrdersSer = new TB_SupplierAdvancePaymentsService();
for (int i = 0; i < orders.Count; i++)
{
if (orders[i].IfCheck == false)
{
continue;
}
var modelSupplierInvoices = new TB_SupplierAdvancePayments();
modelSupplierInvoices.Ids = orders[i].payIds;
modelSupplierInvoices.Id = model.Id;
modelSupplierInvoices.CaiIds = orders[i].Ids;
modelSupplierInvoices.SupplierFPNo = orders[i].SupplierFPNo;
modelSupplierInvoices.SupplierInvoiceDate = orders[i].SupplierInvoiceDate.Value;
modelSupplierInvoices.SupplierInvoiceNum = orders[i].SupplierInvoiceNum;
modelSupplierInvoices.SupplierInvoicePrice = orders[i].SupplierInvoicePrice;
modelSupplierInvoices.SupplierInvoiceTotal = orders[i].SupplierInvoiceTotal;
if (eform.state == "通过" && (orders[i].SupplierProNo == null || orders[i].SupplierProNo == ""))
{
modelSupplierInvoices.SupplierProNo = GetAllE_No("TB_SupplierAdvancePayments", objCommand);
}
OrdersSer.Update(modelSupplierInvoices, objCommand);
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
public bool updateTran(VAN_OA.Model.JXC.Sell_OrderOutHouseBack model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <Sell_OrderOutHouseBacks> orders, string IDS)
{
decimal total = 0;
for (int i = 0; i < orders.Count; i++)
{
total += orders[i].GoodSellPriceTotal;
}
model.SellTotal = total;
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
Sell_OrderOutHouseBacksService OrdersSer = new Sell_OrderOutHouseBacksService();
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
//====删除所有子单据
string delete = "delete from Sell_OrderOutHouseBacks where id=" + model.Id;
objCommand.CommandText = delete;
objCommand.ExecuteNonQuery();
//====
for (int i = 0; i < orders.Count; i++)
{
orders[i].id = model.Id;
OrdersSer.Add(orders[i], objCommand);
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
if (Session["backurl"] != null)
{
Button2.Visible = false;
}
else
{
Button1.Visible = false;
}
lbtnSelectPONo.Visible = false;
DataTable cardInfo = DBHelp.getDataTable("select BusNo as CardNo from Base_BusInfo where IsStop=0");
ddlCardNo.DataSource = cardInfo;
ddlCardNo.DataBind();
List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
user = userSer.getZaiZhiList(" and loginStatus='在职' and loginName<>'admin'");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "LoginName";
if (base.Request["ProId"] != null)
{
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
lbtnSelectPONo.Visible = true;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(0, Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else if (Request["ReAudit"] != null)//再次编辑
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
ShowInfo(Convert.ToInt32(base.Request["allE_id"]));
#endregion
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
ShowInfo(Convert.ToInt32(base.Request["allE_id"]));
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
public bool updateTran(VAN_OA.Model.JXC.Sell_OrderInHouse model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <Sell_OrderInHouses> orders, string IDS)
{
decimal total = 0;
for (int i = 0; i < orders.Count; i++)
{
total += orders[i].GoodSellPriceTotal;
}
model.TuiTotal = total;
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
Sell_OrderInHousesService OrdersSer = new Sell_OrderInHousesService();
//CG_POOrdersService OrdersSer = new CG_POOrdersService();
//CG_POCaiService CaiSer = new CG_POCaiService();
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
TB_HouseGoodsService houseGoodsSer = new TB_HouseGoodsService();
for (int i = 0; i < orders.Count; i++)
{
if (orders[i].GoodPriceSecond != 0)
{
orders[i].id = model.Id;
OrdersSer.Update(orders[i], objCommand);
}
//else if (orders[i].Ids == 0)
//{
// OrdersSer.Add(orders[i], objCommand);
//}
}
//if (IDS != "")
//{
// IDS = IDS.Substring(0, IDS.Length - 1);
// OrdersSer.DeleteByIds(IDS, objCommand);
//}
for (int i = 0; i < orders.Count; i++)
{
if (eform.state == "通过")
{
if (orders[i].GoodPriceSecond != 0)
{
houseGoodsSer.InHouse(orders[i].HouseID, orders[i].GooId, orders[i].GoodNum, orders[i].GoodPriceSecond, objCommand);
}
else
{
houseGoodsSer.InHouse(orders[i].HouseID, orders[i].GooId, orders[i].GoodNum, orders[i].GoodPrice, objCommand);
}
}
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
if (use == null)
{
use = new VAN_OA.Model.User();
}
txtName.Text = use.LoginName;
txtDepartName.Text = use.LoginIPosition;
btnFinSub.Visible = false;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtAppDate.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
txtBackTime.ReadOnly = true;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(0, Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
// ddlPers.DataSource = roleUserList;
//}
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.SelectedIndex = roleUserList.FindIndex(t => t.UserName == use.LoginName);
}
catch (Exception)
{
}
}
else
{
txtBackTime.Enabled = true;
lblPer.Visible = false;
ddlPers.Visible = false;
fuAttach.Visible = true;
}
}
else
{
txtBackTime.Enabled = true;
lblPer.Visible = false;
ddlPers.Visible = false;
fuAttach.Visible = true;
}
}
else//单据审批
{
#region MyRegion
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
tb_BusContactService busSer = new tb_BusContactService();
tb_BusContact busModel = busSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDepartName.Text = busModel.DepartName;
txtContacer.Text = busModel.Contacer;
txtContactUnit.Text = busModel.ContactUnit;
txtDateTime.Text = Convert.ToDateTime(busModel.DateTime).ToShortDateString().ToString();
txtName.Text = busModel.Name;
txtTel.Text = busModel.Tel;
if (busModel.Gotime != null)
{
txtGotime.Text = busModel.Gotime.Value.ToShortTimeString();
}
if (busModel.BackTime != null)
{
txtBackTime.Text = busModel.BackTime.Value.ToShortTimeString();
}
if (busModel.AppDate != null)
{
txtAppDate.Text = busModel.AppDate.Value.ToString("yyyy-MM-dd hh:mm:ss");
}
;
lblProNo.Text = busModel.ProNo;
if (busModel.fileName != null && busModel.fileName != "")
{
lblAttName.Visible = true;
lblAttName.Text = busModel.fileName;
lblAttName_Vis.Text = busModel.fileName.Substring(0, busModel.fileName.LastIndexOf('.')) + "_" + busModel.id + busModel.fileName.Substring(busModel.fileName.LastIndexOf('.'));
}
cbIsNewUnit.Checked = busModel.IsNewUnit;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
fuAttach.Visible = true;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.SelectedIndex = roleUserList.FindIndex(t => t.UserName == busModel.Name);
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
fuAttach.Visible = true;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.SelectedIndex = roleUserList.FindIndex(t => t.UserName == busModel.Name);
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
#endregion
txtGotime.ReadOnly = true;
//判断该单据是否为自己申请
string sql = string.Format("select appPer from tb_EForm where proId={0} and allE_id={1}", Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]));
//if (Session["currentUserId"].ToString() == DBHelp.ExeScalar(sql).ToString())
//{
// // setEnable(false);
// //txtBackTime.Enabled = true;
// //btnFinSub.Visible = true;
//}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
btnOk.Visible = false;
VAN_OA.Dal.BaseInfo.Tb_InventoryService invSer = new VAN_OA.Dal.BaseInfo.Tb_InventoryService();
List <VAN_OA.Model.BaseInfo.Tb_Inventory> InventoryList = invSer.GetListArrayToDdl("");
ddlInvs.DataSource = InventoryList;
ddlInvs.DataBind();
ddlInvs.DataTextField = "InvName";
ddlInvs.DataValueField = "ID";
Session["ProInvs"] = null;
gvList.Columns[0].Visible = false;
gvList.Columns[1].Visible = false;
btnSave.Enabled = false;
btnCancel.Enabled = false;
plProInvs.Visible = false;
btnEdit.Visible = false;
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
txtDepartMent.Text = use.LoginIPosition;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
gvList.Columns[0].Visible = true;
gvList.Columns[1].Visible = true;
plProInvs.Visible = true;
lblReturnTime.Visible = false;
txtReturnTime.Visible = false;
imgReturnTime.Visible = false;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
//加载初始数据
List <Tb_ExpInvs> proInvsList = new List <Tb_ExpInvs>();
Session["ProInvs"] = proInvsList;
ViewState["ProInvsCount"] = proInvsList.Count;
gvList.DataSource = proInvsList;
gvList.DataBind();
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
ViewState["ProInvsIds"] = "";
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
Tb_ExpInvService paProInvSer = new Tb_ExpInvService();
Tb_ExpInvsService sonProInvSer = new Tb_ExpInvsService();
Tb_ExpInv pProModel = paProInvSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtName.Text = pProModel.LoginName;
txtCreateTime.Text = pProModel.ExpTime.ToString("yyyy-MM-dd");
txtDepartMent.Text = pProModel.DepartMent;
lblProNo.Text = pProModel.ProNo;
if (pProModel.IfOutGoods)
{
lblOutState.Text = "已发货";
}
else
{
lblOutState.Text = "尚未发货";
}
if (pProModel.OutTime != null)
{
lblOutTime.Text = pProModel.OutTime.ToString();
}
lblEventNo.Text = pProModel.EventNo;
List <Tb_ExpInvs> proInvsList = sonProInvSer.GetListArray(" 1=1 and PId=" + Request["allE_id"]);
Session["ProInvs"] = proInvsList;
ViewState["ProInvsCount"] = proInvsList.Count;
gvList.DataSource = proInvsList;
gvList.DataBind();
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (pProModel.IfOutGoods == false)
{
btnOk.Visible = true;
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (pProModel.IfOutGoods == false)
{
btnOk.Visible = true;
}
lblPer.Visible = false;
ddlPers.Visible = false;
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
//判断是不是自己填写的单子
//if (pProModel.CreateUserId.ToString() == base.Session["currentUserId"].ToString())
//{
// //gvList.Columns[0].Visible = true;
// //gvList.Columns[1].Visible = true;
// btnEdit.Visible = true;
// plProInvs.Visible = true;
// //setEnable(true);
//}
}
}
}
}
}
public bool updateTran(VAN_OA.Model.JXC.Sell_OrderFP model, VAN_OA.Model.EFrom.tb_EForm eform,
tb_EForms forms, List <Sell_OrderFPs> orders, string IDS, bool isBackUp, bool isBackUpInvoice)
{
//判断是否是删除 -销售发票删除
if (eform.proId == 37)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
if (eform.state == "不通过")
{
model.Status = "通过";
}
UpdateToDelete(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand, isBackUp);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
if (eform.state == "通过")
{
//删除发票签回单（如果有）
string deleteFPBack = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0}));", model.Id);
deleteFPBack += string.Format("delete tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0});", model.Id);
deleteFPBack += string.Format("delete Sell_OrderFPBacks where Id in (select id from Sell_OrderFPBack where PId={0});delete Sell_OrderFPBack where PId={0};", model.Id);
objCommand.CommandText = deleteFPBack;
objCommand.ExecuteNonQuery();
//删除发票删除单
string deleteFPDelete = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId in (26,34,37) and allE_id={0});", model.Id);
deleteFPDelete += string.Format("delete tb_EForm where proId in (26,34,37) and allE_id={0};", model.Id);
objCommand.CommandText = deleteFPDelete;
objCommand.ExecuteNonQuery();
//删除发票单
string DeleteAll = string.Format(@"declare @oldFPNo varchar(500);declare @oldPONo varchar(500);
select top 1 @oldFPNo=FPNo,@oldPONo=PONo from Sell_OrderFP where id={0}
update CG_POOrder set FPTotal=replace( FPTotal, @oldFPNo+'/','')
where PONo in (select PONo from Sell_OrderFP where id={0}) and ifzhui=0;", model.Id);
Dal.EFrom.tb_EFormService efromSer = new VAN_OA.Dal.EFrom.tb_EFormService();
//var efromModel = efromSer.GetModel(Convert.ToInt32(model.Id));
//if (efromModel.state == "通过")
//{
DeleteAll += "update CG_POOrder set POStatue3='' where PONo=@oldPONo;";
//}
DeleteAll += string.Format("delete from Sell_OrderFP where id={0};delete from Sell_OrderFPs where id={0}; ", model.Id);
objCommand.CommandText = DeleteAll;
objCommand.ExecuteNonQuery();
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
if (eform.state == "通过")
{
new Sell_OrderFPBackService().SellFPOrderBackUpdatePoStatus(model.PONo);
new VAN_OA.Dal.JXC.CG_POOrdersService().GetListArrayToFpsAndUpdatePoStatue(model.PONo, "通过");
}
}
else
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
string backUpPoNos = "";
if (isBackUp)
{
BackUpFPInfoService backUpSer = new BackUpFPInfoService();
backUpPoNos = backUpSer.BackUp(model.Id, objCommand);
}
//最后进行 删除 到款单 ，以及发票签回单& 备份
if (isBackUpInvoice && eform.state == "通过")
{
BackUpFPInfoService backUpSer = new BackUpFPInfoService();
backUpPoNos = backUpSer.BackUpOthers(model.Id, objCommand, model.InvoiceNowGuid);
}
//CG_POOrdersService OrdersSer = new CG_POOrdersService();
//CG_POCaiService CaiSer = new CG_POCaiService();
try
{
decimal total = 0;
foreach (var m in orders)
{
total += m.GoodSellPriceTotal;
}
model.Total = total;
System.Collections.Hashtable hs = new System.Collections.Hashtable();
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand, isBackUp);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
TB_HouseGoodsService houseGoodsSer = new TB_HouseGoodsService();
Sell_OrderFPsService OrdersSer = new Sell_OrderFPsService();
if (isBackUp)
{
//删除之前的数据
objCommand.CommandText = string.Format("delete from Sell_OrderFPs where id=" + model.Id);
objCommand.ExecuteNonQuery();
for (int i = 0; i < orders.Count; i++)
{
orders[i].id = model.Id;
OrdersSer.Add(orders[i], objCommand);
if (eform.state == "通过")
{
if (!hs.Contains(orders[i].SellOutOrderId))
{
hs.Add(orders[i].SellOutOrderId, null);
}
}
}
}
//foreach (var key in hs.Keys)
//{
// //更改销售订单的发票号
// string sql = string.Format("update Sell_OrderOutHouse set FPNo=FPNo+'{0}/' where ProNo='{1}'", model.FPNo, key);
// objCommand.CommandText = sql;
// objCommand.ExecuteNonQuery();
if (eform.state == "通过")
{
//更改项目订单的发票号
string sql = string.Format("update CG_POOrder set FPTotal=isnull(FPTotal,'')+'{0}/' where PONo='{1}' and ifzhui=0 ", model.FPNo, model.PONo);
objCommand.CommandText = sql;
objCommand.ExecuteNonQuery();
}
//}
//for (int i = 0; i < orders.Count; i++)
//{
// orders[i].Id = model.Id;
// //if (orders[i].IfUpdate == true && orders[i].Ids != 0)
// //{
// OrdersSer.Update(orders[i], objCommand);
// //}
// //else if (orders[i].Ids == 0)
// //{
// // OrdersSer.Add(orders[i], objCommand);
// //}
//}
//if (IDS != "")
//{
// IDS = IDS.Substring(0, IDS.Length - 1);
// OrdersSer.DeleteByIds(IDS, objCommand);
//}
tan.Commit();
if (backUpPoNos != "")
{
foreach (string pono in backUpPoNos.Split(','))
{
if (!string.IsNullOrEmpty(pono))
{
new Sell_OrderFPBackService().SellFPOrderBackUpdatePoStatus(pono);
new CG_POOrderService().GetOrder_ToInvoiceAndUpdatePoStatus(pono);
}
}
}
}
catch (Exception ex)
{
tan.Rollback();
return(false);
}
}
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
Province_CityService proList = new Province_CityService();
var comList = proList.ProvinceList();
ddlProvince.DataSource = comList;
ddlProvince.DataBind();
setBaiFenBi();
if (Request["type"] != null)
{
}
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
lblCreateUser.Text = use.LoginName;
lblCreateTime.Text = DateTime.Now.ToShortDateString().ToString();
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
var cityList = proList.CityList("");
cityList.Insert(0, "");
ddlCity.DataSource = cityList;
ddlCity.DataBind();
txtTime.Text = DateTime.Now.ToString();
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else if (Request["ReAudit"] != null)//再次编辑
{
txtSupplierName.Enabled = true;
txtZhuJi.Enabled = true;
txtSupplierSimpleName.Enabled = false;
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
ShowInfo(Convert.ToInt32(base.Request["allE_id"]));
#endregion
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
txtSupplierName.Enabled = true;
txtZhuJi.Enabled = true;
txtSupplierSimpleName.Enabled = false;
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
ShowInfo(Convert.ToInt32(base.Request["allE_id"]));
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
protected void gvMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "select")
{
string ProId = "0";
string allE_id = "0";
string[] payType_Id = e.CommandArgument.ToString().Split('_');
if (payType_Id[0] == "支")
{
var obj = DBHelp.ExeScalar(string.Format(@"select SUM(SupplierInvoiceTotal) from TB_SupplierInvoices where Id={0} or ids in (
select SupplierInvoiceIds from TB_TempSupplierInvoice where SupplierInvoiceId={0});", payType_Id[1]));
if (obj != null)
{
lblAllTotal.Text = obj.ToString();
}
gvDiXiao.DataSource = new SupplierToInvoiceViewService().GetSupplierInvoiceListToDiXiao(Convert.ToInt32(payType_Id[1]));
gvDiXiao.DataBind();
allE_id = payType_Id[1];
ProId = "in (31,33)";
}
else
{
if (payType_Id[0] == "预")
{
var obj = DBHelp.ExeScalar(string.Format(@"select SUM(SupplierInvoiceTotal) from TB_SupplierAdvancePayments
where Id={0};", payType_Id[1]));
if (obj != null)
{
lblAllTotal.Text = obj.ToString();
}
ProId = "=32";
allE_id = payType_Id[1];
}
else
{
lblAllTotal.Text = "0";
}
gvDiXiao.DataSource = new List <SupplierToInvoiceView>();
gvDiXiao.DataBind();
}
if (allE_id != "0")
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId {0} and allE_id={1})",
ProId, allE_id));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
}
}
if (e.CommandName == "Delete1")
{
// string[] payType_Id = e.CommandArgument.ToString().Split('_');
// string sql = "";
// string type = "";
// string deleteSql = "";
// if (payType_Id[0] == "支")
// {
// type = "供应商付款单";
// var checkSql = string.Format(@"select count(*) from TB_SupplierInvoice
//left join TB_SupplierInvoices on TB_SupplierInvoice.id=TB_SupplierInvoices.id
//where status='通过' and TB_SupplierInvoice.id={0} and SupplierInvoiceTotal<0", payType_Id[1]);
// if (Convert.ToInt32(DBHelp.ExeScalar(checkSql)) > 0)
// {
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数据由退货单生成，无法修改！');</script>");
// return;
// }
// deleteSql = string.Format("delete from TB_SupplierInvoice where id={0};delete from TB_SupplierInvoices where id={0};", payType_Id[1]);
// sql = "select CreateName,Status,ProNo,TB_SupplierInvoices.Id,IsYuFu from TB_SupplierInvoice left join TB_SupplierInvoices on TB_SupplierInvoices.id=TB_SupplierInvoice.id where TB_SupplierInvoice.id=" + payType_Id[1];
// }
// if (payType_Id[0] == "预")
// {
// type = "供应商预付款单";
// //首先查询这个单子有没有 生成相应的支付单
// var checksql = string.Format(@"select count(*) from CAI_OrderChecks left join CAI_OrderCheck on CAI_OrderChecks.CheckId=CAI_OrderCheck.Id
//where Status<>'不通过' and CaiId in (select caiIds from TB_SupplierAdvancePayment left join TB_SupplierAdvancePayments
//on TB_SupplierAdvancePayment.id=TB_SupplierAdvancePayments.Id
//where status='通过' and TB_SupplierAdvancePayment.id={0} )", payType_Id[1]);
// if (Convert.ToInt32(DBHelp.ExeScalar(checksql)) > 0)
// {
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数据已经存在入库数据，或正在入库的单子，无法修改！');</script>");
// return;
// }
// deleteSql = string.Format("delete from TB_SupplierAdvancePayment where id={0};delete from TB_SupplierAdvancePayments where id={0};", payType_Id[1]);
// sql = "select CreateName,Status,ProNo,Id from TB_SupplierAdvancePayment where id=" + payType_Id[1];
// }
// DataTable tb = DBHelp.getDataTable(sql);
// if (tb.Rows.Count <= 0)
// {
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('信息不存在！');</script>");
// return;
// }
// string efromId = string.Format("select id from tb_EForm where alle_id={0} and proId=(select pro_Id from A_ProInfo where pro_Type='" + type + "')", payType_Id[1]);
// string DeleteAll = string.Format("delete from tb_EForms where e_Id={0};delete from tb_EForm where id={0};", DBHelp.ExeScalar(efromId));
// deleteSql = deleteSql + DeleteAll;
// DBHelp.ExeCommand(deleteSql);
// Show();
// //base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('删除成功！');</script>");
// return;
}
if (e.CommandName == "ReEdit")
{
string[] payType_Id = e.CommandArgument.ToString().Split('_');
string sql = "";
string type = "";
if (payType_Id[0] == "支")
{
type = "供应商付款单";
//首先查询一下入库单有没有已经全部开票
// var checkSql = string.Format(@"select count(*) from TB_SupplierInvoice
//left join TB_SupplierInvoices on TB_SupplierInvoice.id=TB_SupplierInvoices.id
//left join CAI_OrderInHouses on CAI_OrderInHouses.ids=TB_SupplierInvoices.ruIds
//where status='通过' and PayStatus=2 and TB_SupplierInvoice.id={0}", payType_Id[1]);
var checkSql = string.Format(@"select count(*) from TB_SupplierInvoice
left join TB_SupplierInvoices on TB_SupplierInvoice.id=TB_SupplierInvoices.id
where status='通过' and TB_SupplierInvoice.id={0} and SupplierInvoiceTotal<0", payType_Id[1]);
if (Convert.ToInt32(DBHelp.ExeScalar(checkSql)) > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数据由退货单生成，无法修改！');</script>");
return;
}
sql = "select CreateName,Status,ProNo,TB_SupplierInvoices.Id,IsYuFu,LastSupplier from TB_SupplierInvoice left join TB_SupplierInvoices on TB_SupplierInvoices.id=TB_SupplierInvoice.id where TB_SupplierInvoice.id=" + payType_Id[1];
}
if (payType_Id[0] == "预")
{
type = "供应商预付款单";
//首先查询这个单子有没有 生成相应的支付单
// var checksql = string.Format(@"select count(*) from CAI_OrderChecks left join CAI_OrderCheck on CAI_OrderChecks.CheckId=CAI_OrderCheck.Id
//where Status<>'不通过' and CaiId in (select caiIds from TB_SupplierAdvancePayment left join TB_SupplierAdvancePayments
//on TB_SupplierAdvancePayment.id=TB_SupplierAdvancePayments.Id
//where status='通过' and TB_SupplierAdvancePayment.id={0} )", payType_Id[1]);
// if (Convert.ToInt32(DBHelp.ExeScalar(checksql)) > 0)
// {
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('数据已经存在入库数据，或正在入库的单子，无法修改！');</script>");
// return;
// }
sql = "select CreateName,Status,ProNo,Id from TB_SupplierAdvancePayment where id=" + payType_Id[1];
}
DataTable tb = DBHelp.getDataTable(sql);
if (tb.Rows.Count <= 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('信息不存在！');</script>");
return;
}
//是否是此单据的申请人
//if (payType_Id[0] != "预"&&Session["LoginName"].ToString() != tb.Rows[0]["CreateName"].ToString())
//{
// base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('必须由原单据申请人 重新发起，其他人不能重新提交编辑！');</script>");
// return;
//}
//首先单子要先通过
if (tb.Rows[0]["Status"] != null && tb.Rows[0]["Status"].ToString() == "执行中")
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('此单据在执行中不能重新编辑！');</script>");
return;
}
else
{
//base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('此单据必须已经审批通过才能重新编辑！');</script>");
//return;
}
if (payType_Id[0] == "支")
{
if (Convert.ToBoolean(tb.Rows[0]["IsYuFu"]))
{
type = "供应商付款单（预付单转支付单）";
}
if (tb.Rows[0]["LastSupplier"] != null)
{
//判断改供应商是否有在支付中的单子
if (TB_SupplierInvoiceService.checkSupplierDoing(tb.Rows[0]["LastSupplier"].ToString()))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('该供应商有在执行中的支付单，请排队等候');</script>");
return;
}
//判断改供应商是否有在支付中的单子
if (TB_SupplierInvoiceService.CheckAdvanceAndSupplierInvoices(tb.Rows[0]["LastSupplier"].ToString(), 1))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('该供应商有【预付款】在执行中的【抵扣支付单】，请排队等候');</script>");
return;
}
}
}
sql = "select pro_Id from A_ProInfo where pro_Type='" + type + "'";
string efromId = string.Format("select id from tb_EForm where alle_id={0} and proId=(select pro_Id from A_ProInfo where pro_Type='" + type + "')", payType_Id[1]);
string url = "";
if (payType_Id[0] == "支")
{
url = "~/JXC/WFSupplierInvoiceVerify.aspx?ProId=" + DBHelp.ExeScalar(sql) + "&allE_id=" + payType_Id[1] + "&EForm_Id=" + DBHelp.ExeScalar(efromId) + "&&ReAudit=true";
}
else
{
url = "~/JXC/WFSupplierAdvancePaymentVerify.aspx?ProId=" + DBHelp.ExeScalar(sql) + "&allE_id=" + payType_Id[1] + "&EForm_Id=" + DBHelp.ExeScalar(efromId) + "&&ReAudit=true";
}
Response.Redirect(url);
//没有做过检验单
}
}
public bool updateTran(VAN_OA.Model.JXC.CAI_OrderCheck model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <CAI_OrderChecks> orders, string IDS)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
CG_POOrdersService OrdersSer = new CG_POOrdersService();
CG_POCaiService CaiSer = new CG_POCaiService();
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
CAI_OrderChecksService myOrderChecks = new CAI_OrderChecksService();
for (int i = 0; i < orders.Count; i++)
{
// orders[i].CheckId = model.Id;
//if (orders[i].IfUpdate == true && orders[i].Ids != 0)
//{
myOrderChecks.Update(orders[i], objCommand);
//}
//else if (orders[i].Ids == 0)
//{
// OrdersSer.Add(orders[i], objCommand);
//}
}
//入库
if (eform.state == "通过")
{
tb_EForm eformMain = new tb_EForm();
int proId = 0;
string sql = "select Pro_Id from A_ProInfo where pro_Type='采购入库'";
objCommand.CommandText = sql;
proId = Convert.ToInt32(objCommand.ExecuteScalar());
eformMain.appPer = eform.appPer;
eformMain.appTime = DateTime.Now;
eformMain.createPer = eform.appPer;
eformMain.createTime = DateTime.Now;
eformMain.proId = proId;
eformMain.state = "通过";
eformMain.toPer = 0;
eformMain.toProsId = 0;
CAI_OrderInHouseService orderInHouse = new CAI_OrderInHouseService();
sql = "select top 1 id from TB_HouseInfo where ifdefault=1 ";
objCommand.CommandText = sql;
int objhouseId = Convert.ToInt32(objCommand.ExecuteScalar());
CAI_OrderInHouse orderInModel = new CAI_OrderInHouse()
{
ChcekProNo = model.ProNo,
CreateTime = DateTime.Now,
CreateUserId = eform.appPer,
GuestName = orders[0].GuestName,
HouseID = objhouseId,
POName = orders[0].POName,
PONo = orders[0].PONo,
RuTime = DateTime.Now,
Status = "通过",
Supplier = orders[0].SupplierName,
DoPer = orders[0].CaiGouPer,
DaiLi = orders[0].CaiGouPer,
FPNo = "",
Remark = ""
};
List <CAI_OrderInHouses> ordersInHouses = new List <CAI_OrderInHouses>();
foreach (var m in orders)
{
CAI_OrderInHouses orderM = new CAI_OrderInHouses()
{
GooId = m.CheckGoodId,
GoodNum = m.CheckNum,
GoodPrice = m.CheckPrice,
OrderCheckIds = m.Ids,
QingGouPer = m.QingGou,
CaiLastTruePrice = m.CheckLastTruePrice
};
ordersInHouses.Add(orderM);
}
orderInHouse.addTran(orderInModel, eformMain, ordersInHouses, objCommand);
}
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//加载基本信息
ddlNumber.Items.Add(new ListItem {
Text = "", Value = ""
});
ddlRow.Items.Add(new ListItem {
Text = "", Value = ""
});
ddlCol.Items.Add(new ListItem {
Text = "", Value = ""
});
//货架号：1.全部 缺省 2….51 1,..50
for (int i = 1; i < 51; i++)
{
ddlNumber.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
//层数：1.全部 缺省 2….21 1,2,3…20
//部位：1.全部 缺省 2….21 1,2,3…20
if (i <= 21)
{
ddlRow.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
ddlCol.Items.Add(new ListItem {
Text = i.ToString(), Value = i.ToString()
});
}
}
TB_GoodsTypeService typeSer = new TB_GoodsTypeService();
List <TB_GoodsType> allType = typeSer.GetListArray("");
allType.Insert(0, new TB_GoodsType());
ddlGoodType.DataSource = allType;
ddlGoodType.DataBind();
ddlGoodType.DataTextField = "GoodTypeName";
ddlGoodType.DataValueField = "GoodTypeName";
if (base.Request["ProId"] != null)
{
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(0, Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else if (Request["ReAudit"] != null)//再次编辑
{
txtGoodBrand.Enabled = false;
ddlGoodSmType.Enabled = false;
ddlGoodType.Enabled = false;
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
ShowInfo(Convert.ToInt32(base.Request["allE_id"]));
#endregion
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
ShowInfo(Convert.ToInt32(base.Request["allE_id"]));
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
DataTable carInfos = DBHelp.getDataTable("select ''as CarNO union select CarNO from TB_CarInfo");
ddlCarNo.DataSource = carInfos;
ddlCarNo.DataBind();
//请假单子
btnEdit.Visible = false;
btnSub.Visible = false;
btnEdit.Visible = true;
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
TB_UseCarDetailService carSer = new TB_UseCarDetailService();
TB_UseCarDetail carModel = carSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDateTime.Text = carModel.AppTime.ToLongDateString().ToString();
if (carModel.EndTime != null)
{
txtendTime.Text = carModel.EndTime.Value.ToString();
}
txtgoAddress.Text = carModel.GoAddress;
if (carModel.GoTime != null)
{
txtgoTime.Text = carModel.GoTime.Value.ToString();
}
txtName.Text = carModel.AppUser.ToString();
txtpers_car.Text = carModel.ByCarPers;
txtroadLong.Text = carModel.RoadLong.ToString();
txttoAddress.Text = carModel.ToAddress;
txtGuestName.Text = carModel.GuestName;
txtRemark.Text = carModel.Remark;
txtdeArea.Text = carModel.Area;
txtName.Text = carModel.AppUserName;
txtDriver.Text = carModel.Driver;
if (carModel.FromRoadLong != null)
{
txtFromRoadLong.Text = carModel.FromRoadLong.ToString();
}
if (carModel.ToRoadLong != null)
{
txtToRoadLong.Text = carModel.ToRoadLong.ToString();
}
try
{
ddlCarNo.Text = carModel.CarNo;
}
catch (Exception)
{
}
//if (carModel.Type == "单反")
//{
// rdoDan.Checked = true;
//}
//else
//{
// rdoWang.Checked = true;
//}
lblProNo.Text = carModel.ProNo;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToCurrnetEform(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
string perID = string.Format("select toPer from tb_EForm where id={0}", Request["EForm_Id"]);
ddlPers.Text = DBHelp.ExeScalar(perID).ToString();
}
catch (Exception)
{
}
}
setEnable(true);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
btnEdit.Visible = false;
btnFinSub.Visible = false;
txtOiLXiShu.ReadOnly = true;
txtOiLXiShu.Text = "0";
//获取油价信息
if (tb_UseCar.CarOliPrice == 0)
{
try
{
string url = System.Web.HttpContext.Current.Request.MapPath("CarOilPrice.txt");
System.IO.StreamReader my = new System.IO.StreamReader(url, System.Text.Encoding.Default);
string line;
line = my.ReadLine();
tb_UseCar.CarOliPrice = Convert.ToDecimal(line);
my.Close();
}
catch (Exception)
{
}
}
if (base.Request["ProId"] != null)
{
txtendTime.ReadOnly = true;
imgendTime.Enabled = false;
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtDateTime.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
txtroadLong.ReadOnly = true;
rdoDan.Checked = true;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getFristNodeUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
ddlPers.DataSource = roleUserList;
//}
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
tb_UseCarService carSer = new tb_UseCarService();
tb_UseCar carModel = carSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDateTime.Text = carModel.datetime.ToString("yyyy-MM-dd hh:mm:ss");
txtdeAddress.Text = carModel.deAddress;
if (carModel.endTime != null)
{
txtendTime.Text = carModel.endTime.Value.ToString();
}
txtgoAddress.Text = carModel.goAddress;
if (carModel.goTime != null)
{
txtgoTime.Text = carModel.goTime.Value.ToString();
}
txtName.Text = carModel.LoginName;
txtpers_car.Text = carModel.pers_car;
txtroadLong.Text = carModel.roadLong.ToString();
txttoAddress.Text = carModel.toAddress;
txtuseReason.Text = carModel.useReason;
if (carModel.type == "单反")
{
rdoDan.Checked = true;
}
else
{
rdoWang.Checked = true;
}
lblProNo.Text = carModel.ProNo;
txtPOGuestName.Text = carModel.POGuestName;
txtPOName.Text = carModel.POName;
txtPONo.Text = carModel.PONo;
txtOiLXiShu.Text = carModel.OilPrice.ToString();
#endregion
GetTotal();
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
User user = Session["userInfo"] as User;
if (user.Zhiwu == "总经理" || user.Zhiwu == "副总经理")
{
txtOiLXiShu.ReadOnly = false;
}
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
//setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{//从获取出的审核中 获取上级信息
// List<A_Role_User> newList = new List<A_Role_User>();
// for (int i = 0; i < roleUserList.Count; i++)
// {
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
// }
// if (newList.Count > 0)
// {
// ddlPers.DataSource = newList;
//}
//else
//{
ddlPers.DataSource = roleUserList;
// }
// ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
//txtOiLXiShu.ReadOnly = false;
lblPer.Visible = false;
ddlPers.Visible = false;
//setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
ddlPers.DataSource = roleUserList;
// }
//ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
//txtgoTime.Enabled = false;
//imggoTime.Enabled = false;
if (txtendTime.Text == "")
{
//判断该单据是否为自己申请
string sql = string.Format("select appPer from tb_EForm where proId={0} and allE_id={1}", Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]));
if (Session["currentUserId"].ToString() == DBHelp.ExeScalar(sql).ToString())
{
setEnable(false);
btnFinSub.Visible = true;
if (txtgoTime.Text == "")
{
txtgoTime.ReadOnly = false;
imggoTime.Enabled = true;
txtendTime.ReadOnly = true;
imgendTime.Enabled = false;
}
else if (txtendTime.Text == "")
{
txtgoTime.ReadOnly = true;
imggoTime.Enabled = false;
txtendTime.ReadOnly = false;
imgendTime.Enabled = true;
}
//txtendTime.Enabled = true;
//imgendTime.Enabled = true;
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
if (base.Request["ProId"] != null)
{
txtAppDate.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
txtDepartName.Text = use.LoginIPosition;
txtZhiWu.Text = use.Zhiwu;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
rdo1.Checked = true;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
Tb_LeaveTaskService timeSer = new Tb_LeaveTaskService();
Tb_LeaveTask timeModel = timeSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDepartName.Text = timeModel.Department;
txtForm.Text = timeModel.BeginTime.ToString();
txtName.Text = timeModel.UserName;
txtTo.Text = timeModel.ToTime.ToString();
txtRemark.Text = timeModel.Remark;
txtZhiWu.Text = timeModel.Job;
lblProNo.Text = timeModel.ProNo;
if (timeModel.LeverType == "开会请假")
{
rdo1.Checked = true;
}
else if (timeModel.LeverType == "培训请假")
{
rdo2.Checked = true;
}
else if (timeModel.LeverType == "公共卫生请假")
{
rdo3.Checked = true;
}
else if (timeModel.LeverType == "旅游请假")
{
rdo4.Checked = true;
}
else if (timeModel.LeverType == "其它")
{
rdo5.Checked = true;
}
showTimeSpan();
if (timeModel.AppDate != null)
{
txtAppDate.Text = timeModel.AppDate.Value.ToString("yyyy-MM-dd hh:mm:ss");
}
;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{//从获取出的审核中 获取上级信息
// List<A_Role_User> newList = new List<A_Role_User>();
// for (int i = 0; i < roleUserList.Count; i++)
// {
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
// }
// if (newList.Count > 0)
// {
// ddlPers.DataSource = newList;
// }
// else
// {
ddlPers.DataSource = roleUserList;
// }
// ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
////从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;}
// else
//{
ddlPers.DataSource = roleUserList;
//}
//ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
public bool updateTran(VAN_OA.Model.JXC.CAI_POOrder model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <CAI_POOrders> orders, string IDS,
List <CAI_POCai> Cais, string CAI_IDS)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
CAI_POOrdersService OrdersSer = new CAI_POOrdersService();
CAI_POCaiService CaiSer = new CAI_POCaiService();
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
//for (int i = 0; i < orders.Count; i++)
//{
// orders[i].Id = model.Id;
// //if (orders[i].IfUpdate == true && orders[i].Ids != 0)
// //{
// OrdersSer.Update(orders[i], objCommand);
// //}
// //else if (orders[i].Ids == 0)
// //{
// // OrdersSer.Add(orders[i], objCommand);
// //}
//}
//if (IDS != "")
//{
// IDS = IDS.Substring(0, IDS.Length - 1);
// OrdersSer.DeleteByIds(IDS, objCommand);
//}
#region 采购
for (int i = 0; i < Cais.Count; i++)
{
Cais[i].Id = model.Id;
if (Cais[i].IfUpdate == true && Cais[i].Ids != 0)
{
CaiSer.Update(Cais[i], objCommand);
}
else if (Cais[i].Ids == 0)
{
CaiSer.Add(Cais[i], objCommand);
}
}
//if (CAI_IDS != "")
//{
// CAI_IDS = CAI_IDS.Substring(0, CAI_IDS.Length - 1);
// CaiSer.DeleteByIds(CAI_IDS, objCommand);
//}
#endregion
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
DataTable carInfos = DBHelp.getDataTable("select ''as CarNO union select CarNO from TB_CarInfo where IsStop=0 ");
ddlCarNo.DataSource = carInfos;
ddlCarNo.DataBind();
ddlCarNo.Text = "";
if (base.Request["ProId"] != null)
{
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtAppDate.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
lblName.Text = use.LoginName;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载数据
TB_CarMaintenance CarMaiModel = this.carMaintenanceSer.GetModel(Convert.ToInt32(base.Request["allE_id"]));
ddlCarNo.Text = CarMaiModel.CardNo;
if (CarMaiModel.Distance != null)
{
txtDistance.Text = CarMaiModel.Distance.ToString();
}
txtMaintenanceTime.Text = CarMaiModel.MaintenanceTime.ToString();
txtRemark.Text = CarMaiModel.Remark;
if (CarMaiModel.ReplaceRemark != null)
{
txtReplaceRemark.Text = CarMaiModel.ReplaceRemark;
}
if (CarMaiModel.ReplaceStatus != null)
{
txtReplaceStatus.Text = CarMaiModel.ReplaceStatus;
}
lblName.Text = CarMaiModel.UserName;
lblProNo.Text = CarMaiModel.UseState;
txtAppDate.Text = CarMaiModel.CreateTime.ToString("yyyy-MM-dd hh:mm:ss");
if (CarMaiModel.Total != null)
{
txtTotal.Text = CarMaiModel.Total.ToString();
}
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
//保养
if (Request["Type"] != null && Request["Type"] == "Edit")
{
btnUpdate.Visible = true;
txtMaintenanceTime.ReadOnly = false;
txtDistance.ReadOnly = false;
txtTotal.ReadOnly = false;
txtReplaceRemark.ReadOnly = false;
txtReplaceStatus.ReadOnly = false;
txtRemark.ReadOnly = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
btnBaoXiao.Visible = false;
lbtnAddFiles.Visible = false;
plEmail.Enabled = false;
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtDateTime.Text = DateTime.Now.ToString();
lbtnAddFiles.Visible = true;
//隐藏邮寄信息
plEmail.Visible = false;
txtPostCode.Enabled = false;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
#region MyRegion
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
tb_PostService postSer = new tb_PostService();
tb_Post postModel = postSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDateTime.Text = postModel.AppTime.ToShortDateString();
txtName.Text = postModel.LoginName;
txtPostCode.Text = postModel.PostCode;
txtremark.Text = postModel.Remark;
txtTel.Text = postModel.Tel;
txtToPer.Text = postModel.ToPer;
txtWuliuName.Text = postModel.WuliuName;
txtPostAddress.Text = postModel.PostAddress;
lblProNo.Text = postModel.ProNo;
txtFromPer.Text = postModel.FromPer;
if (postModel.PostContext != null)
{
txtPostContext.Text = postModel.PostContext;
}
if (postModel.PostFrom != null)
{
cbPostFrom.Checked = Convert.ToBoolean(postModel.PostFrom);
}
if (postModel.PostFromAddress != null)
{
txtPostFromAddress.Text = postModel.PostFromAddress;
}
if (cbPostTo.Checked != null)
{
cbPostTo.Checked = Convert.ToBoolean(postModel.PostTo);
}
if (txtPostToAddress.Text != null)
{
txtPostToAddress.Text = postModel.PostToAddress;
}
if (postModel.PostTotal != null)
{
txtPostTotal.Text = postModel.PostTotal.ToString();
}
if (postModel.PostRemark != null)
{
txtPostRemark.Text = postModel.PostRemark;
}
txtPONo.Text = postModel.PONo;
txtPOName.Text = postModel.POName;
txtPOGuestName.Text = postModel.POGuestName;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
string sql = "SELECT count(1) from Tb_DispatchList where Post_Id=" + Request["allE_id"] + " and State<>'不通过'";
if ((int)DBHelp.ExeScalar(sql) == 0)
{
btnBaoXiao.Visible = true;
}
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
plEmail.Enabled = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
// ddlPers.DataSource = roleUserList;
//}
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
plEmail.Enabled = true;
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
// ddlPers.DataSource = roleUserList;
//}
//ddlPers.DataSource = roleUserList;
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
#endregion
//判断该单据是否为自己申请
//string sql = string.Format("select appPer from tb_EForm where proId={0} and allE_id={1}", Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]));
//if (Session["currentUserId"].ToString() == DBHelp.ExeScalar(sql).ToString())
//{
// setEnable(false);
//}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
lbtnSelectPONo.Visible = false;
//请假单子
VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName("");
ddlUser.DataSource = user;
ddlUser.DataBind();
ddlUser.DataTextField = "LoginName";
ddlUser.DataValueField = "LoginName";
if (base.Request["ProId"] != null)
{
txtAppDate.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
txtDepartName.Text = use.LoginIPosition;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
lbtnSelectPONo.Visible = true;
txtTotal.ReadOnly = true;
lblGuestName.Visible = false;
ddlUser.Visible = false;
lblPer.Text = "客户代表:";
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(0, Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
tb_OverTimeSerivce timeSer = new tb_OverTimeSerivce();
tb_OverTime timeModel = timeSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDepartName.Text = timeModel.DepartName;
txtForm.Text = timeModel.formTime.ToString();
txtName.Text = timeModel.LoginName;
ddlUser.Text = timeModel.guestDai;
txtTo.Text = timeModel.toTime.ToString();
txtreason.Text = timeModel.reason;
//txtSuiXingRen.Text = timeModel.SuixingRen;
txtAddress.Text = timeModel.Address;
//txtTime.Text = timeModel.Time.Value.ToShortDateString();
lblProNo.Text = timeModel.ProNo;
if (timeModel.Total != null)
{
txtTotal.Text = timeModel.Total.ToString();
}
if (timeModel.OverTimeType != null)
{
ddlOverTimeType.Text = timeModel.OverTimeType;
}
txtPOGuestName.Text = timeModel.POGuestName;
txtPOName.Text = timeModel.POName;
txtPONo.Text = timeModel.PONo;
showTimeSpan();
if (timeModel.Time.HasValue)
{
txtAppDate.Text = timeModel.Time.Value.ToString("yyyy-MM-dd hh:mm:ss");
}
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
List <A_Role_User> newList = new List <A_Role_User>();
for (int i = 0; i < roleUserList.Count; i++)
{
if (roleUserList[i].UserId == use.ReportTo)
{
A_Role_User a = roleUserList[i];
newList.Add(a);
break;
}
}
if (newList.Count > 0)
{
ddlPers.DataSource = newList;
}
else
{
ddlPers.DataSource = roleUserList;
}
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
tb_ComplaintSerive comSer = new tb_ComplaintSerive();
tb_Complaint commodel = comSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDateTime.Text = commodel.datetime.ToString();
txtName.Text = commodel.AppUserName;
txtRemark.Text = commodel.ContentRemark;
txtToPer.Text = commodel.ToPerName;
lblProNo.Text = commodel.ProNo;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{//从获取出的审核中 获取上级信息
List <A_Role_User> newList = new List <A_Role_User>();
for (int i = 0; i < roleUserList.Count; i++)
{
if (roleUserList[i].UserId == use.ReportTo)
{
A_Role_User a = roleUserList[i];
newList.Add(a);
break;
}
}
if (newList.Count > 0)
{
ddlPers.DataSource = newList;
}
else
{
ddlPers.DataSource = roleUserList;
}
// ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
List <A_Role_User> newList = new List <A_Role_User>();
for (int i = 0; i < roleUserList.Count; i++)
{
if (roleUserList[i].UserId == use.ReportTo)
{
A_Role_User a = roleUserList[i];
newList.Add(a);
break;
}
}
if (newList.Count > 0)
{
ddlPers.DataSource = newList;
}
else
{
ddlPers.DataSource = roleUserList;
}
//ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
//ImageButton1.Enabled = false;
//Image1.Enabled = false;
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
btnFinSub.Visible = false;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtBackTime.Enabled = false;
ImageButton1.Enabled = false;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getFristNodeUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
else
{
txtBackTime.Enabled = true;
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
txtBackTime.Enabled = true;
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
#region MyRegion
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 数据
TB_BorrowInvNameService BorrowSer = new TB_BorrowInvNameService();
TB_BorrowInvName BorrowModel = BorrowSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtName.Text = BorrowModel.LoginName;
if (BorrowModel.BackTime != null)
{
txtBackTime.Text = BorrowModel.BackTime.Value.ToString();
}
if (BorrowModel.BorrowTime != null)
{
txtBorrowTime.Text = BorrowModel.BorrowTime.Value.ToString();
}
txtInvName.Text = BorrowModel.InvName;
txtReason.Text = BorrowModel.Reason;
lblProNo.Text = BorrowModel.ProNo;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
// ddlPers.DataSource = roleUserList;
//}
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
//从获取出的审核中 获取上级信息
//List<A_Role_User> newList = new List<A_Role_User>();
//for (int i = 0; i < roleUserList.Count; i++)
//{
// if (roleUserList[i].UserId == use.ReportTo)
// {
// A_Role_User a = roleUserList[i];
// newList.Add(a);
// break;
// }
//}
//if (newList.Count > 0)
//{
// ddlPers.DataSource = newList;
//}
//else
//{
// ddlPers.DataSource = roleUserList;
//}
//ddlPers.DataSource = roleUserList;
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
#endregion
//txtBorrowTime.Enabled = false;
////判断该单据是否为自己申请
//string sql = string.Format("select appPer from tb_EForm where proId={0} and allE_id={1}", Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]));
//if (Session["currentUserId"].ToString() == DBHelp.ExeScalar(sql).ToString())
//{
// setEnable(false);
// txtBackTime.Enabled = true;
// //btnFinSub.Visible = true;
//}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
Session["Orders"] = null;
lbtnAddFiles.Visible = false;
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtRuTime.Text = DateTime.Now.ToString();
//权限1（销售）
lbtnAddFiles.Visible = true;
//加载初始数据
List <Sell_OrderOutHouseBacks> orders = new List <Sell_OrderOutHouseBacks>();
Session["Orders"] = orders;
ViewState["OrdersCount"] = orders.Count;
gvList.DataSource = orders;
gvList.DataBind();
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int pro_IDs = 0;
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getFristNodeUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else if (Request["ReAudit"] != null)//重新提交编辑
{
ViewState["POOrdersIds"] = "";
//权限1（销售）
lbtnAddFiles.Visible = true;
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
ViewState["EformsCount"] = eforms.Count;
#region 加载 请假单数据
Sell_OrderOutHouseBackService mainSer = new Sell_OrderOutHouseBackService();
Sell_OrderOutHouseBack pp = mainSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtName.Text = pp.CreateName;
txtSellProNo.Text = pp.SellProNo;
if (pp.BackType == 0)
{
rdoA.Checked = true;
}
else
{
rdoB.Checked = true;
}
txtRemark.Text = pp.Remark;
txtRuTime.Text = pp.BackTime.ToString();
txtSupplier.Text = pp.GuestName;
txtPOName.Text = pp.POName;
txtPONo.Text = pp.PONo;
if (pp.ProNo != null)
{
lblProNo.Text = pp.ProNo;
}
Sell_OrderOutHouseBacksService ordersSer = new Sell_OrderOutHouseBacksService();
List <Sell_OrderOutHouseBacks> orders = ordersSer.GetListArray(" 1=1 and Sell_OrderOutHouseBacks.id=" + Request["allE_id"]);
Session["Orders"] = orders;
ViewState["OrdersCount"] = orders.Count;
gvList.DataSource = orders;
gvList.DataBind();
#endregion
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int pro_IDs = 0;
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getFristNodeUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
ViewState["POOrdersIds"] = "";
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
ViewState["EformsCount"] = eforms.Count;
#region 加载 请假单数据
Sell_OrderOutHouseBackService mainSer = new Sell_OrderOutHouseBackService();
Sell_OrderOutHouseBack pp = mainSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtName.Text = pp.CreateName;
txtSellProNo.Text = pp.SellProNo;
if (pp.BackType == 0)
{
rdoA.Checked = true;
}
else
{
rdoB.Checked = true;
}
txtRemark.Text = pp.Remark;
txtRuTime.Text = pp.BackTime.ToString();
txtSupplier.Text = pp.GuestName;
txtPOName.Text = pp.POName;
txtPONo.Text = pp.PONo;
if (pp.ProNo != null)
{
lblProNo.Text = pp.ProNo;
}
Sell_OrderOutHouseBacksService ordersSer = new Sell_OrderOutHouseBacksService();
List <Sell_OrderOutHouseBacks> orders = ordersSer.GetListArray(" 1=1 and Sell_OrderOutHouseBacks.id=" + Request["allE_id"]);
Session["Orders"] = orders;
ViewState["OrdersCount"] = orders.Count;
gvList.DataSource = orders;
gvList.DataBind();
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
SetRole(eforms.Count);
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
}
setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
SetRole(eforms.Count);
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
//请假单子
if (base.Request["ProId"] != null)
{
//加载基本数据
VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User;
txtName.Text = use.LoginName;
txtZhiwu.Text = use.Zhiwu;
txtDepartName.Text = use.LoginIPosition;
ddlSecondPers.Visible = false;
lblDepartment.Visible = false;
tb_EFormService eformSer = new tb_EFormService();
if (Request["allE_id"] == null)//单据增加
{
txtAppDate.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
rdoShiJia.Checked = true;
//检查自己是否在请假单中流程设置中，来确定自己下一个审批人
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"])))
{
//获取审批人
int pro_IDs = 0;
int ids = 0;
//List<A_Role_User> roleUserList = eformSer.getFristNodeUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids, out pro_IDs);
List <A_Role_User> roleUserList = eformSer.getFristNodeUsers_New(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), use.LoginIPosition, out ids);
ViewState["ids"] = ids;
pro_IDs = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
if (pro_IDs != 0)
{
ddlSecondPers.Visible = true;
lblDepartment.Visible = true;
//获取第二级别审核人
List <A_Role_User> roleUserListSecond = eformSer.getSecondRoleUsers(Convert.ToInt32(Request["ProId"]), pro_IDs);
//从获取出的审核中 获取上级信息
ddlSecondPers.DataSource = roleUserListSecond;
ddlSecondPers.DataBind();
ddlSecondPers.DataTextField = "UserName";
ddlSecondPers.DataValueField = "UserId";
try
{
ddlSecondPers.Text = use.ReportTo.ToString();
ddlSecondPers.Enabled = false;
}
catch (Exception)
{
}
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
}
else//单据审批
{
//加载已经审批的数据
tb_EFormsService eformsSer = new tb_EFormsService();
List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})",
Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
if (eforms.Count > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
for (int i = 0; i < eforms.Count; i++)
{
string per = "";
if (eforms[i].consignor != null && eforms[i].consignor != 0)
{
per = eforms[i].Consignor_Name + "(委托人：" + eforms[i].Audper_Name + ")";
}
else
{
per = eforms[i].Audper_Name;
}
mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}：{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见：{5}</td></tr>",
i + 1, eforms[i].RoleName
, per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea);
}
mess += "</table>";
lblMess.Text = mess;
}
#region 加载 请假单数据
tb_LeverInfoService leverSer = new tb_LeverInfoService();
tb_LeverInfo levermodel = leverSer.GetModel(Convert.ToInt32(Request["allE_id"]));
txtDepartName.Text = levermodel.depart;
txtForm.Text = levermodel.dateForm.ToString();
txtName.Text = levermodel.name;
txtRemark.Text = levermodel.remark;
txtZhiwu.Text = levermodel.zhiwu;
txtTo.Text = levermodel.dateTo.ToString();
if (levermodel.leverType == "病假")
{
rdoBing.Checked = true;
}
if (levermodel.leverType == "调休")
{
rdoDiaoXiu.Checked = true;
}
if (levermodel.leverType == "年休假")
{
rdoNianjia.Checked = true;
}
if (levermodel.leverType == "事假")
{
rdoShiJia.Checked = true;
}
if (levermodel.leverType == "产假")
{
rdoChanJia.Checked = true;
}
if (levermodel.leverType == "丧假")
{
rdoCangjia.Checked = true;
}
if (levermodel.leverType == "婚假")
{
rdoHunJia.Checked = true;
}
lblProNo.Text = levermodel.ProNo;
lblZhuGuanId.Text = levermodel.ZhuGuan.ToString();
showTimeSpan();
if (levermodel.AppDate != null)
{
txtAppDate.Text = levermodel.AppDate.Value.ToString("yyyy-MM-dd hh:mm:ss");
}
;
#endregion
//判断单据是否已经结束
if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
//判断请假单是否是自动过期
if (eforms.Count <= 0)
{
string sql = string.Format("select count(*) from tb_EForm where state='不通过' and allE_id=" + Request["allE_id"] + " and proId=" + Request["ProId"]);
if (Convert.ToInt32(DBHelp.ExeScalar(sql)) > 0)
{
string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>";
string per = "系统自动审批";
mess += string.Format("<tr><td align='center'>第1步</td><td>序号1：系统自动审批</td><td><span style='color:red;'>系统自动检测,你的请假时间在{0}前没有得到审批,系统自动将本单据作废！</span></td></tr>",
txtForm.Text);
mess += "</table>";
lblMess.Text = mess;
}
}
setEnable(false);
}
else
{
//是否为审核人
if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
string sql = string.Format(" select a_Index from A_ProInfos where pro_Id={0} and ids={1}", Convert.ToInt32(Request["ProId"]), ids);
try
{
// 说明 是代理人审核
if (Convert.ToInt32(DBHelp.ExeScalar(sql)) == 1 && lblZhuGuanId.Text != "" && Convert.ToInt32(lblZhuGuanId.Text) != 0)
{
//从获取出的审核中 获取主管信息
List <A_Role_User> newList = new List <A_Role_User>();
for (int i = 0; i < roleUserList.Count; i++)
{
if (roleUserList[i].UserId == Convert.ToInt32(lblZhuGuanId.Text))
{
A_Role_User a = roleUserList[i];
newList.Add(a);
break;
}
}
//重新绑定部门信息
ddlPers.DataSource = newList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
}
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
//是否为代理人
if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
ViewState["ifConsignor"] = true;
if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])))
{
lblPer.Visible = false;
ddlPers.Visible = false;
}
else
{
int ids = 0;
List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids);
ViewState["ids"] = ids;
if (roleUserList != null)
{
ddlPers.DataSource = roleUserList;
ddlPers.DataBind();
ddlPers.DataTextField = "UserName";
ddlPers.DataValueField = "UserId";
try
{
ddlPers.Text = use.ReportTo.ToString();
}
catch (Exception)
{
}
}
} setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])));
}
else
{
btnSub.Visible = false;
lblPer.Visible = false;
ddlPers.Visible = false;
lblResult.Visible = false;
lblYiJian.Visible = false;
ddlResult.Visible = false;
txtResultRemark.Visible = false;
setEnable(false);
}
}
}
}
}
}
}
