private void BindData() { string bgh = Request.QueryString["bgh"] != null?HttpUtility.UrlDecode(Request.QueryString["bgh"], Encoding.GetEncoding("utf-8")) : ""; if (!string.IsNullOrEmpty(bgh)) { string status; DataTable dt = BaseADO.GetSdsmOne(bgh, out status); rptStatus.DataSource = dt; rptStatus.DataBind(); SetProcess(dt); litBgh.Text = bgh; litStatus.Text = status; } //int type = NumberTools.getInt(Request.QueryString["type"]); //if (type <= 0) //{ // type = 2; //} //if (type == 1) //{ // divProcess.Visible = true; // ordertrack.Visible = false; //} //else //{ // divProcess.Visible = false; // ordertrack.Visible = true; //} }
/// <summary> /// 登陆 返回users对象,并保存到session中 /// </summary> /// <param name="page"></param> /// <param name="userId"></param> /// <param name="userName"></param> /// <param name="password"></param> /// <param name="msg"></param> /// <returns>登陆失败返回null否则返回users对象,并保存到session中</returns> public static UserCopy Login(System.Web.UI.Page page, string userId, string password, out string msg) { try { string userName = ""; long result = BaseADO.UserVerify(userId, password, out userName, out msg); if (result > 0) { UserCopy usercopy = new UserCopy(); usercopy.UserId = userId; usercopy.UserName = userName; initEnv(page, usercopy); msg = "登陆成功"; return(usercopy); } else { if (StringTools.isBlank(msg)) { msg = "登陆失败!"; } return(null); } } catch (Exception ex) { msg = "数据库操作失败,请重试。如果问题仍然存在,请联系系统管理人员。谢谢!!!"; return(null); } }
void GetData() { DateTime fr = txtDateFr.Date; DateTime to = txtDateTo.Date.AddDays(1); // f< x < to string sql = string.Format(@"Select * from vDailyOrder where orderDate >='{0}' and OrderDate <'{1}'", fr.ToString("yyyy-MM-dd 00:00:00"), to.ToString("yyyy-MM-dd 00:00:00")); dt = BaseADO.GetData(sql); }
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { string bgh = e.CommandArgument.ToString(); string msg; bool execResult; try { //判断是否修改类别 if (e.CommandName == "Update") { TextBox tb = e.Item.FindControl("txtKHQRSM") as TextBox; execResult = BaseADO.Update_SDSMFWQ_KHSM(bgh, tb.Text.Trim(), out msg); if (execResult) { ScriptHelper.addMsg(this.Page, "更新成功"); SetBind(CurrentPageNumber); } else { ScriptHelper.addMsg(this.Page, "更新失败" + msg); } } else if (e.CommandName == "ConfirmReport") { execResult = BaseADO.UpdateReportStatus(bgh, 1, out msg); if (execResult) { ScriptHelper.addMsg(this.Page, msg); SetBind(CurrentPageNumber); } else { ScriptHelper.addMsg(this.Page, "更新状态失败" + msg); } } else if (e.CommandName == "CancelConfirm") { execResult = BaseADO.UpdateReportStatus(bgh, 0, out msg); if (execResult) { ScriptHelper.addMsg(this.Page, msg); SetBind(CurrentPageNumber); } else { ScriptHelper.addMsg(this.Page, "更新状态失败" + msg); } } } catch (Exception ex) { ScriptHelper.addMsg(this.Page, "更新状态失败,请稍后再试!" + ex.Message); LogHelper.log4netRec(ex, bgh + "执行" + e.CommandName + "失败"); } }
protected void btnUpdatePwd_Click(object sender, EventArgs e) { if (CurrentUser == null || CurrentUser.UserId == "") { LoginHelper.logout(this.Page); //回到登陆页面 Response.Write("<script language=JavaScript>parent.location.href=\"Login.aspx\";</script>"); return; } string strOldPassword = this.txtOldPassword.Text.Trim(); string strNewPassword = this.txtNewPassword.Text.Trim(); string strConfirmPassword = this.txtConfirmPassword.Text.Trim(); if (strOldPassword == "" || strNewPassword == "") { Response.Write("<script>alert('密码不能为空,请输入')</script>"); return; } if (strOldPassword == strNewPassword) { Response.Write("<script>alert('新密码不能与旧密码相同,请重新输入')</script>"); return; } if (strNewPassword != strConfirmPassword) { Response.Write("<script>alert('两次输入的密码不同,请重新输入确认密码')</script>"); return; } string msg; int intResult = BaseADO.UpdatePassword(CurrentUser.UserId, strOldPassword, strNewPassword, out msg); if (intResult == 1) { //回到首页面 Response.Write("<script>alert('恭喜您,密码修改成功!')</script>"); //Response.Write("<script language=JavaScript>parent.location.href=\"Login.aspx\";</script>"); return; } else { Response.Write("<script>alert('" + msg + "')</script>"); return; } }
private void BindData() { string bgh = Request.QueryString["bgh"] != null?HttpUtility.UrlDecode(Request.QueryString["bgh"], Encoding.GetEncoding("utf-8")) : ""; if (!string.IsNullOrEmpty(bgh)) { DataTable dt = BaseADO.GetSdsmReport(bgh); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; litCompanyName.Text = dr["公司名称"].ToString(); lblAmount1.Text = dr["营业收入1"].ToString(); lblAmount2.Text = dr["营业成本2"].ToString(); lblAmount3.Text = dr["营业税金及附加3"].ToString(); lblAmount4.Text = dr["销售费用4"].ToString(); lblAmount5.Text = dr["管理费用5"].ToString(); lblAmount6.Text = dr["财务费用6"].ToString(); lblAmount7.Text = dr["资产减值损失7"].ToString(); lblAmount8.Text = dr["公允价值变动收益8"].ToString(); lblAmount9.Text = dr["投资收益9"].ToString(); lblAmount10.Text = dr["营业利润10"].ToString(); lblAmount11.Text = dr["营业外收入11"].ToString(); lblAmount12.Text = dr["营业外支出12"].ToString(); lblAmount13.Text = dr["利润额13"].ToString(); lblAmount14.Text = dr["境外所得14"].ToString(); lblAmount15.Text = dr["调增利润15"].ToString(); lblAmount16.Text = dr["调减利润16"].ToString(); lblAmount17.Text = dr["免减收入加计扣17"].ToString(); lblAmount18.Text = dr["境外抵减亏损18"].ToString(); lblAmount19.Text = dr["调整后所得19"].ToString(); lblAmount20.Text = dr["所得减免20"].ToString(); lblAmount21.Text = dr["抵扣应纳税所得额21"].ToString(); lblAmount22.Text = dr["弥补以前年度亏损22"].ToString(); lblAmount23.Text = dr["应纳税所得额23"].ToString(); lblAmount24.Text = dr["税率24"].ToString(); lblAmount25.Text = dr["应纳税额25"].ToString(); lblAmount26.Text = dr["减免所得税额26"].ToString(); lblAmount27.Text = dr["抵免所得税额27"].ToString(); lblAmount28.Text = dr["应纳税额28"].ToString(); lblAmount29.Text = dr["境外应纳税额29"].ToString(); lblAmount30.Text = dr["境外抵免税额30"].ToString(); lblAmount31.Text = dr["实际应纳所得税额31"].ToString(); lblAmount32.Text = dr["已缴税32"].ToString(); lblAmount33.Text = dr["应补税33"].ToString(); } } }
/// <summary> /// 绑定Repeater /// </summary> private void SetBind(int pageNumber) { if (CurrentUser == null || CurrentUser.UserId == "") { LoginHelper.logout(this.Page); //回到登陆页面 Response.Write("<script language=JavaScript>parent.location.href=\"Login.aspx\";</script>"); return; } DataTable dtResutlt = BaseADO.GetSdsmAll(CurrentUser.UserId, txtCompanyName.Text.Trim(), ddlOrderBy.SelectedValue, ddlOrderDirection.SelectedValue, ddlStatus.SelectedValue); if (pageNumber <= 0) { pageNumber = 1; } RowCount = dtResutlt.Rows.Count; if (RowCount % PageSize > 0) { PageCount = RowCount / PageSize + 1; } else { PageCount = RowCount / PageSize; } CurrentPageNumber = pageNumber; if (CurrentPageNumber > PageCount) { CurrentPageNumber = PageCount; } lblMessage.Text = "当前第" + CurrentPageNumber + "/" + PageCount + "页"; litRecordsCount.Text = RowCount.ToString(); DataTable dtSource = SplitDataTable(dtResutlt, CurrentPageNumber, PageSize); rptList.DataSource = dtSource; rptList.DataBind(); hdfCurentPage.Value = CurrentPageNumber.ToString(); SetButton(); }