private void Bind(string orderid)
{
DataSet dt = fmrz.GetList(" ga_occuid in ('" + orderid + "') and ga_Type in(4,6,7)");
foreach (DataRow dr in dt.Tables[0].Rows)
{
if (dr["ga_Type"].ToString() == "0")
{
dr["ga_remker"] = "消费（商品入账）";
}
if (dr["ga_Type"].ToString() == "1")
{
dr["ga_remker"] = "消费（费用入账）" + "," + dr["ga_remker"].ToString();
}
if (dr["ga_Type"].ToString() == "3")
{
dr["ga_remker"] = "续住押金";
}
if (dr["ga_Type"].ToString() == "4")
{
dr["ga_remker"] = "结账（入账）";
}
if (dr["ga_Type"].ToString() == "5")
{
dr["ga_remker"] = "退款（入账）";
}
}
if (dt.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dt.Tables[0].Rows)
{
sbtext.Append("<tr><td><input type=\"radio\" name=\"radi\"></td><td>" + dr["ga_roomNumber"].ToString() + "</td><td class='sk'>" + Convert.ToDecimal(dr["ga_price"]).ToString("0.##") + "</td><td>" + GetKffsName(dr["ga_zffs_id"].ToString()) + "</td><td>" + GetUserName(dr["ga_people"].ToString()) + "</td><td class=\"tddate\">" + dr["ga_date"] + "</td><td>" + dr["ga_remker"] + "</td></tr>");
}
}
}
/// <summary>
/// 绑定入账信息
/// </summary>
public void BindGv()
{
int count = 0;
double Money = 0;
double ysMoney = 0;
DataSet dt = fmrz.GetList(" ga_occuid in ('" + orderid + "')");
foreach (DataRow dr in dt.Tables[0].Rows)
{
if (dr["ga_Type"].ToString() == "0")
{
dr["ga_remker"] = "消费（商品入账）";
}
if (dr["ga_Type"].ToString() == "1")
{
dr["ga_remker"] = "消费（费用入账）" + "," + dr["ga_remker"].ToString();
}
if (dr["ga_Type"].ToString() == "3")
{
dr["ga_remker"] = "续住押金";
}
if (dr["ga_Type"].ToString() == "4")
{
dr["ga_remker"] = "结账（入账）";
}
if (dr["ga_Type"].ToString() == "5")
{
dr["ga_remker"] = "退款（入账）";
}
try
{
Money += double.Parse(dr["ga_price"].ToString());
ysMoney += double.Parse(dr["ga_sum_price"].ToString());
}
catch { }
count++;
}
txt_xfMoneys.Value = txt_xfMoney.Value = ysMoney.ToString();
txt_ysMoneys.Value = txt_ysMoney.Value = Money.ToString();
txt_bcysMoneys.Value = txt_bcysMoney.Value = (double.Parse(txt_xfMoney.Value) - double.Parse(txt_ysMoney.Value)).ToString();
GridView1.DataSource = dt;
GridView1.DataBind();
}
/// <summary>
/// 绑定入账信息
/// </summary>
public string BindGv(string orderid)
{
double Money = 0;
double ysMoney = 0;
DataSet dt = bllga.GetList(" ga_occuid in ('" + orderid + "')");
foreach (DataRow dr in dt.Tables[0].Rows)
{
try
{
Money += double.Parse(dr["ga_price"].ToString());
ysMoney += double.Parse(dr["ga_sum_price"].ToString());
}
catch { }
}
string st = (Money - ysMoney).ToString();
return("<td>" + ysMoney + "</td><td>" + Money + "</td><td>" + st + "</td>");
}
public void Bind()
{
Model.occu_infor mod = new Model.occu_infor();
labfh.Text = fmrzInfo.GetModel(ids).room_number;
labfx.Text = GetRealTypeName((fmrzInfo.GetModel(ids).real_type_id));
labkffs.Text = GetKffsName(fmrzInfo.GetModel(ids).real_mode_id);
lably.Text = GetLYName(fmrzInfo.GetModel(ids).source_id);
labname.Text = fmrzInfo.GetModel(ids).occ_name.ToString();
labrzDate.Text = fmrzInfo.GetModel(ids).occ_time.ToString();
labfjMoney.Text = fmrzInfo.GetModel(ids).real_price.ToString();
labSymoney.Text = fmrzInfo.GetModel(ids).amount_money.ToString();
double ysMoney = 0;
DataSet dt = fmgoodvount.GetList(" ga_occuid in ('" + fmrzInfo.GetModel(ids).order_id + "')");
foreach (DataRow dr in dt.Tables[0].Rows)
{
try
{
ysMoney += double.Parse(dr["ga_sum_price"].ToString());
}
catch { }
}
labSymoney.Text = ysMoney.ToString();
}
private void BindDG3()
{
GridView3.DataSource = gaBll.GetList("ga_zffs_id=10 and ga_isjz=0");
GridView3.DataBind();
}
private void GetGoods()
{
int readValue = Convert.ToInt32(context.Request.QueryString["readValue"]);
string room = context.Request.QueryString["room"];
string whereids = string.Empty;
if (context.Request.QueryString["whereids"] != null)
{
whereids = context.Request.QueryString["whereids"].ToString();
}
System.Text.StringBuilder sbtext = new System.Text.StringBuilder();
string orderid = string.Empty;
if (context.Request.QueryString["orderid"] != null)
{
orderid = context.Request.QueryString["orderid"];
}
string where = "";
if (readValue == 2)
{
where = " and ga_Type in(0,1,9,10,101,11,8)";
}
else if (readValue == 1)
{
where = " and ga_Type in(4,5,6,7)";
}
else if (readValue == 3)
{
where = " and ga_Type in(12)";
}
if (room != "0")
{
where += " and ga_roomNumber='" + room + "'";
}
if (whereids != "")
{
where += " and ID not in(" + whereids + ")";
}
double Money = 0;
double ysMoney = 0;
//if (blloc.GetModelList("order_id='" + orderid + "' and state_id=3").Count <= 0)
//{
DataSet dt = fmrz.GetList(" ga_occuid in ('" + orderid + "') " + where + "");
foreach (DataRow dr in dt.Tables[0].Rows)
{
if (dr["ga_Type"].ToString() == "0")
{
dr["ga_remker"] = "消费（商品入账）";
}
if (dr["ga_Type"].ToString() == "1")
{
dr["ga_remker"] = "消费（费用入账）" + "," + dr["ga_remker"].ToString();
}
if (dr["ga_Type"].ToString() == "3")
{
dr["ga_remker"] = "续住押金";
}
if (dr["ga_Type"].ToString() == "4")
{
dr["ga_remker"] = "结账（入账）";
}
if (dr["ga_Type"].ToString() == "5")
{
dr["ga_remker"] = "退款（入账）";
}
try
{
Money += double.Parse(dr["ga_price"].ToString());
ysMoney += double.Parse(dr["ga_sum_price"].ToString());
}
catch { }
}
if (dt.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dt.Tables[0].Rows)
{
sbtext.Append("<tr><td>" + dr["ga_roomNumber"].ToString() + "</td><td>" + dr["ga_name"].ToString() + "</td><td>" + dr["ga_price"].ToString() + "</td><td>" + dr["ga_sum_price"] + "</td><td>" + GetKffsName(dr["ga_zffs_id"].ToString()) + "</td><td>" + GetUserName(dr["ga_people"].ToString()) + "</td><td class=\"tddate\">" + dr["ga_date"] + "</td><td class=\"tdreamk\">" + GetStr(dr["ga_remker"].ToString(), dr["id"].ToString()) + "</td><td>" + GetInp(dr) + "</td></tr>");
}
}
context.Response.Write("" + Money + "&" + sbtext.ToString() + "&" + ysMoney + "");
context.Response.End();
// }
//else {
// context.Response.Write("err");
// context.Response.End();
//}
//JavaScriptSerializer js=new JavaScriptSerializer();
//string str = js.Serialize(dt.Tables[0]);
//Common.AjaxMsgHelper.AjaxMsg(@sbtext.ToString(), Money.ToString());
//txt_xfMoneys.Value = txt_xfMoney.Value = ysMoney.ToString();
//txt_ysMoneys.Value = txt_ysMoney.Value = Money.ToString();
//txt_bcysMoneys.Value = txt_bcysMoney.Value = (double.Parse(txt_xfMoney.Value) - double.Parse(txt_ysMoney.Value)).ToString();
}
