public void readerData() { DataTable dt = ReleaseDAL.Getzidongjiesuan(); if (dt.Rows.Count > 0) { string[] sj = dt.Rows[0]["jiesuantime"].ToString().Split(' '); TextBox5.Text = sj[0] + "-" + sj[1]; string[] fm = sj[1].Split(':'); DropDownList1.SelectedValue = fm[0]; DropDownList2.SelectedValue = fm[1].Replace("AM", ""); DropDownList3.SelectedValue = fm[2]; jszq.Text = dt.Rows[0]["jiesuanZQ"].ToString();//结算周期 if (dt.Rows[0]["isCNewQi"].ToString() == "1") { ClientScript.RegisterStartupScript(GetType(), "", "<script>window.onload=function(){setCk()};</script>"); } shijid.Text = dt.Rows[0]["jiesuantime"].ToString(); } CheckBox2.Checked = true; }
/// <summary> /// 审核补扣款 /// </summary> /// <param name="info">扣补款对象</param> public static bool UpdateInfoTran(DeductModel info) { using (SqlConnection conn = new SqlConnection(DBHelper.connString)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { if (DeductDAL.UpdateDeduct(info, tran) <= 0) { tran.Rollback(); return(false); } if (!ReleaseDAL.UpdateDeductOut(tran, info.Number, info.IsDeduct, info.DeductMoney)) { tran.Rollback(); return(false); } DirectionEnum de = DirectionEnum.AccountsIncreased; if (info.IsDeduct == 0) { de = DirectionEnum.AccountReduced; } string remark = ""; if (info.IsDeduct == 0) { remark = "008021~【" + info.Number + "】~000153~" + info.ExpectNum + "~008022"; D_AccountDAL.AddAccountWithdraw1(info.Number, info.DeductMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, D_AccountKmtype.AddMoneycut, de, remark, tran); } else { remark = "008021~【" + info.Number + "】~000153~" + info.ExpectNum + "~008023"; D_AccountDAL.AddAccountWithdraw1(info.Number, info.DeductMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, D_AccountKmtype.AddMoneyget, de, remark, tran); } tran.Commit(); return(true); } catch { tran.Rollback(); return(false); } finally { conn.Close(); conn.Dispose(); } } }
protected void Button3_Click(object sender, EventArgs e) { string rq = TextBox5.Text.Trim(); string hour = DropDownList1.SelectedValue; string min = DropDownList2.SelectedValue; string sec = DropDownList3.SelectedValue; int isjs = 0; if (Textbox4.Text == "y") { isjs = 1; //结算时创建新一期选中 } if (DateTime.Compare(Convert.ToDateTime(rq + " " + hour + ":" + min + ":" + sec), DateTime.Now) < 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007128", "选择日期不能小于当前时间!") + "');</script>"); return; } string zqts = jszq.Text.Trim(); try { Convert.ToInt32(zqts); } catch { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('自动结算周期只能为整数!');</script>"); return; } if (Convert.ToInt32(zqts) < 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('自动结算周期不能为负数!');</script>"); return; } int a = ReleaseDAL.UpdJiesuantime(rq + " " + hour + ":" + min + ":" + sec, isjs, zqts); if (a == 1) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('设置成功!');window.location.href=window.location.href</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('设置失败!');</script>"); } }
protected void Page_Load(object sender, EventArgs e) { Permissions.ComRedirect(Page, Permissions.redirUrl); Permissions.CheckManagePermission(EnumCompanyPermission.FinanceJiesuan); //检查相应权限 this.addNewQishu.Attributes["onclick"] = "return confirm('" + GetTran("001139", "确认要创建新一期吗?") + "')"; AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxClass)); Translations(); if (!IsPostBack) { int MaxQs = ReleaseBLL.GetMaxExpectNum(); if (MaxQs <= 10) { this.TextBox1.Text = "1";//结算起始期 this.TextBox2.Text = Convert.ToString(MaxQs); } else { this.TextBox1.Text = Convert.ToString(MaxQs - 10); this.TextBox2.Text = Convert.ToString(MaxQs); } this.Label1.Text = "(" + GetTran("001140", "当前期数为") + "<font color=red>" + MaxQs.ToString() + "</font>," + GetTran("001141", "请输入") + "1-" + MaxQs.ToString() + GetTran("001142", "范围内的整数") + ")"; this.showTotalQishuLink1(); //自动结算是否启用 if (ReleaseDAL.GetzidongjsQy() == "1") { readerData(); } else { TextBox5.Enabled = false; //结算周期文本框 DropDownList1.Enabled = false; //时 下拉框 DropDownList2.Enabled = false; DropDownList3.Enabled = false; Button3.Enabled = false; jszq.Enabled = false; ClientScript.RegisterStartupScript(GetType(), "", "<script>enabledCK();</script>"); } } Translations(); nowtimeid.Text = DateTime.Now.ToString(); }
protected void CheckBox2_CheckedChanged(object sender, EventArgs e) { string isqy = "0"; if (CheckBox2.Checked) { isqy = "1"; } //设置自动结算是否启用 if (ReleaseDAL.UpdJiesuanQy(isqy) == 1) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('设置成功!');window.location.href=window.location.href;</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('设置失败!');window.location.href=window.location.href;</script>"); } }
/// <summary> /// 审核补扣款 /// </summary> /// <param name="info">扣补款对象</param> public static bool UpdateInfoTranBD(DeductModel info) { using (SqlConnection conn = new SqlConnection(DBHelper.connString)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { if (DeductDAL.UpdateDeduct(info, tran) <= 0) { tran.Rollback(); return(false); } if (!ReleaseDAL.UpdateDeductOutBD(tran, info.Number, info.IsDeduct, info.Actype, info.DeductMoney)) { tran.Rollback(); return(false); } DirectionEnum de = DirectionEnum.AccountReduced; D_AccountKmtype km = D_AccountKmtype.AddMoneycut; string remark = "管理员协助扣款" + info.DeductMoney.ToString(); if (info.IsDeduct == 1) { de = DirectionEnum.AccountsIncreased; km = D_AccountKmtype.AddMoneyget; remark = "管理员协助补款" + info.DeductMoney.ToString(); } D_AccountDAL.AddAccountWithdraw1(info.Number, info.DeductMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, km, de, remark, tran); tran.Commit(); return(true); } catch { tran.Rollback(); return(false); } finally { conn.Close(); conn.Dispose(); } } }
/// <summary> /// 获取系统开关的对应列表到临时表##setsys /// </summary> /// <returns></returns> public static bool GetSystemList() { return(ReleaseDAL.GetSystemList()); }
/// <summary> /// 奖金撤销,不是当期最大期 --ds2012--www-b874dce8700——tianfeng /// </summary> /// <returns></returns> public static int Cancel(int ExpectNum) { return(ReleaseDAL.Cancel(ExpectNum)); }
/// <summary> /// 判断是否是当前最大期 --ds2012--www-b874dce8700——tianfeng /// </summary> /// <param name="ExpectNum">期数</param> /// <returns></returns> public static int IsCurrently(int ExpectNum) { return(ReleaseDAL.IsCurrently(ExpectNum)); }
/// <summary> /// 根据店铺编号获取店长编号 /// </summary> /// <param name="StoreID">店铺编号</param> /// <returns></returns> public static string GetNumberByStoreID(string StoreID) { return(ReleaseDAL.GetNumberByStoreID(StoreID)); }
/// <summary> /// //根据编号、期数读取结算表信息 /// </summary> /// <param name="ExpectNum">期数</param> /// <param name="Number">编号</param> /// <returns></returns> public static DataTable GetMemberInfoBalanceByNumber(int ExpectNum, string Number) { return(ReleaseDAL.GetMemberInfoBalanceByNumber(ExpectNum, Number)); }
/// <summary> /// 获取账户信息 /// </summary> /// <param name="money">电子钱包金额</param> /// <param name="bank">所在银行</param> /// <returns></returns> public static DataTable GetMemberInfo(double money, string bank, string bankCountry) { return(ReleaseDAL.GetMemberInfo(money, bank, bankCountry)); }
/// <summary> /// 根据电子钱包金额查询用户信息——ds2012——tianfeng /// </summary> /// <param name="money">金额</param> /// <returns></returns> public static DataTable GetMemberInfoByMoney(double money) { return(ReleaseDAL.GetMemberInfoByMoney(money)); }
/// <summary> /// 判断是否有未结算的 /// </summary> /// <param name="ExpectNum"></param> /// <returns></returns> public static bool GetIsExistsConfig(int ExpectNum) { return(ReleaseDAL.GetIsExistsConfig(ExpectNum)); }
/// <summary> /// 删除工资退回 /// update ChongHong set isdele=1,deleteDate='2009-8-30 10:03:03' WHERE id=12 /// update H_info set zongji=zongji-100.00,ectzongji=ectzongji-100.00 where bianhao='a00001' /// </summary> /// <returns></returns> public static Boolean DelChongHong(int ID, double money, string MemeberNum) { return(ReleaseDAL.DelChongHong(ID, money, MemeberNum)); }
/// <summary> /// 添加转账记录 /// </summary> /// <param name="info"></param> public static bool AddTransfer(SqlTransaction tran, MoneyTransferModel info, out int outid) { return(ReleaseDAL.AddTransfer(tran, info, out outid)); }
/// <summary> /// 添加转账记录 /// </summary> /// <param name="info"></param> public static void AddTransfer(MoneyTransferModel info, out int outid) { ReleaseDAL.AddTransfer(info, out outid); }
public static double GetMemberDeclarations(string number, SqlTransaction tran) { return(ReleaseDAL.GetMemberDeclarations(number, tran)); }
/// <summary> /// 根据期数查询是否已发布——ds2012——tianfeng /// </summary> /// <param name="ExpectNum">期数</param> /// <returns></returns> public static int GetOutBonus(int ExpectNum) { return(ReleaseDAL.GetOutBonus(ExpectNum)); }
/// <summary> /// 获得该会员的奖金,报单账户 /// </summary> /// <param name="number">会员编号</param> /// <returns></returns> public static double GetMemberDeclarations(string number) { return(ReleaseDAL.GetMemberDeclarations(number)); }
/// <summary> /// 添加“工资退回” /// update h_info set zongji=zongji+100,ectzongji=ectzongji+100 where bianhao='a00001' /// insert into chonghong (bianhao,qishu,jine,beizhu,isdele) values ('a00001',2,100,'给你发钱了 你高兴了吧',0) /// </summary> /// <returns></returns> public static Boolean AddChongHong(ChongHongModel chonghong) { return(ReleaseDAL.AddChongHong(chonghong)); }
/// <summary> /// 还原原有系统开关--CK /// </summary> /// <param name="list">原有系统列表</param> /// <param name="tran"></param> /// <returns></returns> public static bool UpdateSystemID() { return(ReleaseDAL.UpdateSystemID()); }
/// <summary> /// 发放奖金——ds2012——tianfeng /// </summary> /// <param name="ExpectNum">期数</param> /// <param name="money">金额</param> /// <param name="bank">银行</param> /// <returns></returns> public static Boolean UpMemberInfo(int ExpectNum, double money, string grant, string ip, string operaternum) { return(ReleaseDAL.UpMemberInfo(ExpectNum, money, grant, ip, operaternum)); }
/// <summary> /// 验证是否删除系统开关临时表##setsys /// </summary> /// <returns></returns> public static bool CheckSetsys() { return(ReleaseDAL.CheckSetsys()); }
/// <summary> /// 判断当前是否有已结算的工资 /// </summary> /// <returns></returns> public static int GetMaxExpectNumByIsSuance() { return(ReleaseDAL.GetMaxExpectNumByIsSuance()); }
/// <summary> /// 删除系统开关临时表##setsys--CK /// </summary> /// <returns></returns> public static bool DelSetsys() { return(ReleaseDAL.DelSetsys()); }
/// <summary> /// 根据会员编号获取会员姓名 /// </summary> /// <param name="Number">编号</param> /// <returns></returns> public static string GetNameByPlacement(string Number) { return(ReleaseDAL.GetNameByPlacement(Number)); }
/// <summary> /// 奖金是否发布——ds2012——tianfeng /// </summary> /// <param name="ExpectNum">期数</param> /// <param name="num">1.发布0.不发布</param> /// <returns></returns> public static int Release(int ExpectNum, int num) { return(ReleaseDAL.Release(ExpectNum, num)); }
public static int IsSuanceJj(int ExpectNum) { return(ReleaseDAL.ISSuanceJj(ExpectNum)); }
/// <summary> /// 撤销发放奖金 --ds2012--www-b874dce8700——tianfeng /// </summary> /// <param name="ExpectNum">期数</param> public static int Revert(int ExpectNum) { return(ReleaseDAL.Revert(ExpectNum)); }