//根据单号查询信息 目的应该是为了补打票据
public List <LiShiConsumption> SelectForDanNumber(string dannumber)
{
List <LiShiConsumption> list = new List <LiShiConsumption>();
if (ID == null)
{
return(list);
}
LiShiConsumption model;
//string name = FilterClass.DianPu1.UserName;
SqlParameter[] pms;
string str = "select * from LSConsumption" + ID + " where LSDanNumber=@LSDanNumber";
pms = new SqlParameter[] {
new SqlParameter("@LSDanNumber", dannumber)
};
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new LiShiConsumption();
model.LSName = read["LSName"].ToString().Trim();
model.LSDate = read["LSDate"].ToString().Trim();
model.LSStaff = read["LSStaff"].ToString().Trim();
model.LSNumberCount = read["LSNumberCount"].ToString().Trim();
model.LSMoney = read["LSMoney"].ToString().Trim();
model.LSYMoney = read["LSYMoney"].ToString().Trim();
model.LSCount = read["LSCount"].ToString().Trim();
model.LSPinPai = read["LSPinPai"].ToString().Trim();
model.LSColor = read["LSColor"].ToString().Trim();
model.LSSalesman = read["LSSalesman"].ToString().Trim();
model.LSMultipleName = read["LSMultipleName"].ToString().Trim();
model.LSQuestion = read["LSQuestion"].ToString().Trim();
model.LSRemark = read["LSRemark"].ToString().Trim();
model.LSDanNumber = read["LSDanNumber"].ToString().Trim();
model.LSCardNumber = read["LSCardNumber"].ToString().Trim();
model.ImgUrl = read["ImgUrl"].ToString().Trim();
model.ID = Convert.ToInt32(read["ID"]);
model.IsSP = Convert.ToBoolean(read["IsSP"]);
model.IsJC = Convert.ToBoolean(read["IsJC"]);
model.IsXMoney = Convert.ToBoolean(read["IsXMoney"]);
list.Add(model);
}
}
return(list);
}
//还要统计，在收活处，点了付款之后的当时就付了先进的应付金额（收入统计处的一部分）
public List <LiShiConsumption> selectTJMoney(string begindate, string enddate, string yginfo, string dpname)
{
int i = 1;
List <LiShiConsumption> list = new List <LiShiConsumption>();
LiShiConsumption model;
//SqlParameter[] pms;
string str = "";
if (FilterClass.DianPu1.UserName.Trim() == "admin")
{
if (yginfo.Trim() == "全部")
{
if (dpname == "全部")
{
foreach (KeyValuePair <string, int> iteam in FilterClass.dic)
{
str += "select * from ";
str += "LSConsumption" + iteam.Value + "";
str += " where LSDate between '" + begindate + "' and '" + enddate + "' and IsXMoney='true' and FUKUAN='true'";
str += " union all ";
}
str = str.Substring(0, str.Length - 10);
}
else
{
int id = FilterClass.dic[dpname];
str = "select * from LSConsumption" + id + " where and IsXMoney='true' and FUKUAN='true' and LSDate between '" + begindate + "' and '" + enddate + "'";
}
}
else
{
if (dpname == "全部")
{
foreach (KeyValuePair <string, int> iteam in FilterClass.dic)
{
str += "select * from ";
str += "LSConsumption" + iteam.Value + "";
str += " where LSDate between '" + begindate + "' and '" + enddate + "' and IsXMoney='true' and FUKUAN='true' and LSSalesman='" + yginfo.Trim() + "'";
str += " union all ";
}
str = str.Substring(0, str.Length - 10);
}
else
{
int id = FilterClass.dic[dpname];
str = "select * from LSConsumption" + id + " where and IsXMoney='true' and FUKUAN='true' and LSDate between '" + begindate + "' and '" + enddate + "' and LSSalesman='" + yginfo.Trim() + "'";
}
}
}
else
{
if (yginfo.Trim() == "全部")
{
str = "select * from LSConsumption" + ID + " where IsXMoney='true' and FUKUAN='true' and LSDate between '" + begindate + "' and '" + enddate + "'";
}
else
{
str = "select * from LSConsumption" + ID + " where and LSSalesman='" + yginfo.Trim() + "' and IsXMoney='true' and FUKUAN='true' and LSDate between '" + begindate + "' and '" + enddate + "'";
}
}
SqlDataReader read = SqlHelper.ExecuteReader(str);
while (read.Read())
{
if (read.HasRows)
{
model = new LiShiConsumption();
model.LSNo = i.ToString();
model.LSName = read["LSName"].ToString().Trim();
model.LSDate = read["LSDate"].ToString().Trim();
model.LSStaff = read["LSStaff"].ToString().Trim();
model.LSNumberCount = read["LSNumberCount"].ToString().Trim();
model.LSMoney = read["LSMoney"].ToString().Trim();
model.LSYMoney = read["LSYMoney"].ToString().Trim();
model.LSCount = read["LSCount"].ToString().Trim();
model.LSPinPai = read["LSPinPai"].ToString().Trim();
model.LSColor = read["LSColor"].ToString().Trim();
model.LSSalesman = read["LSSalesman"].ToString().Trim();
model.LSMultipleName = read["LSMultipleName"].ToString().Trim();
model.LSQuestion = read["LSQuestion"].ToString().Trim();
model.LSRemark = read["LSRemark"].ToString().Trim();
model.LSDanNumber = read["LSDanNumber"].ToString().Trim();
model.LSCardNumber = read["LSCardNumber"].ToString().Trim();
model.ImgUrl = read["ImgUrl"].ToString().Trim();
model.IsSP = Convert.ToBoolean(read["IsSP"]);
model.IsJC = Convert.ToBoolean(read["IsJC"]);
model.IsXMoney = Convert.ToBoolean(read["IsXMoney"]);
list.Add(model);
i++;
}
}
return(list);
}
//散客的消费消费
public List <LiShiConsumption> selectAllListSK(string skname, string sktel, string name)
{
List <LiShiConsumption> list = new List <LiShiConsumption>();
if (ID == null)
{
return(list);
}
LiShiConsumption model;
string str;
SqlParameter[] pms;
if (skname.Trim() == "")
{
str = "select * from LSConsumption" + ID + " where LSNumberCount=@LSNumberCount";
pms = new SqlParameter[] {
new SqlParameter("@LSNumberCount", sktel)
};
}
else if (sktel.Trim() == "")
{
str = "select * from LSConsumption" + ID + " where LSName=@LSName";
pms = new SqlParameter[] {
new SqlParameter("@LSName", skname)
};
}
else
{
str = "select * from LSConsumption" + ID + " where LSName=@LSName and LSNumberCount=@LSNumberCount";
pms = new SqlParameter[] {
new SqlParameter("@LSName", skname),
new SqlParameter("@LSNumberCount", sktel)
};
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new LiShiConsumption();
model.LSName = read["LSName"].ToString().Trim();
model.LSDate = read["LSDate"].ToString().Trim();
model.LSStaff = read["LSStaff"].ToString().Trim();
model.LSNumberCount = read["LSNumberCount"].ToString().Trim();
model.LSMoney = read["LSMoney"].ToString().Trim();
model.LSYMoney = read["LSYMoney"].ToString().Trim();
model.LSCount = read["LSCount"].ToString().Trim();
model.LSPinPai = read["LSPinPai"].ToString().Trim();
model.LSColor = read["LSColor"].ToString().Trim();
model.LSSalesman = read["LSSalesman"].ToString().Trim();
model.LSMultipleName = read["LSMultipleName"].ToString().Trim();
model.LSQuestion = read["LSQuestion"].ToString().Trim();
model.LSRemark = read["LSRemark"].ToString().Trim();
model.LSDanNumber = read["LSDanNumber"].ToString().Trim();
model.LSCardNumber = read["LSCardNumber"].ToString().Trim();
model.ImgUrl = read["ImgUrl"].ToString().Trim();
model.ID = Convert.ToInt32(read["ID"]);
model.IsSP = Convert.ToBoolean(read["IsSP"]);
model.IsJC = Convert.ToBoolean(read["IsJC"]);
model.IsXMoney = Convert.ToBoolean(read["IsXMoney"]);
list.Add(model);
}
}
return(list.OrderByDescending(a => a.LSDate).ToList());
}
