public DataBean GetData(string path = "")
{
DataBean bean = new DataBean();
XElement read = XElement.Load(path);
var nodes = from item in read.Elements("xsjl") select item;
foreach (var temp in nodes)
{
bean.ShcBh = temp.Element("ShcBh").Value;
bean.ShcDj = temp.Element("ShcDj").Value;
bean.XSSL = temp.Element("XSSL").Value;
bean.XSTime = Util.UtiData.StringToDateTime(temp.Element("XSTime").Value);
bean.Zt = "0";
bean.ZydBh = temp.Element("ZydBh").Value;
}
return bean;
}
public IList<DataBean> GetDataList(string path = "")
{
IList<DataBean> beanlist = new List<DataBean>();
XElement read = XElement.Load(path);
var nodes = from item in read.Elements("SC") select item;
foreach (var temp in nodes)
{
DataBean bean = new DataBean();
bean.ShcBh = temp.Element("b").Value;
bean.ShcDj = temp.Element("c").Value;
bean.XSSL = temp.Element("d").Value;
bean.XSTime = Util.UtiData.StringToDateTime(temp.Element("e").Value);
bean.Zt = "0";
bean.ZydBh = temp.Element("a").Value;
bean.JyJlID = temp.FirstAttribute.Value;
beanlist.Add(bean);
}
return beanlist;
}
public IList<Model.DataBean> GetDataList(string path = "")
{
IList<DataBean> list = new List<DataBean>();
string sql = "select * from SalesRecord where State in(0,1)";
AccessHelper db = new AccessHelper();
OleDbCommand cmd = db.GetSqlStringCommand(sql);
DataTable dt = db.ExecuteDataTable(cmd);
foreach (DataRow VARIABLE in dt.Rows)
{
DataBean bena = new DataBean();
bena.ID = UtiData.DBObjectToInt(VARIABLE["ID"]);
bena.ShcBh = UtiData.DBObjectToString(VARIABLE["ScBh"]);
bena.ShcDj = UtiData.DBObjectToString(VARIABLE["ScDj"]);
bena.XSSL = UtiData.DBObjectToString(VARIABLE["ScZl"]);
bena.XSTime = UtiData.DBObjectToDateTime(VARIABLE["JyTime"]);
bena.ZydBh = UtiData.DBObjectToString(VARIABLE["ScZydBh"]);
bena.JyJlID = UtiData.DBObjectToString(VARIABLE["JyJlID"]);
list.Add(bena);
}
return list;
}