private void of_bind()
{
List <GysoftParameter> ll_Pa = new List <GysoftParameter>();
string strSql = "select backmoneyrecord.recordno,backmoneyrecord.insdate,backmoneyrecord.chalked," +
"customer.cus_name,backmoneyrecord.money,backmoneyrecord.bank,backmoneyrecord.bankmoneyno,backmoneyrecord.memo " +
"from backmoneyrecord,customer " +
"where backmoneyrecord.cus_code=customer.cus_code " +
" and customer.cus_code =@cus_code ";
GysoftParameter Pa1 = new GysoftParameter("@cus_code", as_CusCode);
ll_Pa.Add(Pa1);
if (DDL_chalked.SelectedValue != "")
{
if (DDL_chalked.SelectedValue == "Y")
{
strSql += " and chalked='Y' ";
}
else
{
strSql += " and (chalked='n' or chalked is null) ";
}
}
#region 汇款单查询最小日期限制
DateTime ld_BackMoneyBeginDate = DateTime.MinValue;
try
{
string ls_BackMoneyBeginDate = publicfuns.of_GetMySysSet("商城参数" + WebSet.os_WebHost, "BackMoneyBeginDate");
if (ls_BackMoneyBeginDate != "")
{
int li_BackMoneyBeginDate = Convert.ToInt32(ls_BackMoneyBeginDate);
if (li_BackMoneyBeginDate > 0)
{
Lbl_DateMessage.Text = "只能查询 " + li_BackMoneyBeginDate + "天前的汇款单";
ld_BackMoneyBeginDate = DateTime.Now.AddDays(0 - li_BackMoneyBeginDate);
}
}
}
catch { }
if (Txt_TimeBegin.Text.Trim() == "")
{
if (ld_BackMoneyBeginDate <= DateTime.Now.AddMonths(-3))
{
ld_BackMoneyBeginDate = DateTime.Now.AddMonths(-3);
}
Txt_TimeBegin.Text = ld_BackMoneyBeginDate.ToString("yyyy-MM-dd");
}
else
{
try
{
DateTime ld_Time = Convert.ToDateTime(Txt_TimeBegin.Text.Trim());
if (ld_Time >= ld_BackMoneyBeginDate)
{
ld_BackMoneyBeginDate = ld_Time;
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
return;
}
}
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
return;
}
}
strSql += " and backmoneyrecord.insdate>=@TimeBegin ";
ll_Pa.Add(new GysoftParameter("@TimeBegin", ld_BackMoneyBeginDate));
#endregion
if (Txt_TimeEnd.Text.Trim() != "")
{
strSql += " and backmoneyrecord.insdate<@TimeEnd ";
GysoftParameter Pa = new GysoftParameter("@TimeEnd", Txt_TimeEnd.Text);
ll_Pa.Add(Pa);
}
strSql += " order by insdate desc ";
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, strSql, GysoftParameter.ChangeParameter(ll_Pa));
GV_MoneyRecord.DataSource = dt;
GV_MoneyRecord.DataBind();
}
private void of_bindGetmain()
{
int li_PageIndex = 1;
try { li_PageIndex = Convert.ToInt32(Lbl_PageIndex.Text); }
catch { }
PageInfo Page = new PageInfo();
Page.IPage = li_PageIndex;
Page.IPageSize = gi_PageSize;
Page.StrIndex = "getmain.orderno";
Page.StrOrder = "getmain.getorderdate desc";
Page.StrTable = "getmain,(select orderno,sum(num*price) as totalmoney from getdetail group by orderno) as getdetail";
Page.StrText = "getmain.orderno,getorderdate,isorder,orderstatus," +
"getdetail.totalmoney,memo,checkman, " +
"(select settle from settlekind where settlekind.settlekind=getmain.settlekind) as settle ";
Page.StrWhere = "and getmain.orderno =getdetail.orderno " +
"and ( isnull(getmain.islogout,'n')='n') " +
"and getmain.cus_code=@cus_code " +
"and totalmoney is not null";
List <GysoftParameter> ll_Pa = new List <GysoftParameter>();
GysoftParameter Pa1 = new GysoftParameter("@cus_code", as_Cus_Code);
ll_Pa.Add(Pa1);
#region 订单查询最小日期限制
//DateTime ld_OrderBeginDate = DateTime.MinValue;
//try
//{
// string ls_OrderBeginDate = publicfuns.of_GetMySysSet("商城参数" + WebSet.os_WebHost, "OrderBeginDate");
// if (ls_OrderBeginDate != "")
// {
// int li_OrderBeginDate = Convert.ToInt32(ls_OrderBeginDate);
// if (li_OrderBeginDate > 0)
// {
// Lbl_DateMessage.Text = "只能查询 " + li_OrderBeginDate + "天前的订单";
// ld_OrderBeginDate = DateTime.Now.AddDays(0 - li_OrderBeginDate);
// }
// }
//}
//catch { }
//if (Txt_TimeBegin.Text.Trim() == "")
//{
// if (ld_OrderBeginDate <= DateTime.Now.AddMonths(-3))
// {
// ld_OrderBeginDate = DateTime.Now.AddMonths(-3);
// }
// Txt_TimeBegin.Text = ld_OrderBeginDate.ToString("yyyy-MM-dd");
//}
//else
//{
// try
// {
// DateTime ld_Time = Convert.ToDateTime(Txt_TimeBegin.Text.Trim());
// if (ld_Time >= ld_OrderBeginDate)
// { ld_OrderBeginDate = ld_Time; }
// else
// {
// ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
// return;
// }
// }
// catch
// {
// ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
// return;
// }
//}
//Page.StrWhere += " and getorderdate>=@begionTime ";
//ll_Pa.Add(new GysoftParameter("@begionTime", ld_OrderBeginDate));
#endregion
if (Txt_TimeBegin.Text.Trim() != "")
{
DateTime ld_TimeEnd;
try
{ ld_TimeEnd = Convert.ToDateTime(Txt_TimeBegin.Text.Trim()); }
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
return;
}
Page.StrWhere += " and getorderdate>=@begionTime ";
GysoftParameter Pa = new GysoftParameter("@begionTime", ld_TimeEnd);
ll_Pa.Add(Pa);
}
if (Txt_TimeEnd.Text.Trim() != "")
{
DateTime ld_TimeEnd;
try
{ ld_TimeEnd = Convert.ToDateTime(Txt_TimeEnd.Text.Trim()); }
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的结束时间')", true);
return;
}
Page.StrWhere += " and getorderdate<@TimeEnd ";
GysoftParameter Pa = new GysoftParameter("@TimeEnd", ld_TimeEnd);
ll_Pa.Add(Pa);
}
int Count = 0;
DataTable dt = PageDAL.Page(Page, GysoftParameter.ChangeParameter(ll_Pa), out Count);
if (Count % gi_PageSize != 0)
{
Lbl_PageCount.Text = ((Count / gi_PageSize) + 1).ToString();
}
else
{
Lbl_PageCount.Text = (Count / gi_PageSize).ToString();
}
GV_Getmain.DataSource = dt;
GV_Getmain.DataBind();
}
private void of_Bind()
{
string ls_AccNo = SqlHelper.ExecuteScalar("select top 1 dbo.fun_GetCustomerAccno('" + as_CusCode + "','00')");
List <GysoftParameter> ll_Pa = new List <GysoftParameter>();
string strSql = @"select makedate, chalkword as chalkwo, wordorder, memo,otheroneaccno, settleno,
loan ,credit , 'y' as lastloan , 0.00 as lastmoney ,otheraccno,c.chalkid,
c.inputdate,c.ischarge,c.chalkrec,c.detailtype, ' ' as ismore,
c.chalkid ,' ' as lastloanname , c.chalkword, s.accname , ' ' as ismore,dbo.uf_getuserid() as userid
from vw_chalk as c ,accsubject as s
where c.accno=s.accno ";
strSql += " and (s.accno=@accno) ";
ll_Pa.Add(new GysoftParameter("@accno", ls_AccNo));
#region 汇款单查询最小日期限制
DateTime ld_AccBookBeginDate = DateTime.MinValue;
try
{
string ls_AccBookBeginDate = publicfuns.of_GetMySysSet("商城参数" + WebSet.os_WebHost, "AccBookBeginDate");
if (ls_AccBookBeginDate != "")
{
int li_AccBookBeginDate = Convert.ToInt32(ls_AccBookBeginDate);
if (li_AccBookBeginDate > 0)
{
Lbl_DateMessage.Text = "只能查询 " + li_AccBookBeginDate + "天前的对账单";
ld_AccBookBeginDate = DateTime.Now.AddDays(0 - li_AccBookBeginDate);
}
}
}
catch { }
if (Txt_TimeBegin.Text.Trim() == "")
{
if (ld_AccBookBeginDate <= DateTime.Now.AddMonths(-3))
{
ld_AccBookBeginDate = DateTime.Now.AddMonths(-3);
}
Txt_TimeBegin.Text = ld_AccBookBeginDate.ToString("yyyy-MM-dd");
}
else
{
try
{
DateTime ld_Time = Convert.ToDateTime(Txt_TimeBegin.Text.Trim());
if (ld_Time >= ld_AccBookBeginDate)
{
ld_AccBookBeginDate = ld_Time;
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
return;
}
}
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
return;
}
}
strSql += " and makedate>=@TimeBegin ";
ll_Pa.Add(new GysoftParameter("@TimeBegin", ld_AccBookBeginDate));
#endregion
if (Txt_TimeEnd.Text.Trim() != "")
{
DateTime ld_TimeEnd;
try
{ ld_TimeEnd = Convert.ToDateTime(Txt_TimeEnd.Text.Trim()); }
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的结束时间')", true);
return;
}
strSql += " and makedate<@TimeEnd ";
GysoftParameter Pa = new GysoftParameter("@TimeEnd", ld_TimeEnd);
ll_Pa.Add(Pa);
}
strSql += " order by makedate ";
DataTable ldt_AccBook = new DataTable();
ldt_AccBook = SqlHelper.ExecuteDataTable(strSql, GysoftParameter.ChangeParameter(ll_Pa));
Decimal lde_lastmoney_Begin = of_GetCustomerFirstMoney(ls_AccNo, ld_AccBookBeginDate);
Decimal lde_lastmoney = lde_lastmoney_Begin;
for (int li_rows = 0; li_rows < ldt_AccBook.Rows.Count; li_rows++)
{
if (ldt_AccBook.Rows[li_rows]["Loan"].ToString() != "")
{
lde_lastmoney -= Convert.ToDecimal(ldt_AccBook.Rows[li_rows]["Loan"]);
}
if (ldt_AccBook.Rows[li_rows]["credit"].ToString() != "")
{
lde_lastmoney += Convert.ToDecimal(ldt_AccBook.Rows[li_rows]["credit"]);
}
ldt_AccBook.Rows[li_rows]["lastmoney"] = lde_lastmoney;
}
string ls_View = "";
ls_View = publicfuns.of_GetMySysSet("weixin", "结转上期");
if (ls_View == "Y")
{
DataRow dr = ldt_AccBook.NewRow();
dr["memo"] = "(结转上期)";
dr["lastmoney"] = lde_lastmoney_Begin;
ldt_AccBook.Rows.InsertAt(dr, 0);
}
GV_AccBook.DataSource = ldt_AccBook;
GV_AccBook.DataBind();
}
private void of_bindOutOne()
{
int li_PageIndex = 1;
try { li_PageIndex = Convert.ToInt32(Lbl_PageIndex.Text); }
catch { }
PageInfo Page = new PageInfo();
Page.IPage = li_PageIndex;
Page.IPageSize = gi_PageSize;
Page.StrIndex = "outone.out_no";
Page.StrOrder = "outone.out_date desc";
Page.StrTable = "outone,customer,outtraffic";
Page.StrText = "outone.out_no,outone.out_date,outone.human," +
"outone.remark,outone.haveout,outone.discountrate,outone.haveoutstock," +
"outone.saleman,outone.haveoutstock,outone.stockcode,outone.settlekind," +
"isnull(outtraffic.trafficmemo,'')+isnull(outtraffic.address,'') as trafficmemo," +
"outone.trafficno,outone.sendNO,outone.driverman,outone.driverdate";
Page.StrWhere = "and outone.cus_code = customer.cus_code " +
"and outone.out_no=outtraffic.out_no " +
"and outone.cus_code=@cus_code";
List <GysoftParameter> ll_Pa = new List <GysoftParameter>();
GysoftParameter Pa1 = new GysoftParameter("@cus_code", as_Cus_code);
ll_Pa.Add(Pa1);
DateTime ld_TimeBegin = Convert.ToDateTime("1900-01-01");
if (Txt_TimeBegin.Text.Trim() != "")
{
try
{ ld_TimeBegin = Convert.ToDateTime(Txt_TimeBegin.Text.Trim()); }
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的开始时间')", true);
return;
}
Page.StrWhere += " and outone.out_date>=@TimeBegin ";
GysoftParameter Pa = new GysoftParameter("@TimeBegin", ld_TimeBegin);
ll_Pa.Add(Pa);
}
if (Txt_TimeEnd.Text.Trim() != "")
{
DateTime ld_TimeEnd;
try
{ ld_TimeEnd = Convert.ToDateTime(Txt_TimeEnd.Text.Trim()); }
catch
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('请输入正确的结束时间')", true);
return;
}
Page.StrWhere += " and outone.out_date<@TimeEnd ";
GysoftParameter Pa = new GysoftParameter("@TimeEnd", ld_TimeEnd);
ll_Pa.Add(Pa);
}
int Count = 0;
DataTable dt = PageDAL.Page(Page, GysoftParameter.ChangeParameter(ll_Pa), out Count);
if (Count % gi_PageSize != 0)
{
Lbl_PageCount.Text = ((Count / gi_PageSize) + 1).ToString();
}
else
{
Lbl_PageCount.Text = (Count / gi_PageSize).ToString();
}
GV_OutOne.DataSource = dt;
GV_OutOne.DataBind();
}
