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();
}
