protected void Page_Load(object sender, EventArgs e)
{
if (!(null == Session["totleAuthority"]))
{
AuthAttributes usrAuthAttr = (AuthAttributes)Session["totleAuthority"];
bool flag = usrAuthAttr.HasOneFlag(AuthAttributes.pay_receiptExamine);
if (!flag)
{
Response.Redirect("~/Main/NoAuthority.aspx");
}
}
else
{
string url = Request.FilePath;
Session["backUrl"] = url;
Response.Redirect("~/Account/Login.aspx");
}
if (!IsPostBack)
{
DataRow sessionDr = Session["seldSelfReceipt"] as DataRow;
string strMainContractId = sessionDr["mainContractId"].ToString();
#region dr
DataSet MyDst = new DataSet();
MainContractProcess mainContractView = new MainContractProcess(MyDst);
mainContractView.RealmainContractProjectView();
DataTable taskTable = mainContractView.MyDst.Tables["view_mainContract_project_usr"].DefaultView.ToTable();
string strFilter =
" mainContractId = " + "'" + strMainContractId + "'";
taskTable.DefaultView.RowFilter = strFilter;
DataRow dr = taskTable.DefaultView.ToTable().Rows[0];
#endregion
#region context_input
lblProjectTag.Text = dr["projectTag"].ToString();
lblMainContractTag.Text = dr["mainContractTag"].ToString();
lblCust.Text = dr["custCompName"].ToString();
lblMainContractMoney.Text = dr["cash"].ToString();
lblMainContractDateLine.Text = dr["dateLine"].ToString();
lblMainContractPayment.Text = dr["paymentMode"].ToString();
lblCustReceiptMax.Text = float.Parse(sessionDr["custMaxReceipt"].ToString()).ToString("p");
lblSelfToReceipt.Text = float.Parse(sessionDr["toReceiptCash"].ToString()).ToString("c");
lblSelfHasReceipt.Text = float.Parse(sessionDr["hasReceiptPercent"].ToString()).ToString("p");
lblSelfTotleReceipt.Text = float.Parse(sessionDr["receiptPercent"].ToString()).ToString("p");
txtReceiptExplication.Text = sessionDr["receiptExplication"].ToString();
string strDone = sessionDr["Done"].ToString();
lblDone.Text = strDone;
txtReceiptComment.Text = sessionDr["receiptComment"].ToString();
DateTime doneTime = (DateTime)dr["doneTime"];
if (doneTime > DateTime.Now)
{
btnOK.Visible = true;
btnNo.Visible = true;
}
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(null == Session["totleAuthority"]))
{
AuthAttributes usrAuthAttr = (AuthAttributes)Session["totleAuthority"];
bool flag = usrAuthAttr.HasOneFlag(AuthAttributes.newContract);
if (!flag)
{
Response.Redirect("~/Main/NoAuthority.aspx");
}
}
else
{
string url = Request.FilePath;
Session["backUrl"] = url;
Response.Redirect("~/Account/Login.aspx");
}
if (!IsPostBack)
{
string usrId = Session["usrId"] as string;
DataSet MyDst = new DataSet();
#region productList
MainContractProductProcess mcppView = new MainContractProductProcess(MyDst);
mcppView.RealMainContractProductView();
DataTable mcppTable = mcppView.MyDst.Tables["view_mainContractProduct"];
DataColumn colproductAndNum = new DataColumn("productAndNum", System.Type.GetType("System.String"));
mcppTable.Columns.Add(colproductAndNum);
string strSplit = " , ".ToString();
foreach (DataRow dr in mcppTable.Rows)
{
dr["productAndNum"] = dr["productName"].ToString() + strSplit + dr["productNum"].ToString();
}
Session["mainContractProductDtSources"] = mcppTable;
#endregion
#region mainContractGV
MainContractProcess mainContractView = new MainContractProcess(MyDst);
mainContractView.UsrId = usrId;
mainContractView.RealmainContractProjectUsrView();
DataTable taskTable = mainContractView.MyDst.Tables["view_mainContract_project_usr"];
Session["ProjectTagProcess"] = mainContractView;
Session["dtSources"] = taskTable;
mainContractGV.DataSource = Session["dtSources"];
mainContractGV.DataBind();
#endregion
//Xm_db xmDataCont = Xm_db.GetInstance();
//int uId = int.Parse(usrId);
//var a =
// from mainContract_project_usr in xmDataCont.View_mainContract_project_usr
// where mainContract_project_usr.EndTime > DateTime.Now &&
// mainContract_project_usr.UsrId == uId
// orderby mainContract_project_usr.HasSupplier descending, mainContract_project_usr.ReceiptEd descending
// select new { mainContract_project_usr, ok = mainContract_project_usr. };
//System.Type t = a.GetType();
//DataTable dba = a.AsEnumerable().Distinct<t.>(new MainIdComparer<t>("BusinessProductId")).ToDataTable();
}
}
protected void btnOk_Click(object sender, EventArgs e)
{
if (inputCheck())
{
//string projectTagId = ddlProjectTag.SelectedValue;
//string custmor = txtCustmor.Text.ToString().Trim();
//string mainContractTag = txtMainContractTag.Text.ToString().Trim();
//string cash = txtMoney.Text.ToString().Trim();
//string dateLine = btnDate.Text.ToString();
//string payment = txtPayment.Text.ToString().Trim();
//DataTable dt = Session["mainProductSelDs"] as DataTable;
//foreach (GridViewRow gvr in mainProductGV.Rows)
//{
// int index = gvr.DataItemIndex;
// TextBox txb = gvr.FindControl("txtProductNum") as TextBox;
// if (txb != null)
// {
// dt.DefaultView[index]["productNum"] = txb.Text;
// }
//}
//DataTable contractProductTable = dt.DefaultView.ToTable("tbl_mainContrctProduct");
//DataColumn colMainContractId = new DataColumn("mainContractId", System.Type.GetType("System.Int32"));
//contractProductTable.Columns.Add(colMainContractId);
//#region dataset
//DataSet dataSet = new DataSet();
//DataRow mainContractRow = null;
//DataColumn colProjectTagId = new DataColumn("projectTagId", System.Type.GetType("System.String"));
//DataColumn colContractCompName = new DataColumn("contractCompName", System.Type.GetType("System.String"));
//DataColumn colMainContractTag = new DataColumn("mainContractTag", System.Type.GetType("System.String"));
//DataColumn colCash = new DataColumn("cash", System.Type.GetType("System.String"));
//DataColumn colDateLine = new DataColumn("dateLine", System.Type.GetType("System.String"));
//DataColumn colPaymentMode = new DataColumn("paymentMode", System.Type.GetType("System.String"));
//DataTable mainContractTable = new DataTable("tbl_mainContract");
//mainContractTable.Columns.Add(colProjectTagId);
//mainContractTable.Columns.Add(colContractCompName);
//mainContractTable.Columns.Add(colMainContractTag);
//mainContractTable.Columns.Add(colCash);
//mainContractTable.Columns.Add(colDateLine);
//mainContractTable.Columns.Add(colPaymentMode);
//mainContractRow = mainContractTable.NewRow();
//mainContractRow["projectTagId"] = projectTagId;
//mainContractRow["contractCompName"] = custmor;
//mainContractRow["mainContractTag"] = mainContractTag;
//mainContractRow["cash"] = cash;
//mainContractRow["dateLine"] = dateLine;
//mainContractRow["paymentMode"] = payment;
//mainContractTable.Rows.Add(mainContractRow);
//dataSet.Tables.Add(mainContractTable);
//dataSet.Tables.Add(contractProductTable);
//#endregion
DataTable mainContractTable = getInput();
string projectOutAddress = txtProjAddr.Text.ToString();
DataTable dt = Session["mainProductSelDs"] as DataTable;
foreach (GridViewRow gvr in mainProductGV.Rows)
{
int index = gvr.DataItemIndex;
TextBox txb = gvr.FindControl("txtProductNum") as TextBox;
if (txb != null)
{
dt.DefaultView[index]["productNum"] = txb.Text;
}
}
DataTable contractProductTable = dt.DefaultView.ToTable("tbl_mainContrctProduct");
DataColumn colMainContractId = new DataColumn("mainContractId", System.Type.GetType("System.Int32"));
contractProductTable.Columns.Add(colMainContractId);
#region dataset
DataSet dataSet = new DataSet();
dataSet.Tables.Add(mainContractTable);
dataSet.Tables.Add(contractProductTable);
#endregion
MainContractProcess mcp = new MainContractProcess(dataSet);
mcp.Add();
string strMainContractId = mcp.StrRtn;
foreach (DataRow dr in contractProductTable.Rows)
{
dr["mainContractId"] = strMainContractId;
}
MainContractProductProcess mcpp = new MainContractProductProcess(dataSet);
mcpp.Add();
Xm_db xmDataCont = Xm_db.GetInstance();
int mainContractId = int.Parse(strMainContractId);
var mainContractEdit =
(from mainContract in xmDataCont.Tbl_mainContract
where mainContract.MainContractId == mainContractId
select mainContract).First();
int projectTagId = mainContractEdit.ProjectTagId;
//int projectTagId = int.Parse(mainContractTable.Rows[0]["projectTagId"].ToString());
var projectEdit =
(from project in xmDataCont.Tbl_projectTagInfo
where project.ProjectTagId == projectTagId
select project).First();
projectEdit.ProjectOutAddress = projectOutAddress;
try
{
//xmDataCont.Refresh(System.Data.Linq.RefreshMode.KeepChanges, xmDataCont.tbl_mainContract);
//xmDataCont.Refresh(System.Data.Linq.RefreshMode.KeepChanges, xmDataCont.tbl_projectTagInfo);
xmDataCont.SubmitChanges(System.Data.Linq.ConflictMode.ContinueOnConflict);
}
catch (System.Data.Linq.ChangeConflictException cce)
{
string strEx = cce.Message;
foreach (System.Data.Linq.ObjectChangeConflict occ in xmDataCont.ChangeConflicts)
{
//No database values are merged into current.
occ.Resolve(System.Data.Linq.RefreshMode.KeepChanges);
}
xmDataCont.SubmitChanges();
}
Session.Remove("ddlProjectDtS");
Session.Remove("mainContractTable");
Session.Remove("mainProductSelDs");
Response.Redirect("~/Main/contractManager/subContractEdit.aspx");
}
}
