public static bool GetBill(string PLUID, out DBJhBill bill, out string msg)
{
SQLiteDataReader rd;
if (!DBTool.Select("PluID=@PluID", new DBJhBill()
{
PluID = PLUID
}, string.Empty, out rd, out msg))
{
bill = null;
return(false);
}
ICollection <DBJhBill> list = ObjTool.BuildObject <DBJhBill>(rd);
rd.Close();
if (list.Count > 0)
{
bill = list.First();
return(true);
}
else
{
msg = "未查询到采购信息";
bill = null;
return(false);
}
}
/// <summary>
/// 获取付款流水
/// </summary>
/// <param name="payList"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool GetSalSalePay(out List <TSalSalePay> payList, out string msg)
{
SQLiteDataReader rd;
if (!DBTool.Select(string.Empty, new DBSalSalePay(), string.Empty, out rd, out msg))
{
payList = null;
return(false);
}
payList = new List <TSalSalePay>();
while (rd.Read())
{
TSalSalePay pay = new TSalSalePay();
pay.ORGCODE = Convert.ToString(rd["OrgCode"]);
pay.SALENO = Convert.ToString(rd["SaleNo"]);
pay.SERIALNO = Convert.IsDBNull(rd["SerialNo"]) ? "0" : rd["SerialNo"].ToString();
pay.SSTOTAL = Convert.IsDBNull(rd["SsTotal"]) ? "0" : rd["SsTotal"].ToString();
pay.VIPNO = Convert.ToString(rd["VipNo"]);
pay.ZFCODE = Convert.ToString(rd["ZfCode"]);
pay.ZFNO = Convert.ToString(rd["ZfNo"]);
pay.ZFTOTAL = string.IsNullOrEmpty(rd["ZfTotal"].ToString()) ? "0" : rd["ZfTotal"].ToString();
payList.Add(pay);
}
rd.Close();
return(true);
}
///// <summary>
///// 获取指定采购单明细
///// </summary>
///// <param name="code"></param>
///// <param name="PackUnit"></param>
///// <param name="PackQty"></param>
///// <param name="bill"></param>
///// <param name="msg"></param>
///// <returns></returns>
//public static bool GetBill(int ToSerialNo, out DBJhBill bill, out string msg)
//{
// SQLiteDataReader rd;
// if (!DBTool.Select(" ToSerialNo=@ToSerialNo ", new DBJhBill() { ToSerialNo = ToSerialNo }, string.Empty, out rd, out msg))
// {
// bill = null;
// return false;
// }
// if (rd.Read())
// {
// int i;
// if(!GetMaxSerialNo(out i,out msg))
// {
// //取SerialNo失败
// rd.Close();
// bill = null;
// return false;
// }
// bill = new DBJhBill();
// bill.ID = new Guid(Convert.ToString(rd["ID"]));
// bill.Barcode = Convert.ToString(rd["Barcode"]);
// bill.BillNo = Convert.ToString(rd["BillNo"]);
// bill.CgCount = Convert.ToDecimal(rd["CgCount"]);
// bill.Checked = Convert.ToString(rd["Checked"]);
// bill.LrDate = Convert.ToDateTime(rd["LrDate"]);
// bill.LrUser = Convert.ToString(rd["LrUser"]);
// bill.CgPackCount = Convert.ToDecimal(rd["CgPackCount"]);
// bill.SsPackCount = Convert.ToDecimal(rd["SsPackCount"]);
// bill.PackQty = Convert.ToDecimal(rd["PackQty"]);
// bill.PackUnit = Convert.ToString(rd["PackUnit"]);
// bill.PluCode = Convert.ToString(rd["PluCode"]);
// bill.PluID = Convert.ToString(rd["PluID"]);
// bill.PluName = Convert.ToString(rd["PluName"]);
// bill.SerialNo = i++;
// bill.ToSerialNo = Convert.ToInt16(rd["ToSerialNo"]);
// bill.CgSGLCount = Convert.ToDecimal(rd["CgSGLCount"]);
// bill.SsSGLCount = Convert.ToDecimal(rd["SsSGLCount"]);
// bill.Spec = Convert.ToString(rd["Spec"]);
// bill.SsCount = Convert.ToDecimal(rd["SsCount"]);
// bill.Unit = Convert.ToString(rd["Unit"]);
// return true;
// }
// else
// {
// msg = "未查询到采购信息";
// bill = null;
// return false;
// }
//}
/// <summary>
/// 获取指定采购单明细
/// </summary>
/// <param name="packet"></param>
/// <param name="bill"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool GetBill(string Code, TPacket packet, out DBJhBill bill, out string msg)
{
SQLiteDataReader rd;
if (!DBTool.Select("PluCode=@PluCode And PackQty=@PackQty And PackUnit=@PackUnit", new DBJhBill()
{
PluCode = Code, PackQty = decimal.Parse(packet.PACKQTY), PackUnit = packet.PACKUNIT
}, string.Empty, out rd, out msg))
{
bill = null;
return(false);
}
ICollection <DBJhBill> list = ObjTool.BuildObject <DBJhBill>(rd);
rd.Close();
if (list.Count > 0)
{
bill = list.First();
return(true);
}
else
{
msg = "未查询到采购信息";
bill = null;
return(false);
}
}
/// <summary>
/// 列表验收单
/// </summary>
/// <param name="jhBill"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool ListBill(out List <DBJhBill> jhBill, out string msg)
{
SQLiteDataReader rd;
if (!DBTool.Select(string.Empty, new DBJhBill(), "Checked Desc", out rd, out msg))
{
jhBill = null;
return(false);
}
jhBill = new List <DBJhBill>();
jhBill.AddRange(ObjTool.BuildObject <DBJhBill>(rd));
rd.Close();
return(true);
}
/// <summary>
/// 从单据中获取Plu信息
/// </summary>
/// <param name="code"></param>
/// <param name="plus"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool QueryPluFromBill(string code, out List <TRFQueryPlu> plus, out string msg)
{
SQLiteDataReader rd;
if (!DBTool.Select(" Barcode=@Barcode Or PluCode=@PluCode ", new DBJhBill()
{
Barcode = code, PluCode = code
}, string.Empty, out rd, out msg))
{
plus = null;
return(false);
}
plus = new List <TRFQueryPlu>();
while (rd.Read())
{
if (plus.Count == 0)
{
//添加当前商品
TRFQueryPlu plu = new TRFQueryPlu();
plu.BARCODE = Convert.ToString(rd["Barcode"]);
plu.PLUCODE = Convert.ToString(rd["PluCode"]);
plu.PLUID = Convert.ToString(rd["PluID"]);;
plu.PLUNAME = Convert.ToString(rd["PluName"]);
plu.SPEC = Convert.ToString(rd["Spec"]);
plu.UNIT = Convert.ToString(rd["Unit"]);
plu.Packets = new List <TPacket>();
plus.Add(plu);
}
if (Convert.ToDecimal(rd["PackQty"]) != 0)
{
TPacket packet = new TPacket();
packet.PACKETID = Convert.ToInt16(rd["ToSerialNo"]).ToString();//将SerialNo当作包装ID
packet.PACKQTY = Convert.ToDecimal(rd["PackQty"]).ToString("F2");
packet.PACKUNIT = Convert.ToString(rd["PackUnit"]);
plus[0].Packets.Add(packet);
}
}
rd.Close();
if (plus.Count > 0)
{
return(true);
}
else
{
msg = "采购单中未找到该商品。";
plus = null;
return(false);
}
}
/// <summary>
/// 读取省份表
/// </summary>
/// <param name="provinceMap"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool LoadProvince(out Hashtable provinceMap, out string msg)
{
provinceMap = new Hashtable();
SQLiteDataReader rd;
if (!DBTool.Select(string.Empty, new DBProvince(), string.Empty, out rd, out msg))
{
return(false);
}
else
{
while (rd.Read())
{
provinceMap.Add(rd["Index"], rd["Province"]);
}
rd.Close();
return(true);
}
}
/// <summary>
/// 获取下一个流水号
/// </summary>
/// <param name="ObjName"></param>
/// <param name="no"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool GetNextNo <T>(out int no, out string msg)
{
string _ObjName = typeof(T).Name;
SQLiteDataReader rd;
switch (_ObjName)
{
case "DBPdData":
if (!DBTool.Select("ObjName=@ObjName And LastDate=@LastDate", new DBNextNo()
{
ObjName = _ObjName, LastDate = DateTime.Today
}, string.Empty, out rd, out msg))
{
no = -1;
return(false);
}
else
{
if (rd.Read())
{
no = Convert.ToInt16(rd["LastNo"]) + 1;
}
else
{
no = 1;
}
rd.Close();
return(true);
}
default:
no = -1;
msg = "错误：不存在对象";
return(false);
}
}