protected void Page_Load(object sender, EventArgs e) { if (IsCN == false) { FinanceReportViewer.LocalReport.ReportPath = FinanceReportViewer.LocalReport.ReportPath.Replace("En", "").Replace(".rdlc", "En.rdlc"); } facservComm = new ServiceCommon(base.factoryConnectionString); if (!IsPostBack) { if (ccWhere.sbComponent.ToString() == "") { ccWhere.AddComponent("1", "1", SearchComponent.Equals, SearchPad.NULL); } DataTable dtSeller = facservComm.ExecuteSqlDatatable("select distinct sellerid,Seller from " + vieworganizationorigin + " where " + ccWhere.sbComponent); this.seller.DataTextField = "Seller"; this.seller.DataValueField = "sellerid"; this.seller.DataSource = dtSeller; this.seller.DataBind(); if (GetOrganization.Count > 0) { this.seller.SelectedValue = GetOrganization["sellerid"].ToString(); this.seller.Enabled = false; } DataTable dtPrice = new ReportDataSet.ProductPriceDataTable(); this.FinanceReportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dtPrice)); //BindProductPrice(); } if (!String.IsNullOrEmpty(Request["refresh"])) { BindProductPrice(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.btnSave.Text = GetGlobalResourceObject("Resource", "Upload").ToString(); } if (!string.IsNullOrEmpty(Request["hDelete"])) { ccWhere.AddComponent("ID", Request["hDelete"], SearchComponent.Equals, SearchPad.NULL); DataTable dt = servComm.GetListTop(0, "W_OrderAttachements", ccWhere); foreach (DataRow dr in dt.Rows) { if (dr["FilePath"] != null && !String.IsNullOrEmpty(dr["FilePath"].ToString())) { string strFileName = dr["FilePath"].ToString().Substring(dr["FilePath"].ToString().LastIndexOf("/") + 1); strFileName = Request.PhysicalApplicationPath + SaveFilePath + strFileName; if (File.Exists(strFileName)) { File.Delete(strFileName); } } } servComm.ExecuteSql(" delete from W_OrderAttachements where ID='" + Request["hDelete"] + "'"); BindList(); } BindList(); }
protected void Page_Load(object sender, EventArgs e) { string BillNo = Request["BillNo"]; if (!String.IsNullOrEmpty(BillNo)) { ccwhere.AddComponent("BillNo", "%" + BillNo + "%", SearchComponent.Like, SearchPad.And); } string Salesperson = Request["Salesperson"]; if (!String.IsNullOrEmpty(Salesperson)) { ccwhere.AddComponent("Salesperson", "%" + Salesperson + "%", SearchComponent.Like, SearchPad.And); } string IsDel = Request["IsDel"]; if (!String.IsNullOrEmpty(IsDel)) { ccwhere.AddComponent("IsDel", "1", SearchComponent.Equals, SearchPad.And); } else { ccwhere.AddComponent("Isnull(IsDel,0)", "1", SearchComponent.UnEquals, SearchPad.And); } servComm.strOrderString = "Id"; DataTable dtSales = servComm.GetListTop(0, "[Id],[SaleDate],[seller],[Salesperson],[BillDate],[BillNo],[BillClass],[Reg],[RegTime]", "Sale", ccwhere); string fileName = Request.PhysicalApplicationPath + "UploadFile\\" + DateTime.Now.ToString("yyyyMMddHHmmsshhh") + ".xlsx"; using (NPOIHelper excelHelper = new NPOIHelper(fileName, Request.PhysicalApplicationPath + "UploadFile\\")) { //int count = excelHelper.DataTableToExcel(dtSales, "订单信息", true); } }
private void BindDailyReport(bool initFlg = false) { this.FinanceReportViewer.LocalReport.DataSources.Clear(); if (initFlg) { this.FinanceReportViewer.Visible = false; } else { this.FinanceReportViewer.Visible = true; ccWhere.AddComponent("indate", Request["txtdatefrom"], SearchComponent.GreaterOrEquals, SearchPad.And); ccWhere.AddComponent("indate", Request["txtdateto"], SearchComponent.LessOrEquals, SearchPad.And); GetFilterByKind(ref ccWhere, "Report"); if (ccWhere.sbComponent.ToString() == "") { ccWhere.AddComponent("1", "1", SearchComponent.Equals, SearchPad.NULL); } DataTable dtModelProcessing = facservComm.ExecuteSqlDatatable(ModelProcessingSummary + " and " + ccWhere.sbComponent); this.FinanceReportViewer.LocalReport.SetParameters(new ReportParameter("paraIndate", "2015年01月01日")); this.FinanceReportViewer.LocalReport.SetParameters(new ReportParameter("paraOutDate", DateTime.Now.Year.ToString() + "年" + DateTime.Now.Month.ToString() + "月" + DateTime.Now.Day + "日")); this.FinanceReportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dtModelProcessing)); } }
protected void Page_Load(object sender, EventArgs e) { modelBase = servComm.GetEntity <ModelBase>("1"); string actiontype = Request["actiontype"]; if (actiontype == "ValidCardNo") { string CardNo = Request["CardNo"]; string PatientName = Request["PatientName"]; ccwhere.Clear(); ccwhere.AddComponent("CardNo", CardNo, SearchComponent.Equals, SearchPad.NULL); ccwhere.AddComponent("patient", PatientName, SearchComponent.Equals, SearchPad.And); DataTable dtOrders = servComm.GetListTop(0, "(select a.*,b.Client from orders a left join Client b on a.Serial = b.Serial) c", ccwhere); var timeConvert = new IsoDateTimeConverter(); //timeConvert.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; timeConvert.DateTimeFormat = "yyyy-MM-dd"; string responseJson = JsonConvert.SerializeObject(dtOrders, Formatting.Indented, timeConvert); ccwhere.Clear(); ccwhere.AddComponent("CardNo", CardNo, SearchComponent.Equals, SearchPad.NULL); DataTable dtOrdersDetail = servComm.GetListTop(0, "ordersdetail", ccwhere); string detailJson = JsonConvert.SerializeObject(dtOrdersDetail, Formatting.Indented, timeConvert); if (dtOrders.Rows.Count > 0) { servComm.ExecuteSql("insert into Visitor values ( getdate())"); } Response.Write("[{\"RowCount\":" + dtOrders.Rows.Count + ",\"JsonData\":" + responseJson + ",\"JsonDetail\":" + detailJson + "}]"); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { if (IsCN == false) { FinanceReportViewer.LocalReport.ReportPath = FinanceReportViewer.LocalReport.ReportPath.Replace("En", "").Replace(".rdlc", "En.rdlc"); } if (!IsPostBack) { string Order_ID = Request["Order_ID"]; string serial = Request["serial"]; facservComm = new ServiceCommon(base.factoryConnectionString); ccWhere.Clear(); ccWhere.AddComponent("EquipRec.Order_ID", Order_ID, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("EquipRec.serial", serial, SearchComponent.Equals, SearchPad.And); //DataTable dtEquipRec = facservComm.GetListTop(0, "* ", "VWEquipRec", ccWhere); DataTable dtEquipRec = facservComm.ExecuteSqlDatatable(VWEquipRec + " where " + ccWhere.sbComponent); //this.FinanceReportViewer.LocalReport.SetParameters(new ReportParameter("paraIndate", "2015年01月01日")); //this.FinanceReportViewer.LocalReport.SetParameters(new ReportParameter("paraOutDate", DateTime.Now.Year.ToString() + "年" + DateTime.Now.Month.ToString() + "月" + DateTime.Now.Day + "日")); this.FinanceReportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dtEquipRec)); } }
protected void Page_Load(object sender, EventArgs e) { Log.LogInfo("OrderList"); facservComm = new ServiceCommon(base.factoryConnectionString); ccWhere.Clear(); if (LoginUser.Kind == "B") { ccWhere.AddComponent("sellerid", LoginUser.AssocNo.ToString(), SearchComponent.Equals, SearchPad.NULL); } else if (LoginUser.Kind == "C") { ccWhere.AddComponent("hospitalid", LoginUser.AssocNo.ToString(), SearchComponent.Equals, SearchPad.NULL); } else if (LoginUser.Kind == "D") { ccWhere.AddComponent("doctorid", LoginUser.AssocNo.ToString(), SearchComponent.Equals, SearchPad.NULL); } if (ccWhere.sbComponent.ToString() == "") { ccWhere.AddComponent("1", "1", SearchComponent.Equals, SearchPad.NULL); } facservComm.strOrderString = IsCN ? " NameCN " : " NameEN "; // DataTable dtSeller = facservComm.GetListTop(0, " distinct sellerid as id,Seller as NameCN,Seller as NameEN ", "vieworganization", ccWhere); DataTable dtSeller = facservComm.ExecuteSqlDatatable("select distinct sellerid as id,Seller as NameCN,Seller as NameEN from " + vieworganizationorigin + " where " + ccWhere.sbComponent); facservComm.strOrderString = IsCN ? " NameCN " : " NameEN "; //DataTable dtHospital = facservComm.GetListTop(0, " distinct hospitalid as id,hospital as NameCN,hospital as NameEN,sellerid ", "vieworganization", ccWhere); DataTable dtHospital = facservComm.ExecuteSqlDatatable("select distinct hospitalid as id,hospital as NameCN,hospital as NameEN,sellerid from " + vieworganizationorigin + " where " + ccWhere.sbComponent); facservComm.strOrderString = IsCN ? " NameCN " : " NameEN "; //DataTable dtDoctor = facservComm.GetListTop(0, " distinct doctorid as id,doctor as NameCN,doctor as NameEN,Hospitalid", "vieworganization", ccWhere); DataTable dtDoctor = facservComm.ExecuteSqlDatatable("select distinct doctorid as id,doctor as NameCN,doctor as NameEN,Hospitalid from " + vieworganizationorigin + " where " + ccWhere.sbComponent); for (int i = 0; i < dtSeller.Rows.Count; i++) { string sellid = dtSeller.Rows[i]["id"].ToString(); zNodes = zNodes + ",{" + "\"id\":" + sellid + ",\"pId\":0" + ",\"name\":" + "\"" + (IsCN ? dtSeller.Rows[i]["NameCN"] : dtSeller.Rows[i]["NameEN"]) + "\",\"open\": true,\"icon\":" + "\"../zTree_v3/css/zTreeStyle/img/diy/seller.png\"" + "}"; DataRow[] drHospital = dtHospital.Select("sellerid='" + sellid + "'"); foreach (DataRow itemHosptal in drHospital) { string hospitalID = itemHosptal["id"].ToString(); zNodes = zNodes + ",{" + "\"id\":" + hospitalID + ",\"pId\":" + sellid + ",\"name\":" + "\"" + (IsCN?itemHosptal["NameCN"]:itemHosptal["NameEN"]) + "\",\"icon\":" + "\"../zTree_v3/css/zTreeStyle/img/diy/hospital.png\"" + "}"; DataRow[] drDoctor = dtDoctor.Select("Hospitalid='" + hospitalID + "'"); foreach (DataRow itemDoctor in drDoctor) { zNodes = zNodes + ",{" + "\"id\":" + itemDoctor["id"].ToString() + ",\"pId\":" + hospitalID + ",\"name\":" + "\"" + (IsCN?itemDoctor["NameCN"]: itemDoctor["NameEN"]) + "\",\"icon\":" + "\"../zTree_v3/css/zTreeStyle/img/diy/doctor.png\"" + "}"; } } } zNodes = zNodes.Length > 0 ? zNodes.Substring(1) : zNodes; zNodes = "[" + zNodes + "]"; // zNodes = "[{ \"id\":1, \"pId\":0, \"name\": \"父节点1 - 展开\", \"open\": true }" + //",{ \"id\":11, \"pId\":1, \"name\": \"父节点11 - 折叠\" }]"; }
/// <summary> /// /// </summary> /// <param name="strUserName"></param> /// <param name="strPassword"></param> /// <param name="bolAutoSave"></param> /// <returns>0:成功 1:失败</returns> public static int doLoginEx(string strUserName, string strPassword, bool bolAutoSave) { ServiceCommon servComm = new ServiceCommon(); ConditionComponent condComponent = new ConditionComponent(); if (strUserName.IndexOf("@") > 0) { condComponent.AddComponent("UPPER(email)", strUserName.ToUpper(), SearchComponent.Equals, SearchPad.NULL); } else { condComponent.AddComponent("UPPER(username)", strUserName.ToUpper(), SearchComponent.Equals, SearchPad.NULL); } condComponent.AddComponent("password", strPassword, SearchComponent.Equals, SearchPad.And); loan_user objUser = servComm.GetEntity <loan_user>(null, condComponent); //查询用户大于0 if (objUser.uid > 0) { HttpCookie cookie = new HttpCookie("d2012"); //写入Cookie cookie.Values["EMAIL"] = objUser.email.ToString(); cookie.Values["PASSWORD"] = objUser.password.ToString(); LOGINUSERINFO loginUser = new LOGINUSERINFO(); loginUser._USERINFO = objUser; HttpContext.Current.Session[UserConstant.SESSION_USERINFO] = loginUser; HttpContext.Current.Session["email"] = objUser.email; HttpContext.Current.Session["userid"] = objUser.uid; HttpContext.Current.Session["emailvalid"] = objUser.emailvalid; HttpContext.Current.Session["username"] = objUser.username; HttpContext.Current.Session["password"] = objUser.password; HttpContext.Current.Session["ulevel"] = objUser.ulevel; //更新最后登录时间 最后登录IP 总登录次数 loan_user luser = servComm.GetEntity <loan_user>(objUser.uid); luser.lastloginIP = HttpContext.Current.Request.UserHostAddress; luser.lastlogintime = DateTime.Now; luser.logintimes = luser.logintimes + 1; servComm.Update(luser); } else { return(1); } return(0); }
protected void Page_Init(object sender, EventArgs e) { if (Session["factoryConnectionString"] == null) { Response.Redirect(Request.Url.GetLeftPart(UriPartial.Authority) + "//Weixinclient//WXLogin.aspx"); } facComm = new ServiceCommon(Session["factoryConnectionString"].ToString()); ccWhere.Clear(); ccWhere.AddComponent("ClassID", "OrderClass", SearchComponent.Equals, SearchPad.NULL); dtCategory = facComm.GetListTop(0, " Code,DictName ", "DictDetail", ccWhere); }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request["hDelete"])) { servComm.ExecuteSql(" delete from JX_USERS where ID='" + Request["hDelete"] + "'"); } ccWhere.Clear(); if (!String.IsNullOrEmpty(Request["txtJGCName"])) { ccWhere.AddComponent("JGCName", Request["txtJGCName"], SearchComponent.Like, SearchPad.NULL); } hddpnumbers = Request["hpnumbers"]; int iCount = 10; if (!string.IsNullOrEmpty(hddpnumbers)) { iCount = Convert.ToInt32(hddpnumbers); } int iPageIndex = string.IsNullOrEmpty(Request["sPageID"]) ? 1 : Convert.ToInt32(Request["sPageID"]); int iPageCount = string.IsNullOrEmpty(Request["sPageNum"]) ? 0 : Convert.ToInt32(Request["sPageNum"]); servComm.strOrderString = " LastModifyTime desc "; IList <JX_USERS> ilist = servComm.GetList <JX_USERS>(JX_USERS.STRTABLENAME, "*", JX_USERS.STRKEYNAME, iCount, iPageIndex, iPageCount, ccWhere); repUserList.DataSource = ilist; repUserList.DataBind(); pagecut1.iPageNum = servComm.PageCount; }
protected void loginBtn_Click(object sender, EventArgs e) { string username = Request["username"]; string password = Request["password"]; ccWhere.Clear(); //condComponent.AddComponent("UPPER(Alias)", strUserName.ToUpper(), SearchComponent.Equals, SearchPad.Ex); ccWhere.AddComponent("UPPER(UserName)", username.ToUpper(), SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("Passwd", CryptoHelper.StaticEncrypt(password), SearchComponent.Equals, SearchPad.And); ModelClient objUser = servComm.GetEntity <ModelClient>(null, ccWhere); if (objUser != null && objUser.ID > 0) { Session["UserName"] = username; Session["objUser"] = objUser; Session["UserName"] = objUser.Client; //servComm.ExecuteSql("insert into Visitor values ( getdate())"); if (objUser.Class == "S") { Session["AccessMenu"] = "S"; } else { DataTable dtRole = servComm.ExecuteSqlDatatable("select Role" + objUser.Class + " from base"); if (dtRole.Rows.Count > 0) { Session["AccessMenu"] = dtRole.Rows[0][0].ToString(); } if (Session["AccessMenu"] == null) { Session["AccessMenu"] = ""; } } Response.Redirect("index.aspx"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "sucess", "layer.msg('用户名或密码错误');", true); } }
private void ConstructionCondition() { string CardNoStart = Request["CardNoStart"]; if (!String.IsNullOrEmpty(CardNoStart)) { ccwhere.AddComponent("CardNoStart", CardNoStart, SearchComponent.GreaterOrEquals, SearchPad.And); } string CardNoEnd = Request["CardNoEnd"]; if (!String.IsNullOrEmpty(CardNoEnd)) { ccwhere.AddComponent("CardNoEnd", CardNoEnd, SearchComponent.LessOrEquals, SearchPad.And); } string Salesperson = Request["Salesperson"]; if (!String.IsNullOrEmpty(Salesperson)) { ccwhere.AddComponent("Salesperson", "%" + Salesperson + "%", SearchComponent.Like, SearchPad.And); } }
private void BindSeller() { if (ccWhere.sbComponent.ToString() == "") { ccWhere.AddComponent("1", "1", SearchComponent.Equals, SearchPad.NULL); } DataTable dtSeller = facservComm.ExecuteSqlDatatable("select distinct sellerid,Seller from " + vieworganizationorigin + " where " + ccWhere.sbComponent); this.seller.DataTextField = "Seller"; this.seller.DataValueField = "sellerid"; this.seller.DataSource = dtSeller; this.seller.DataBind(); if (IsCN) { this.seller.Items.Insert(0, new ListItem("请选择", "")); } else { this.seller.Items.Insert(0, new ListItem("Select", "")); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { ((HtmlContainerControl)Master.FindControl("HTitle")).InnerText = "产品详细"; } servCommfac = new ServiceCommon(base.factoryConnectionString); orderID = Request["orderID"]; serialID = Request["serial"]; productid = Request["productid"]; ccWhere.Clear(); ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("serial", serialID, SearchComponent.Equals, SearchPad.And); IList <ORDERS> listOrder = servCommfac.GetListTop <ORDERS>(0, "*", "Orders", ccWhere); if (listOrder.Count > 0) { preOutDate = listOrder[0].preoutDate.ToShortDateString(); } //ccWhere.AddComponent("productid", productid, SearchComponent.Equals, SearchPad.And); ccWhere.AddComponent("ProductID", productid, SearchComponent.Equals, SearchPad.And); DataTable dtProduct = servCommfac.ExecuteSqlDatatable("SELECT itemname FROM products b where id = '" + productid + "'"); IList <ORDERSDETAIL> listProducts = servCommfac.GetListTop <ORDERSDETAIL>(0, "*", "OrdersDetail", ccWhere); if (listProducts.Count > 0) { productsModel.ItemName = dtProduct.Rows.Count > 0?dtProduct.Rows[0]["itemname"].ToString():""; productsModel.Number = listProducts[0].Qty.ToString(); productsModel.righttop = listProducts[0].a_teeth.ToString().Trim(); productsModel.lefttop = listProducts[0].b_teeth.ToString().Trim(); productsModel.rightbottom = listProducts[0].c_teeth.ToString().Trim(); productsModel.leftbottom = listProducts[0].d_teeth.ToString().Trim(); // listProducts[0].pr } GetProcedureList(orderID, serialID, productid); } catch (Exception ex) { } }
private void BindFinanceView() { this.FinanceReportViewer.LocalReport.DataSources.Clear(); string Order_ID = Request["Order_ID"]; string serial = Request["serial"]; facservComm = new ServiceCommon(base.factoryConnectionString); ccWhere.Clear(); ccWhere.AddComponent("Order_ID", Order_ID, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("serial", serial, SearchComponent.Equals, SearchPad.And); facservComm.strOrderString = "cast(qsserial as int)"; ccWhere.AddComponent("class", this.ItemClass.SelectedValue, SearchComponent.Equals, SearchPad.And); //DataTable dtProductCheckReport = facservComm.GetListTop(0, "* ", "VWProductCheckReport", ccWhere); DataTable dtProductCheckReport = facservComm.ExecuteSqlDatatable(VWProductCheckReport + " where " + ccWhere.sbComponent); //this.FinanceReportViewer.LocalReport.SetParameters(new ReportParameter("paraIndate", "2015年01月01日")); //this.FinanceReportViewer.LocalReport.SetParameters(new ReportParameter("paraOutDate", DateTime.Now.Year.ToString() + "年" + DateTime.Now.Month.ToString() + "月" + DateTime.Now.Day + "日")); this.FinanceReportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dtProductCheckReport)); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { ((HtmlContainerControl)Master.FindControl("HTitle")).InnerText = "订单详细"; } servCommfac = new ServiceCommon(base.factoryConnectionString); orderID = Request["orderID"]; serialID = Request["serial"]; ccWhere.Clear(); ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("serial", serialID, SearchComponent.Equals, SearchPad.And); IList <ORDERS> listOrder = servCommfac.GetListTop <ORDERS>(0, "seller,hospital,doctor,Patient,Order_ID,indate,preoutDate,OutDate,Sex,Age,Fenge,Require,Courier,CourierNo,OutSay,ModelNo", "orders", ccWhere); if (listOrder.Count > 0) { orderModel = listOrder[0]; } DataTable dtProduct = servCommfac.ExecuteSqlDatatable("SELECT Order_ID,serial,ProductId,itemname FROM OrdersDetail a left join products b on a.productid = b.id where Order_ID = '" + orderID + "' and serial = '" + serialID + "'"); for (int i = 0; i < dtProduct.Rows.Count; i++) { ProductId = dtProduct.Rows[i]["ProductId"].ToString(); itemname = dtProduct.Rows[i]["itemname"].ToString(); itemnamelist.Add(itemname); ProductIdlist.Add(ProductId); for (int j = 0; j < itemnamelist.Count(); j++) { itemname = dtProduct.Rows[i]["itemname"].ToString(); ProductId = dtProduct.Rows[i]["ProductId"].ToString(); } } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { servComm = new ServiceCommon(base.factoryConnectionString); if (!IsPostBack) { } ccWhere.Clear(); hddpnumbers = Request["hpnumbers"]; int iCount = 10; //if (!string.IsNullOrEmpty(hddpnumbers)) //{ // iCount = Convert.ToInt32(hddpnumbers); //} int iPageIndex = string.IsNullOrEmpty(Request["sPageID"]) ? 1 : Convert.ToInt32(Request["sPageID"]); int iPageCount = string.IsNullOrEmpty(Request["sPageNum"]) ? 0 : Convert.ToInt32(Request["sPageNum"]); string txttxtPatient = Request["txtPatient"]; if (!string.IsNullOrEmpty(txttxtPatient)) { ccWhere.AddComponent("patient ", txttxtPatient, SearchComponent.Like, SearchPad.And); } string selectedID = Request["selectedID"]; string selectedLevel = Request["selectedLevel"]; if (!String.IsNullOrEmpty(selectedLevel) && !String.IsNullOrEmpty(selectedID)) { if (selectedLevel == "0") { ccWhere.AddComponent("sellerid ", selectedID, SearchComponent.Equals, SearchPad.And); } else if (selectedLevel == "1") { ccWhere.AddComponent("HospitalID ", selectedID, SearchComponent.Equals, SearchPad.And); } else if (selectedLevel == "2") { ccWhere.AddComponent("DoctorID ", selectedID, SearchComponent.Equals, SearchPad.And); } } GetFilterByKind(ref ccWhere, "orders"); servComm.strOrderString = " regtime desc "; IList <ORDERSDETAIL> ilist = servComm.GetList <ORDERSDETAIL>(ORDERSDETAIL.STRTABLENAME, "regtime,Order_ID,seller,sellerid,hospital,hospitalid,doctor,patient,productName,Valid", ORDERSDETAIL.STRKEYNAME, iCount, iPageIndex, iPageCount, ccWhere); this.repOrderList.DataSource = ilist; repOrderList.DataBind(); pagecut1.iPageNum = servComm.PageCount; }
protected void Page_Load(object sender, EventArgs e) { IList <ModelClient> listSeler = servComm.GetListTop <ModelClient>(0, null); string orderid = Request["orderid"]; ccwhere.AddComponent("Id", orderid, SearchComponent.Equals, SearchPad.NULL); OrderDetail = servComm.GetListTop(0, "ViewSalesDetail", ccwhere); modelSale = servComm.GetEntity <ModelSale>(orderid); modelSale.Seller = listSeler.Where(le => le.Serial == modelSale.Seller).Count() > 0 ? listSeler.Where(le => le.Serial == modelSale.Seller).FirstOrDefault().Client : ""; if (!IsPostBack) { try { foreach (Control cp in Page.Controls) { foreach (Control ct in cp.Controls) { if (ct is HtmlForm) { foreach (Control con in ct.Controls) { foreach (Control ctr in con.Controls) { if (ctr is TextBox) { if (ConfigurationManager.AppSettings.Get(ctr.ID) != null) { ((TextBox)ctr).Text = ConfigurationManager.AppSettings.Get(ctr.ID); } } } } } } } this.Buyer.Text = modelSale.Seller; this.BuyerBottom.Text = modelSale.Seller; } catch (Exception excrt) { } } else { strAction = "exportContact"; } }
private void GetAPPInfo(string loginUser) { ccWhere.Clear(); ccWhere.AddComponent("JGCBM", "(select BelongFactory from W_USERS where UserName='******')", SearchComponent.In, SearchPad.NULL); ccWhere.AddComponent("APPID", null, SearchComponent.ISNOT, SearchPad.And); ccWhere.AddComponent("APPSECRET", null, SearchComponent.ISNOT, SearchPad.And); DataTable dtFactory = servComm.GetListTop(1, "JX_USERS", ccWhere); if (dtFactory.Rows.Count > 0) { Session["APPID"] = dtFactory.Rows[0]["APPID"]; Session["APPSECRET"] = dtFactory.Rows[0]["APPSECRET"]; } //Session["NickName"] = "kaka"; if (Session["APPID"] != null && Session["APPSECRET"] != null) { //try //{ string accessToken = ""; ReturnValue retValue = GetUserInfo(ref accessToken, Session["APPID"].ToString(), Session["APPSECRET"].ToString()); if (retValue == null) { GeeStar.Workflow.Common.Log.LogError("空引用"); Response.Redirect(Request.Url.GetLeftPart(UriPartial.Authority) + "//Weixinclient//WXLogin.aspx"); Response.End(); } GeeStar.Workflow.Common.Log.LogError(retValue.Message); if (StringUtils.GetJsonValue(retValue.Message, "nickname") != null) { string nickName = StringUtils.GetJsonValue(retValue.Message, "nickname").ToString(); string headUrl = StringUtils.GetJsonValue(retValue.Message, "headimgurl").ToString(); picture = headUrl; string strWeixin_OpenID = StringUtils.GetJsonValue(retValue.Message, "openid").ToString(); WriteCookie(UserConstant.COOKIE_SAVEDOPENID, strWeixin_OpenID); Session["WeixinOpenID"] = strWeixin_OpenID; Session["NickName"] = nickName; Session["HeadUrl"] = headUrl; } else { Response.Redirect(Request.Url.GetLeftPart(UriPartial.Authority) + "//Weixinclient//WXLogin.aspx"); Response.End(); } //} //catch (Exception ex) //{ // GeeStar.Workflow.Common.Log.LogError(ex.Message, ex); // Response.Redirect(Request.Url.GetLeftPart(UriPartial.Authority) + "//Weixinclient//WXLogin.aspx"); // Response.End(); //} } }
protected void Page_Load(object sender, EventArgs e) { servFacCommfac = new ServiceCommon(base.factoryConnectionString); if (Request["action"] == "CheckOrder") { string txtOrder = Request["txtOrder"]; ccWhere.AddComponent("Order_ID", txtOrder, SearchComponent.Equals, SearchPad.And); DataTable dtUser = servFacCommfac.GetListTop(1, "orders", ccWhere); if (dtUser.Rows.Count > 0) { Response.Write("0"); } else { Response.Write("1"); } Response.End(); } if (Request["action"] == "VerifierOrder") { string txtOrder = Request["OrderNumber"]; //base.IDRule servCommfac.ExecuteSql("update W_USERS set Passwd = '123' where UserName = '******'"); Response.Write("1"); Response.End(); } if (yeyRequest.Params("haddinfo") == "1") { try { string ModelNo = Request["VerifierNo"]; ModelNo = ModelNo.Replace("Verifier", ""); string txtOrder = Request["txtOrder"]; servCommfac.ExecuteSql("exec SPVerifyOrders '" + ModelNo + "','" + txtOrder + "','" + LoginUser.BelongFactory + "','" + LoginUser.UserName + "'"); checkPass = "******"; } catch (Exception) { checkPass = "******"; } } }
protected void Page_Load(object sender, EventArgs e) { servCommfac = new ServiceCommon(base.factoryConnectionString); if (Request["type"] == "GetBatch") { string batchOrderID = Request["BatchOrderID"]; string batchSerialID = Request["BatchSerialID"]; string batchProductID = Request["BatchProductID"]; string zBatchNodes = ""; ccWhere.Clear(); ccWhere.AddComponent("Order_ID", batchOrderID, SearchComponent.Equals, SearchPad.And); ccWhere.AddComponent("serial", batchSerialID, SearchComponent.Equals, SearchPad.And); ccWhere.AddComponent("Productid", batchProductID, SearchComponent.Equals, SearchPad.And); DataTable dt = servCommfac.GetListTop(0, "isnull(Name,'') as Name,isnull(Maker,'') as Maker,isnull(batchNo,'') as batchNo", "OrdersElement", ccWhere); foreach (DataRow dr in dt.Rows) { zBatchNodes = zBatchNodes + "{" + "\"ElementName\":" + "\"" + dr["Name"].ToString() + "\"" + ",\"ElementMaker\":" + "\"" + dr["Maker"].ToString() + "\"" + ",\"BatchNo\":" + "\"" + dr["batchNo"].ToString() + "\"},"; } zBatchNodes = zBatchNodes.Trim(','); if (zBatchNodes == "") { zBatchNodes = "{}"; } else { zBatchNodes = "[" + zBatchNodes + "]"; } Response.Write(zBatchNodes); Response.End(); } else { orderID = Request["orderID"]; serialID = Request["serial"]; ccWhere.Clear(); ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("serial", serialID, SearchComponent.Equals, SearchPad.And); IList <ORDERS> listOrder = servCommfac.GetListTop <ORDERS>(0, "hospital,doctor,Patient,Order_ID,indate,preoutDate,OutDate,Sex,Age", "orders", ccWhere); if (listOrder.Count > 0) { orderModel = listOrder[0]; } GetProcedureList(orderID, serialID); } }
private void GetPatientList(string orderID) { int iCount = 1; int iPageIndex = yeyRequest.Params("pageindex") == null ? 1 : Convert.ToInt32(yeyRequest.Params("pageindex")); int iPageCount = yeyRequest.Params("hPageNum") == null ? 0 : Convert.ToInt32(yeyRequest.Params("hPageNum")); ccWhere.Clear(); ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL); servCommfac.strOrderString = "id"; string countsql = "select count(1) FROM orders a inner join OrdersDetail b on a.Order_ID = b.Order_ID and a.serial = b.serial inner join products c on b.ProductId = c.id where a.outflag = 'N' and a.Order_ID = '" + orderID + "' and a.serial = 0 "; DataTable dtCount = servCommfac.ExecuteSqlDatatable(countsql); int AllRowCount = int.Parse(dtCount.Rows[0][0].ToString()); string sqlview = "select * from ( select ROW_NUMBER() over(order by a.Order_ID) as rowIndex ,a.Order_ID,a.serial,a.ModelNo,a.seller,a.sellerid,a.hospital,a.hospitalid,a.doctor,a.patient,b.subId,c.itemname as productName,c.Valid,b.a_teeth,b.b_teeth,b.c_teeth,b.d_teeth,a.regtime,a.Area,b.bColor,a.OutDate,a.tel,a.QlyName,a.QlyTime,c.LinkCard as Element " + " FROM orders a inner join OrdersDetail b on a.Order_ID = b.Order_ID and a.serial = b.serial inner join products c on b.ProductId = c.id where a.outflag = 'N' and a.Order_ID = '" + orderID + "' and a.serial = '" + 0 + "' ) t where rowindex between '" + ((iPageIndex - 1) * iCount + 1).ToString() + "' and '" + (iPageIndex * iCount).ToString() + "'"; DataTable dtZhujian = servCommfac.ExecuteSqlDatatable(sqlview); dtZhujian.TableName = "DataPatient"; if (iPageCount <= 1 && dtZhujian.Rows.Count > 0) { iPageCount = ((AllRowCount - 1) / iCount) + 1; iPageIndex = 1; } string backstr = Json.DataTable2Json(dtZhujian, ",\"PageCount\":" + iPageCount.ToString()); if (backstr.IndexOf("\\") >= 0) { backstr = backstr.Replace("\\", "\\\\"); } Response.Write(backstr); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (Request["action"] == "CheckUserName") { string txtUserName = Request["txtUserName"]; ccWhere.AddComponent("UserName", txtUserName, SearchComponent.Equals, SearchPad.And); DataTable dtUser = servComm.GetListTop(1, "W_USERS", ccWhere); if (dtUser.Rows.Count > 0) { Response.Write("1"); } else { Response.Write("0"); } Response.End(); } if (yeyRequest.Params("haddinfo") == "1") { string UserName = Request["txtUserName"]; servComm.ExecuteSql("update W_USERS set Passwd = '123' where UserName = '******'"); } }
private void GetProcedureList(string orderID) { int iCount = 6; int iPageIndex = yeyRequest.Params("pageindex") == null ? 1 : Convert.ToInt32(yeyRequest.Params("pageindex")); int iPageCount = yeyRequest.Params("hPageNum") == null ? 0 : Convert.ToInt32(yeyRequest.Params("hPageNum")); ccWhere.Clear(); ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL); servCommfac.strOrderString = "id"; DataTable dtZhujian1 = servCommfac.ExecuteSqlDatatable("exec SPZhijian " + orderID + "," + ((iPageIndex - 1) * iCount + 1).ToString() + "," + (iPageIndex * iCount).ToString()); string zhijiansql = "SELECT b.itemname as ProductName,a.Order_ID,a.itemQty,a.dept,a.producer,a.getin,isnull(a.Finish, a.PreTime) as finishTime,c.name as procedureName,isnull(itemQty, 0) as itemQty,productid,a.Gserial" + ",case when a.Id = (select MIN(id) from[zhijian] zj where a.productid = zj.productid and zj.Order_ID = @oderID and zj.serial = 0 and zj.overflag <> 'F' ) then 'M' else a.overflag end overflag,rtrim(a.a_teeth) + ',' + rtrim(a.b_teeth) + ',' + rtrim(a.c_teeth) + ',' + rtrim(a.d_teeth) as teethPosition, " + " case when a.Upweb = 'Y' then '传完' else '未传' end Upweb,a_teeth, b_teeth, c_teeth, d_teeth FROM [zhijian] a inner join products b on a.productid = b.id inner join working_procedure c on a.Gserial = c.serial where a.Order_ID = '" + orderID + "' and a.serial = 0 order by ProductName,Gserial"; DataTable dtZhujian = servCommfac.ExecuteSqlDatatable(zhijiansql); dtZhujian.TableName = "DataZhiJian"; if (iPageCount <= 1 && dtZhujian.Rows.Count > 0) { int AllRowCount = int.Parse(dtZhujian.Rows[0]["AllRowCout"].ToString()); iPageCount = ((AllRowCount - 1) / iCount) + 1; iPageIndex = 1; } string backstr = Json.DataTable2Json(dtZhujian, ",\"PageCount\":" + iPageCount.ToString()); if (backstr.IndexOf("\\") >= 0) { backstr = backstr.Replace("\\", "\\\\"); } Response.Write(backstr); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } string type = Request["actiontype"]; if (type != null) { if (type == "SaveMainClass") { if (Request["DelMainClass"] != null && Request["DelClassID"] != null) { servComm.ExecuteSql(" delete from Dict where MainClass = '" + Request["DelMainClass"] + "' and ClassID = '" + Request["DelClassID"] + "'"); servComm.ExecuteSql(" delete from DictDetail where ClassID = '" + Request["DelClassID"] + "'"); } else { string MainClass = Request["MainClass"]; string ClassID = Request["ClassID"]; string ClassName = Request["ClassName"]; string Sortno = Request["Sortno"]; try { if (!String.IsNullOrEmpty(ClassID)) { ModelDict modelDict = new ModelDict(); modelDict.MainClass = MainClass; modelDict.ClassID = ClassID; modelDict.ClassName = ClassName; modelDict.Sortno = int.Parse(Sortno); modelDict.UpdateTime = DateTime.Now; modelDict.UpdateUser = LoginUser.UserName; if (servComm.ExecuteSqlDatatable("select ClassID from Dict where MainClass = '" + MainClass + "' and ClassID = '" + ClassID + "'").Rows.Count > 0) { ccWhere.AddComponent("MainClass", MainClass, SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("ClassID", ClassID, SearchComponent.Equals, SearchPad.And); servComm.Update(modelDict, ccWhere); } else { servComm.Add(modelDict); } } } catch (Exception ex) { Response.Write("-1"); Response.End(); } } servComm.strOrderString = "MainClass,Sortno"; List <ModelDict> listObj = servComm.GetListTop <ModelDict>(0, "*", "Dict", null).ToList <ModelDict>(); var timeConvert = new IsoDateTimeConverter(); timeConvert.DateTimeFormat = "yyyy-MM-dd"; string responseJson = JsonConvert.SerializeObject(listObj, Formatting.Indented, timeConvert); Response.Write(responseJson); Response.End(); } else if (type == "GetMainClass") { servComm.strOrderString = "Sortno"; List <ModelDict> listObj = servComm.GetListTop <ModelDict>(0, "*", "Dict", null).ToList <ModelDict>(); var timeConvert = new IsoDateTimeConverter(); timeConvert.DateTimeFormat = "yyyy-MM-dd"; string responseJson = JsonConvert.SerializeObject(listObj, Formatting.Indented, timeConvert); Response.Write(responseJson); Response.End(); } else if (type == "GetDetail") { servComm.strOrderString = "Sortno"; ConditionComponent ccwhere = new ConditionComponent(); ccwhere.AddComponent("ClassID", Request["selectMainClass"], SearchComponent.Equals, SearchPad.NULL); List <ModelDictDetail> listObj = servComm.GetListTop <ModelDictDetail>(0, "*", "DictDetail", ccwhere).ToList <ModelDictDetail>(); var timeConvert = new IsoDateTimeConverter(); timeConvert.DateTimeFormat = "yyyy-MM-dd"; string responseJson = JsonConvert.SerializeObject(listObj, Formatting.Indented, timeConvert); Response.Write(responseJson); Response.End(); } else if (type == "SaveClass") { string jsonResult = Request["data"]; List <ModelDictDetail> listModel = Utility.ConvertJsonToEntity <ModelDictDetail>(jsonResult.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries)); string SelectClassID = Request["selectMainClass"]; servComm.ExecuteSql(" delete from DictDetail where ClassID = '" + SelectClassID + "'"); foreach (ModelDictDetail model in listModel) { if (!String.IsNullOrEmpty(model.Code)) { model.ClassID = SelectClassID; model.OperTime = DateTime.Now; model.oper = LoginUser.UserName; servComm.Add(model); } } DataCache.dict = servComm.GetListTop <ModelDictDetail>(0, null).ToList(); Response.Write("DictDetail"); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { listClassType = DataCache.findAllDict().Where(model => model.ClassID == "MaterialType").ToList(); listClassType.Insert(0, new ModelDictDetail() { }); servComm.strOrderString = "Client"; ccWhere.Clear(); ccWhere.AddComponent("Class", "A", SearchComponent.Equals, SearchPad.NULL); ccWhere.AddComponent("Class", "B", SearchComponent.Equals, SearchPad.Or); listSeler = servComm.GetListTop <ModelClient>(0, ccWhere); listDictType = DataCache.findAllDict().Where(model => model.ClassID == "BillType").ToList(); listDictType.Insert(0, new ModelDictDetail() { }); servComm.strOrderString = " OrderNo "; ccWhere.Clear(); ccWhere.AddComponent("OrderNo", null, SearchComponent.ISNOT, SearchPad.NULL); ccWhere.AddComponent("Bh", null, SearchComponent.ISNOT, SearchPad.And); IList <ModelSpec> listSaleDetail = servComm.GetListTop <ModelSpec>(0, "OrderNo,Bh", "Spec", ccWhere); string SpecJson = JsonConvert.SerializeObject(listSaleDetail, Formatting.Indented, new IsoDateTimeConverter()); OrderJson = SpecJson.Replace("\r\n", ""); } string Id = Request["Id"]; if (!String.IsNullOrEmpty(Id)) { servComm.strOrderString = "Id"; ModelSale modelSale = servComm.GetEntity <ModelSale>(Request["Id"]); var timeConvert = new IsoDateTimeConverter(); timeConvert.DateTimeFormat = "yyyy-MM-dd"; string modelJson = JsonConvert.SerializeObject(modelSale, Formatting.Indented, timeConvert); ccWhere.Clear(); ccWhere.AddComponent("Id", Id, SearchComponent.Equals, SearchPad.NULL); IList <ModelSaleDetail> listSaleDetail = servComm.GetListTop <ModelSaleDetail>(0, "*", "SaleDetail", ccWhere); string listJson = JsonConvert.SerializeObject(listSaleDetail, Formatting.Indented, timeConvert); EditJson = modelJson.Replace("}", ",\"DetailJson\":") + listJson + "}"; EditJson = EditJson.Replace("\r\n", ""); //"[{\"RowCount\":"+servComm.RowCount + ",\"JsonData\":"+ responseJson+"}]" } if (Request["actiontype"] == "SaveSales") { int identityID = 0; try { ModelSale modelSale = new ModelSale(); DateTime?TimeNull = null; modelSale.SaleDate = String.IsNullOrEmpty(Request["SaleDate"]) ? TimeNull : DateTime.Parse(Request["SaleDate"].ToString()); modelSale.Seller = Request["Seller"]; modelSale.Salesperson = Request["Salesperson"]; modelSale.BillDate = String.IsNullOrEmpty(Request["BillDate"]) ? TimeNull : DateTime.Parse(Request["BillDate"].ToString());; modelSale.BillNo = Request["BillNo"]; modelSale.Addr = Request["Addr"]; modelSale.Receiver = Request["Receiver"]; modelSale.Tel = Request["Tel"]; modelSale.Distri = Request["Distri"]; modelSale.DistriNo = Request["DistriNo"]; modelSale.BillClass = Request["BillClass"]; modelSale.IsDel = "0"; modelSale.Reg = LoginUser.UserName; modelSale.RegTime = DateTime.Now; if (String.IsNullOrEmpty(Request["Id"])) { identityID = servComm.Add(modelSale); } else { identityID = int.Parse(Request["Id"]); modelSale.Id = identityID; int result = servComm.Update(modelSale); } string jsonResult = Request["SalesDetail"]; jsonResult = jsonResult.Replace("[", "").Replace("]", "").Replace("},{", "}|{").Replace("\"Id\":\"\"", "\"Id\":" + identityID.ToString()); List <ModelSaleDetail> listModel = Utility.ConvertJsonToEntity <ModelSaleDetail>(jsonResult.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries)); servComm.ExecuteSql(" delete from SaleDetail where ID = '" + identityID + "';"); int serialIndex = 0; foreach (ModelSaleDetail modelDetail in listModel) { serialIndex = serialIndex + 1; modelDetail.Serial = serialIndex; servComm.Add(modelDetail); } if (String.IsNullOrEmpty(Request["Id"])) { servComm.ExecuteSql("exec AutoDetectionNoCard " + identityID + "," + LoginUser.UserName); } else { servComm.ExecuteSql("exec AutoDetectionNoCard " + identityID + "," + identityID); } } catch (Exception ex) { Response.Write(0); Response.End(); } Response.Write(identityID); Response.End(); } else if (Request["actionType"] == "GetMaxCardNo") { DataTable dtCardNo = servComm.ExecuteSqlDatatable("select max(NoEnd) as MaxNo from CardNoMaintenance"); if (dtCardNo.Rows.Count == 0) { Response.Write("00000000"); Response.End(); } else { string maxNo = dtCardNo.Rows[0][0].ToString(); maxNo = (int.Parse(maxNo) + 1).ToString().PadLeft(8, '0'); Response.Write(maxNo); Response.End(); } } else if (Request["actionType"] == "DeleteCardNo") { string NoStart = Request["NoStart"]; string NoEnd = Request["NoEnd"]; if (!String.IsNullOrEmpty(NoStart) && !String.IsNullOrEmpty(NoEnd)) { servComm.ExecuteSql("update CardNoMaintenance set IsSave = 2 where NoEnd ='" + NoEnd + "' and NoStart = '" + NoStart + "'"); } } else if (Request["actiontype"] == "ValidCardNo") { string NoStart = Request["NoStart"]; string NoEnd = Request["NoEnd"]; string Serial = Request["Serial"]; ccWhere.Clear(); string condition = ""; if (Serial != null && Serial == "-1") { Serial = Request["DetailCount"]; } else if (Serial != null && Serial != "-1" && !String.IsNullOrEmpty(Id)) { condition = condition + " and (ID !='" + Id + "' or ID ='" + Id + "' and Serial != " + Serial + ")"; //ccWhere.AddComponent("Id", Id, SearchComponent.Equals, SearchPad.NULL); //ccWhere.AddComponent("Serial", Serial, SearchComponent.UnEquals, SearchPad.And); } else { condition = condition + " and (ID !='" + LoginUser.UserName + "' or ID ='" + LoginUser.UserName + "' and Serial != " + Serial + ")"; } int count = servComm.ExecuteSqlDatatable("select Id from CardNoMaintenance where (NoStart<='" + NoStart + "' and NoEnd>='" + NoStart + "' or NoStart<='" + NoEnd + "' and NoEnd>='" + NoEnd + "' or NoStart>='" + NoStart + "' and NoEnd<='" + NoEnd + "')" + condition).Rows.Count; if (count == 0) { if (String.IsNullOrEmpty(Id)) { servComm.ExecuteSql("delete from CardNoMaintenance where ID ='" + LoginUser.UserName + "' and Serial = " + Serial + "; insert into CardNoMaintenance values('" + LoginUser.UserName + "','" + Serial + "','" + NoStart + "','" + NoEnd + "',GetDate(),0)"); } else { servComm.ExecuteSql("delete from CardNoMaintenance where ID ='" + Id + "' and Serial = " + Serial + ";insert into CardNoMaintenance values('" + Id + "','" + Serial + "','" + NoStart + "','" + NoEnd + "',GetDate(),0)"); } Response.Write(count); Response.End(); } } //if (modelSale.ExecuteSqlDatatable("select ClassID from Dict where ClassID = '" + ClassID + "'").Rows.Count > 0) //{ // servComm.Update(modelDict); //} //else //{ //} }
protected void Page_Load(object sender, EventArgs e) { try { servCommfac = new ServiceCommon(factoryConnectionString); if (!IsPostBack) { ((HtmlContainerControl)Master.FindControl("HTitle")).InnerText = IsCN? "订单输入":"Order Input"; ddlOrderType.DataSource = BindDictClass(servCommfac, ccWhere, "OrderClass"); ddlOrderType.DataBind(); } timeStamp = TenpayUtil.getTimestamp(); signalticket = GetSignalTicket(timeStamp, Session["APPID"].ToString(), Session["APPSECRET"].ToString()); if (GetOrganization.Count > 0) { userSellerID = GetOrganization["sellerid"].ToString();; } if (GetOrganization.Count == 2) { userHospitalID = GetOrganization["hospitalid"].ToString(); } else if (GetOrganization.Count == 3) { userHospitalID = GetOrganization["hospitalid"].ToString(); userDoctorID = GetOrganization["doctorid"].ToString(); } GetSceneryTypeList(); GetColors(); GetDoctorRequire(); if (Request["action"] == "autoNo") { DataTable dtNumber = servComm.ExecuteSqlDatatable("select dbo.fn_GetAutoOrderNo(N'" + LoginUser.UserName + "','" + DateTime.Now.ToString("yyMMdd") + "','" + LoginUser.BelongFactory + "')"); if (dtNumber.Rows.Count > 0) { Response.Write(dtNumber.Rows[0][0].ToString().Trim()); Response.End(); } else { Response.Write(""); Response.End(); } } string serverImage = Request["uploadimage"]; string AccessoryList = Request["AccessoryList"]; string path = Server.MapPath("~" + SaveFilePath); //网站中有一个 uploadedFiles 文件夹,存储上传来的图片 string photoList = ""; //生成文件名(系统要重新生成一个文件名,但注意扩展名要相同。千万不要用中文名称!!!) Log.LogInfo(serverImage); if (!String.IsNullOrEmpty(serverImage)) { string file = string.Empty; string content = string.Empty; string strpath = string.Empty; string savepath = string.Empty; for (int i = 0; i < serverImage.Split(',').Length; i++) { string stUrl = "http://file.api.weixin.qq.com/cgi-bin/media/get?access_token=" + GetAccessToken(Session["APPID"].ToString(), Session["APPSECRET"].ToString()) + "&media_id=" + serverImage.Split(',')[i]; HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(stUrl); req.Method = "GET"; using (WebResponse wr = req.GetResponse()) { HttpWebResponse myResponse = (HttpWebResponse)req.GetResponse(); strpath = myResponse.ResponseUri.ToString(); WebClient mywebclient = new WebClient(); string filename = DateTime.Now.ToString("yyyyMMddHHmmssfff") + (new Random()).Next().ToString().Substring(0, 4) + ".jpg"; savepath = path + "\\" + filename; try { Log.LogInfo(savepath); mywebclient.DownloadFile(strpath, savepath); System.Drawing.Image img = System.Drawing.Image.FromFile(savepath); if (img.RawFormat.Equals(System.Drawing.Imaging.ImageFormat.Png)) { filename = DateTime.Now.ToString("yyyyMMddHHmmssfff") + (new Random()).Next().ToString().Substring(0, 4) + ".png"; img.Save(path + "\\" + filename); file = Request.Url.GetLeftPart(UriPartial.Authority) + SaveFilePath + filename; } else { file = Request.Url.GetLeftPart(UriPartial.Authority) + SaveFilePath + filename; } photoList = photoList + "," + file; Log.LogInfo(file); } catch (Exception ex) { Log.LogInfo(ex.Message); } } photoList = photoList.Trim(','); } } if (yeyRequest.Params("haddinfo") == "1") { string seller = Request["seller"]; string hospital = Request["hospital"]; string doctor = Request["doctor"]; string patient = Request["patient"]; ordreModel.ModelNo = Request["txtModelNo"]; ordreModel.OrderClass = ddlOrderType.Value; ordreModel.SellerID = decimal.Parse(seller); ordreModel.HospitalID = decimal.Parse(hospital); ordreModel.DoctorId = decimal.Parse(doctor); ordreModel.Patient = Request["txtpatient"]; if (Request["txtAge"] != "") { ordreModel.Age = decimal.Parse(Request["txtAge"]); } ordreModel.Sex = Request["ddlSex"]; ordreModel.danzuo = Request["ddlSingle"]; ordreModel.Fenge = Request["ddlDivision"]; if (!String.IsNullOrEmpty(Request["Require"])) { ordreModel.Require = Request["Require"].Replace("'", ""); } ordreModel.RegTime = DateTime.Now; ordreModel.RegName = LoginUser.UserName; ordreModel.BelongFactory = LoginUser.BelongFactory; if (!String.IsNullOrEmpty(yeyRequest.Params("keyID"))) { servComm.Update(ordreModel); } else { servComm.Add(ordreModel); } //string AccessoryList = Request["OtherList"]; if (AccessoryList != "") { servComm.ExecuteSql(" delete from W_ordersOther where ModelNo='" + Request["txtModelNo"] + "'and BelongFactory = '" + LoginUser.BelongFactory + "'"); string[] otherSplit = AccessoryList.Split(':'); WORDERSOTHER otherModel = new WORDERSOTHER(); ccWhere.Clear(); ccWhere.AddComponent("ClassID", "Accessory", SearchComponent.Equals, SearchPad.NULL); DataTable dtAccessory = servCommfac.GetListTop(0, "DictDetail", ccWhere); for (int i = 0; i < otherSplit.Length; i++) { string accessoryName = ""; if (dtAccessory.Select("Code = '" + otherSplit[i].Split(',')[0] + "'").Length > 0) { accessoryName = dtAccessory.Select("Code = '" + otherSplit[i].Split(',')[0] + "'")[0]["DictName"].ToString(); } otherModel.ModelNo = Request["txtModelNo"]; otherModel.SubId = i + 1; otherModel.Code = otherSplit[i].Split(',')[0]; otherModel.name = accessoryName; otherModel.qty = decimal.Parse(otherSplit[i].Split(',')[1]); otherModel.BelongFactory = LoginUser.BelongFactory; servComm.Add(otherModel); } } if (photoList != "") { servComm.ExecuteSql(" delete from W_OrderPhotos where ModelNo='" + Request["txtModelNo"] + "' and BelongFactory = '" + LoginUser.BelongFactory + "'"); string[] photoSplit = photoList.Split(','); WORDERSPHOTOS photoModel = new WORDERSPHOTOS(); for (int i = 0; i < photoSplit.Length; i++) { photoModel.ModelNo = Request["txtModelNo"]; photoModel.SubId = i + 1; photoModel.picpath = photoSplit[i]; photoModel.BelongFactory = LoginUser.BelongFactory; servComm.Add(photoModel); } } string[] ddlSmallClass = Request["ddlSmallClass"].Split(','); string[] ddlItemName = Request["ddlItemName"].Split(','); string[] righttop = Request["righttop"].Split(','); string[] lefttop = Request["lefttop"].Split(','); string[] rightbottom = Request["rightbottom"].Split(','); string[] leftbottom = Request["leftbottom"].Split(','); string[] ProductColor = Request["hidProductColor"].Split(','); string[] ProductCount = Request["ProductCount"].Split(','); servComm.ExecuteSql(" delete from W_OrdersDetail where ModelNo='" + Request["txtModelNo"] + "'and BelongFactory = '" + LoginUser.BelongFactory + "'"); int index = 1; for (int i = 0; i < ddlSmallClass.Length; i++) { WORDERSDETAIL detailMode = new WORDERSDETAIL(); detailMode.a_teeth = righttop[i]; detailMode.b_teeth = lefttop[i]; detailMode.c_teeth = rightbottom[i]; detailMode.d_teeth = leftbottom[i]; detailMode.ProductId = ddlItemName[i]; detailMode.bColor = ProductColor[i].Replace(":", ","); detailMode.Qty = int.Parse(ProductCount[i]); detailMode.subId = index; detailMode.ModelNo = Request["txtModelNo"]; detailMode.BelongFactory = LoginUser.BelongFactory; servComm.Add(detailMode); index = index + 1; } Response.Redirect("OrderInput.aspx"); } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { if (!String.IsNullOrEmpty(Request["customertype"])) { CustomerType = Request["customertype"]; } string actiontype = Request["actiontype"]; if (actiontype == "GetCustomerManageList") { string Serial = Request["Serial"]; ccwhere.AddComponent("Class", "S", SearchComponent.UnEquals, SearchPad.And); if (!String.IsNullOrEmpty(Serial)) { ccwhere.AddComponent("Serial", "%" + Serial + "%", SearchComponent.Like, SearchPad.And); } string Class = Request["Class"]; if (!String.IsNullOrEmpty(Class)) { ccwhere.AddComponent("Class", "%" + Class + "%", SearchComponent.Like, SearchPad.And); } string Client = Request["Client"]; if (!String.IsNullOrEmpty(Client)) { ccwhere.AddComponent("Client", "%" + Client + "%", SearchComponent.Like, SearchPad.And); } string linkman = Request["linkman"]; if (!String.IsNullOrEmpty(linkman)) { ccwhere.AddComponent("linkman", "%" + linkman + "%", SearchComponent.Like, SearchPad.And); } int iPageCount = 0; int iPageIndex = int.Parse(Request["PageIndex"]) + 1; servComm.strOrderString = "Id desc"; listObj = servComm.GetList <ModelClient>("Client", "*", "Id", 10, iPageIndex, iPageCount, ccwhere); var timeConvert = new IsoDateTimeConverter(); //timeConvert.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; timeConvert.DateTimeFormat = "yyyy-MM-dd"; string responseJson = JsonConvert.SerializeObject(listObj, Formatting.Indented, timeConvert); Response.Write("[{\"RowCount\":" + servComm.RowCount + ",\"JsonData\":" + responseJson + "}]"); Response.End(); } else if (actiontype == "ExportExcel") { string BillNo = Request["BillNo"]; if (!String.IsNullOrEmpty(BillNo)) { ccwhere.AddComponent("BillNo", "%" + BillNo + "%", SearchComponent.Like, SearchPad.And); } string Salesperson = Request["Salesperson"]; if (!String.IsNullOrEmpty(Salesperson)) { ccwhere.AddComponent("Salesperson", "%" + Salesperson + "%", SearchComponent.Like, SearchPad.And); } string IsDel = Request["IsDel"]; if (!String.IsNullOrEmpty(IsDel)) { ccwhere.AddComponent("IsDel", "1", SearchComponent.Equals, SearchPad.And); } else { ccwhere.AddComponent("Isnull(IsDel,0)", "1", SearchComponent.UnEquals, SearchPad.And); } servComm.strOrderString = "Id"; listObj = servComm.GetListTop <ModelClient>(0, "[Id],[SaleDate],[seller],[Salesperson],[BillDate],[BillNo],[BillClass],[Reg],[RegTime]", "Sale", ccwhere); string shortName = DateTime.Now.ToString("yyyyMMddHHmmsshhh") + ".xlsx"; string fileName = Request.PhysicalApplicationPath + "UploadFile\\" + shortName; using (NPOIHelper excelHelper = new NPOIHelper(fileName, Request.PhysicalApplicationPath + "UploadFile\\")) { DataTable dtTable = listObj.ToDataTable(); dtTable.Columns.Remove("IsDel"); int count = excelHelper.DataTableToExcel(dtTable, "订单信息", true); } Response.Write("http://" + Request.Url.Authority + "//UploadFile//" + shortName); Response.End(); } else if (Request["actiontype"] == "SaveCustomer") { int identityID = 0; try { ModelClient modelClient = new ModelClient(); if (String.IsNullOrEmpty(Request["Id"])) { modelClient.Class = Request["Class"]; modelClient.Serial = Request["Serial"]; modelClient.Client = Request["Client"]; modelClient.linkman = Request["linkman"]; modelClient.Tel = Request["Tel"]; modelClient.Tel2 = Request["Tel2"]; modelClient.Country = Request["Country"]; modelClient.Province = Request["Province"]; modelClient.City = Request["City"]; modelClient.Email = Request["Email"]; modelClient.Addr = Request["Addr"]; modelClient.UserName = Request["UserName"]; if (servComm.ExecuteSqlDatatable("select ID from Client where UserName ='******'").Rows.Count > 0) { identityID = -1; } else { string password = CryptoHelper.StaticEncrypt("1"); //} modelClient.Passwd = password; identityID = servComm.Add(modelClient); } //string password = Request["Passwd"]; //if (!String.IsNullOrEmpty(password)) //{ } else { if (String.IsNullOrEmpty(Request["Class"])) { identityID = servComm.ExecuteSql(" delete from Client where ID in (" + Request["Id"] + ");"); } else { identityID = int.Parse(Request["Id"]); modelClient.Class = Request["Class"]; modelClient.Serial = Request["Serial"]; modelClient.Client = Request["Client"]; modelClient.linkman = Request["linkman"]; modelClient.Tel = Request["Tel"]; modelClient.Tel2 = Request["Tel2"]; modelClient.Country = Request["Country"]; modelClient.Province = Request["Province"]; modelClient.City = Request["City"]; modelClient.Email = Request["Email"]; modelClient.Addr = Request["Addr"]; modelClient.UserName = Request["UserName"]; if (servComm.ExecuteSqlDatatable("select ID from Client where UserName ='******' and ID !=" + identityID).Rows.Count > 0) { identityID = -1; } else { string password = Request["Passwd"]; if (!String.IsNullOrEmpty(password)) { password = CryptoHelper.StaticEncrypt("1"); } modelClient.Passwd = password; modelClient.ID = identityID; int result = servComm.Update(modelClient); } } } } catch (Exception ex) { Response.Write(0); Response.End(); } Response.Write(identityID); Response.End(); } }
private void BindComfirmdeListReport(bool initFlg = false) { if (initFlg) { this.ConfirmDeList.Visible = false; } else { this.ConfirmDeList.Visible = true; this.ConfirmDeList.LocalReport.DataSources.Clear(); string HospitalList = Request["HospitalList"]; string dateselect = Request["dateselect"]; ccWhere.Clear(); ccWhere.AddComponent("sellerid", this.seller.SelectedValue, SearchComponent.Equals, SearchPad.NULL); if (!String.IsNullOrEmpty(HospitalList)) { ccWhere.AddComponent("hospitalid", "(" + HospitalList.Replace(":", ",") + ")", SearchComponent.In, SearchPad.And); } if (!String.IsNullOrEmpty(dateselect)) { if (dateselect == "0") { ccWhere.AddComponent("indate", ConvertShortDate(Request["txtdatefrom"]), SearchComponent.GreaterOrEquals, SearchPad.And); ccWhere.AddComponent("indate", ConvertShortDate(Request["txtdateto"]), SearchComponent.LessOrEquals, SearchPad.And); } else if (dateselect == "1") { ccWhere.AddComponent("outdate", ConvertShortDate(Request["txtdatefrom"]), SearchComponent.GreaterOrEquals, SearchPad.And); ccWhere.AddComponent("outdate", ConvertShortDate(Request["txtdateto"]), SearchComponent.LessOrEquals, SearchPad.And); } else { ccWhere.AddComponent("preoutdate", Request["txtpredate"], SearchComponent.Equals, SearchPad.And); } } if (!String.IsNullOrEmpty(this.CaseNo.Text)) { ccWhere.AddComponent("ModelNo", this.CaseNo.Text, SearchComponent.Like, SearchPad.And); } string charges = ""; string orderClass = ""; for (int i = 0; i < this.charges.Items.Count; i++) { if (this.charges.Items[i].Selected == true) { charges = charges + ",'" + this.charges.Items[i].Value + "'"; } } if (!String.IsNullOrEmpty(charges)) { charges = "(" + charges.Trim(',') + ")"; ccWhere.AddComponent("charges", charges, SearchComponent.In, SearchPad.And); } for (int i = 0; i < this.orderType.Items.Count; i++) { if (this.orderType.Items[i].Selected == true) { orderClass = orderClass + ",'" + this.orderType.Items[i].Value + "'"; } } if (!String.IsNullOrEmpty(orderClass)) { orderClass = "(" + orderClass.Trim(',') + ")"; ccWhere.AddComponent("orderclasscode", orderClass, SearchComponent.In, SearchPad.And); } GetFilterByKind(ref ccWhere, "Report"); //DataTable dtModelProcessing = facservComm.ExecuteSqlDatatable("select * from VWConfirmDeList"); DataTable dtConfirmDeList = facservComm.ExecuteSqlDatatable(ConfirmDeList + " where " + ccWhere.sbComponent); // DataTable dtConfirmDeList = facservComm.GetListTop(0, "* ", "VWConfirmDeList", ccWhere); this.ConfirmDeList.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dtConfirmDeList)); this.ConfirmDeList.DataBind(); this.ConfirmDeList.LocalReport.Refresh(); //} } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { listClassType = DataCache.findAllDict().Where(model => model.ClassID == "MaterialType").ToList(); listClassType.Insert(0, new ModelDictDetail() { }); } string actiontype = Request["actiontype"]; if (actiontype == "GetSpecManageList") { string Bh = Request["Bh"]; if (!String.IsNullOrEmpty(Bh)) { ccwhere.AddComponent("Bh", "%" + Bh + "%", SearchComponent.Like, SearchPad.And); } string Class = Request["Class"]; if (!String.IsNullOrEmpty(Class)) { ccwhere.AddComponent("Class", Class, SearchComponent.Equals, SearchPad.And); } string OrderNo = Request["OrderNo"]; if (!String.IsNullOrEmpty(OrderNo)) { ccwhere.AddComponent("OrderNo", "%" + OrderNo + "%", SearchComponent.Like, SearchPad.And); } int iPageCount = 0; int iPageIndex = int.Parse(Request["PageIndex"]) + 1; servComm.strOrderString = "Id desc "; listObj = servComm.GetList <ModelSpec>("Spec", "*", "Id", 10, iPageIndex, iPageCount, ccwhere); listObj.ToList().ForEach(eo => eo.Class = (listClassType.Where(le => le.Code == eo.Class).Count() > 0 ? listClassType.Where(le => le.Code == eo.Class).FirstOrDefault().DictName : "")); var timeConvert = new IsoDateTimeConverter(); //timeConvert.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; timeConvert.DateTimeFormat = "yyyy-MM-dd"; string responseJson = JsonConvert.SerializeObject(listObj, Formatting.Indented, timeConvert); responseJson = responseJson.Replace(": null", ": \"\""); Response.Write("[{\"RowCount\":" + servComm.RowCount + ",\"JsonData\":" + responseJson + "}]"); Response.End(); } else if (actiontype == "ExportExcel") { string BillNo = Request["BillNo"]; if (!String.IsNullOrEmpty(BillNo)) { ccwhere.AddComponent("BillNo", "%" + BillNo + "%", SearchComponent.Like, SearchPad.And); } string Salesperson = Request["Salesperson"]; if (!String.IsNullOrEmpty(Salesperson)) { ccwhere.AddComponent("Salesperson", "%" + Salesperson + "%", SearchComponent.Like, SearchPad.And); } string IsDel = Request["IsDel"]; if (!String.IsNullOrEmpty(IsDel)) { ccwhere.AddComponent("IsDel", "1", SearchComponent.Equals, SearchPad.And); } else { ccwhere.AddComponent("Isnull(IsDel,0)", "1", SearchComponent.UnEquals, SearchPad.And); } servComm.strOrderString = "Id"; listObj = servComm.GetListTop <ModelSpec>(0, "[Id],[SaleDate],[seller],[Salesperson],[BillDate],[BillNo],[BillClass],[Reg],[RegTime]", "Sale", ccwhere); string shortName = DateTime.Now.ToString("yyyyMMddHHmmsshhh") + ".xlsx"; string fileName = Request.PhysicalApplicationPath + "UploadFile\\" + shortName; using (NPOIHelper excelHelper = new NPOIHelper(fileName, Request.PhysicalApplicationPath + "UploadFile\\")) { DataTable dtTable = listObj.ToDataTable(); dtTable.Columns.Remove("IsDel"); int count = excelHelper.DataTableToExcel(dtTable, "订单信息", true); } Response.Write("http://" + Request.Url.Authority + "//UploadFile//" + shortName); Response.End(); } else if (Request["actiontype"] == "SaveSpec") { int identityID = 0; try { ModelSpec ModelSpec = new ModelSpec(); if (String.IsNullOrEmpty(Request["Id"])) { ModelSpec.Class = Request["Class"]; ModelSpec.Bh = Request["Bh"]; ModelSpec.ProductName = Request["ProductName"]; ModelSpec.Spec = Request["Spec"]; ModelSpec.OrderNo = Request["OrderNo"]; ModelSpec.Size = Request["Size"]; ModelSpec.exterior = Request["exterior"]; ModelSpec.Color = Request["Color"]; ModelSpec.Remark = Request["Remark"]; identityID = servComm.Add(ModelSpec); } else { if (String.IsNullOrEmpty(Request["Bh"])) { identityID = servComm.ExecuteSql(" delete from Spec where ID in (" + Request["Id"] + ");"); } else { identityID = int.Parse(Request["Id"]); ModelSpec.Class = Request["Class"]; ModelSpec.Bh = Request["Bh"]; ModelSpec.ProductName = Request["ProductName"]; ModelSpec.Spec = Request["Spec"]; ModelSpec.OrderNo = Request["OrderNo"]; ModelSpec.Size = Request["Size"]; ModelSpec.exterior = Request["exterior"]; ModelSpec.Color = Request["Color"]; ModelSpec.Remark = Request["Remark"]; ModelSpec.ID = identityID; int result = servComm.Update(ModelSpec); } } DataCache.dict = servComm.GetListTop <ModelDictDetail>(0, null).ToList(); } catch (Exception ex) { Response.Write(0); Response.End(); } Response.Write(identityID); Response.End(); } }