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