protected void gvList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#EAF1FD',this.style.fontWeight='';");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
CAI_OrderChecks model = e.Row.DataItem as CAI_OrderChecks;
SumOrders.CheckNum += model.CheckNum;
SumOrders.Total += model.Total;
}
ImageButton btnEdit = e.Row.FindControl("btnEdit") as ImageButton;
if (btnEdit != null)
{
string val = string.Format("javascript:window.showModalDialog('CG_Orders.aspx?index={0}',null,'dialogWidth:500px;dialogHeight:450px;help:no;status:no')", e.Row.DataItemIndex);
btnEdit.Attributes.Add("onclick", val);
}
// 合计
if (e.Row.RowType == DataControlRowType.Footer)
{
setValue(e.Row.FindControl("lblPONo") as Label, "合计"); //合计
setValue(e.Row.FindControl("lblNum") as Label, SumOrders.CheckNum.ToString()); //数量
setValue(e.Row.FindControl("lblTotal") as Label, SumOrders.Total.ToString()); //成本总额
}
}
public int AddCAI_OrderCheck(int id)
{
CAI_OrderCheck order = new CAI_OrderCheck();
order.CreatePer = 1;
order.CheckPer = 1;
order.CheckTime = DateTime.Now;
order.CheckRemark = "库存初始化";
VAN_OA.Model.EFrom.tb_EForm eform = new tb_EForm();
int userId = 1;
eform.appPer = userId;
eform.appTime = DateTime.Now;
eform.createPer = 1;
eform.createTime = DateTime.Now;
eform.proId = 21;
eform.state = "不通过";
eform.toPer = 0;
eform.toProsId = 0;
CAI_POCaiService POSer = new CAI_POCaiService();
List <CAI_POCaiView> modelList = POSer.GetListViewCai_POOrders_Cai_POOrderChecks_View(" id=" + id);
List <CAI_OrderChecks> POOrders = new List <CAI_OrderChecks>();
foreach (var model in modelList)
{
CAI_OrderChecks checkModel = new CAI_OrderChecks();
checkModel.Total = model.Total;
checkModel.CaiId = model.POCaiId;
checkModel.CheckGoodId = model.GoodId;
checkModel.CheckNum = model.Num;
checkModel.CheckPrice = model.Price;
checkModel.Good_Model = model.Good_Model;
checkModel.GoodName = model.GoodName;
checkModel.GoodNo = model.GoodNo;
checkModel.GoodSpec = model.GoodSpec;
checkModel.GoodTypeSmName = model.GoodTypeSmName;
checkModel.GoodUnit = model.GoodUnit;
checkModel.GuestName = model.GuestName;
checkModel.POName = model.POName;
checkModel.PONo = model.PONo;
checkModel.SupplierName = model.Supplier;
checkModel.CaiProNo = model.ProNo;
checkModel.QingGou = model.CaiGou;
checkModel.CaiGouPer = model.loginName;
checkModel.CheckLastTruePrice = model.LastTruePrice;
checkModel.GoodAreaNumber = model.GoodAreaNumber;
POOrders.Add(checkModel);
}
CAI_OrderCheckService POOrderSer = new CAI_OrderCheckService();
int MainId = 0;
return(POOrderSer.addTran(order, eform, POOrders, out MainId));
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
if (Session["CAI_OrderInHousesNo_PoNo"] != null)
{
CAI_OrderChecks model = Session["CAI_OrderInHousesNo_PoNo"] as CAI_OrderChecks;
txtChcekProNo.Text = model.CaiProNo;
txtPONo.Text = model.PONo;
txtPOName.Text = model.POName;
txtSupplier.Text = model.SupplierName;
lblGuestName.Text = model.GuestName;
txtCaiGou.Text = model.CaiGouPer;
ShowData();
}
}
protected void gvList_RowEditing(object sender, GridViewEditEventArgs e)
{
CAI_OrderChecks model = new CAI_OrderChecks();
Label lblCaiProNo = gvList.Rows[e.NewEditIndex].FindControl("CaiProNo") as Label;
if (lblCaiProNo != null)
{
model.CaiProNo = lblCaiProNo.Text;
}
Label lblPONo = gvList.Rows[e.NewEditIndex].FindControl("PONo") as Label;
if (lblPONo != null)
{
model.PONo = lblPONo.Text;
}
Label lblPOName = gvList.Rows[e.NewEditIndex].FindControl("POName") as Label;
if (lblPOName != null)
{
model.POName = lblPOName.Text;
}
Label lblGuestName = gvList.Rows[e.NewEditIndex].FindControl("GuestName") as Label;
if (lblGuestName != null)
{
model.GuestName = lblGuestName.Text;
}
Label lblSupplierName = gvList.Rows[e.NewEditIndex].FindControl("SupplierName") as Label;
if (lblSupplierName != null)
{
model.SupplierName = lblSupplierName.Text;
}
Label CaiGouPer = gvList.Rows[e.NewEditIndex].FindControl("CaiGouPer") as Label;
if (CaiGouPer != null)
{
model.CaiGouPer = CaiGouPer.Text;
}
Session["CAI_OrderInHousesNo_PoNo"] = model;
Response.Write("<script>window.close();window.opener=null;</script>");
}
protected void gvList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#EAF1FD',this.style.fontWeight='';");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
CAI_OrderChecks model = e.Row.DataItem as CAI_OrderChecks;
SumOrders.CheckNum += model.CheckNum;
SumOrders.Total += model.Total;
}
// 合计
if (e.Row.RowType == DataControlRowType.Footer)
{
setValue(e.Row.FindControl("lblPONo") as Label, "合计"); //合计
//setValue(e.Row.FindControl("lblNum") as Label, SumOrders.CheckNum.ToString());//数量
setValue(e.Row.FindControl("lblTotal") as Label, SumOrders.Total.ToString()); //成本总额
}
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
if (Session["Orders"] != null)
{
if (Session["CGPOList"] != null)
{
List <Model.JXC.CAI_POCaiView> modelList = Session["CGPOList"] as List <Model.JXC.CAI_POCaiView>;
List <CAI_OrderChecks> POOrders = Session["Orders"] as List <CAI_OrderChecks>;
foreach (var model in modelList)
{
CAI_OrderChecks checkModel = new CAI_OrderChecks();
checkModel.Total = model.Total;
checkModel.CaiId = model.POCaiId;
checkModel.CheckGoodId = model.GoodId;
checkModel.CheckNum = model.Num;
checkModel.CheckPrice = model.Price;
checkModel.Good_Model = model.Good_Model;
checkModel.GoodName = model.GoodName;
checkModel.GoodNo = model.GoodNo;
checkModel.GoodSpec = model.GoodSpec;
checkModel.GoodTypeSmName = model.GoodTypeSmName;
checkModel.GoodUnit = model.GoodUnit;
checkModel.GuestName = model.GuestName;
checkModel.POName = model.POName;
checkModel.PONo = model.PONo;
checkModel.SupplierName = model.Supplier;
checkModel.CaiProNo = model.ProNo;
checkModel.QingGou = model.CaiGou;
checkModel.CaiGouPer = model.loginName;
checkModel.CheckLastTruePrice = model.LastTruePrice;
checkModel.GoodAreaNumber = model.GoodAreaNumber;
POOrders.Add(checkModel);
}
Session["CGPOList"] = null;
gvList.DataSource = POOrders;
gvList.DataBind();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
// TB_SupplierInvoicesService ordersSer = new TB_SupplierInvoicesService();
// List<SupplierToInvoiceView> orders = ordersSer.GetListArray(" SupplierInvoiceTotal<0 and TB_SupplierInvoices.id in (select Id from TB_SupplierInvoice where Status='通过')");
// new TB_SupplierInvoiceService().SetRuKuPayStatus1(orders);
////更新供应商名称
string sql = @"select CAI_OrderChecks.* from CAI_OrderChecks
where Ids in (
select CAI_OrderChecks.ids
from CAI_POCai
left join CAI_OrderChecks on CAI_OrderChecks.CaiId=CAI_POCai.Ids
left join CAI_OrderInHouses on CAI_OrderInHouses.OrderCheckIds=CAI_OrderChecks.Ids
left join
(
select CaiIds,Sum(SupplierInvoiceTotal) as SupplierInvoiceTotal,min(SupplierInvoiceDate) as minSupplierInvoiceDate from
TB_SupplierAdvancePayments
left join TB_SupplierAdvancePayment on TB_SupplierAdvancePayment.id=TB_SupplierAdvancePayments.id
where status='通过'
group by CaiIds
)
as tb1 on CAI_POCai.IDs=tb1.CaiIds
where SupplierInvoiceTotal is not null --and CAI_OrderInHouses.ids is not null
AND CAI_OrderInHouses.ids NOT IN (select RuIds FROM TB_SupplierInvoices WHERE IsYuFu=1)
)
order by checkId";
var dt = DBHelp.getDataTable(sql);
Dictionary <string, string> dic = new Dictionary <string, string>();
List <CAI_OrderChecks> POOrders = new List <CAI_OrderChecks>();
foreach (System.Data.DataRow dr in dt.Rows)
{
if (!dic.ContainsKey(dr["CheckId"].ToString()))
{
dic.Add(dr["CheckId"].ToString(), dr["SupplierName"].ToString());
}
CAI_OrderChecks model = new CAI_OrderChecks();
model.Ids = Convert.ToInt32(dr["Ids"]);
model.CaiId = Convert.ToInt32(dr["CaiId"]);
model.CheckId = Convert.ToInt32(dr["CheckId"]);
POOrders.Add(model);
}
foreach (string key in dic.Keys)
{
string checkIds = "";
string caiIds = "";
int id = Convert.ToInt32(key);
foreach (var model in POOrders.FindAll(t => t.CheckId == id))
{
checkIds += model.Ids + ",";
caiIds += model.CaiId + ",";
}
if (checkIds.Length > 0)
{
checkIds = checkIds.Substring(0, checkIds.Length - 1);
caiIds = caiIds.Substring(0, caiIds.Length - 1);
}
new TB_SupplierInvoiceService().AddSupplierInvoice(checkIds, caiIds, Session["LoginName"].ToString(), Convert.ToInt32(Session["currentUserId"].ToString()), key);
}
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交成功！');</script>");
}
