/// <summary>
/// Kelsey Blount
/// created 2015/04/10
/// Handles archival of a listing
/// </summary>
/// <remarks>
/// Matt Lapka
/// Updated 2015/04/15
/// error messages added
/// </remarks>
/// <param name="ItemListID">item ID for the listing</param>
public void DeleteList(int ItemListID)
{
try
{
ItemListing myList = _listedLists
.Where(e => e.ItemListID == ItemListID).FirstOrDefault();
listResult result = _myManager.ArchiveItemListing(myList);
if (result == listResult.Success)
{
lblMessage.Text = "Event listing successfully deleted.";
Page.ClientScript.RegisterStartupScript(this.GetType(), "showit", "showMessage()", true);
}
else
{
lblMessage.Text = "Cannot delete listing with registered guests.";
Page.ClientScript.RegisterStartupScript(this.GetType(), "showit", "showMessage()", true);
}
}
catch (Exception ex)
{
lblMessage.Text = "Event deleting listing: " + ex.Message;
Page.ClientScript.RegisterStartupScript(this.GetType(), "showit", "showMessage()", true);
}
}
public void GetKingdee(string code)
{
using (SqlConnection conn = new SqlConnection())
{
string sql = "select t_icitem.fnumber as fnumber,t_icitem.fname as fname,t_icitem.fmodel as fmodel,t_measureunit.fname as jlname,fqty as fqty,t_stock.fname as CKfname from icinventory,t_icitem,t_stock,t_measureunit where icinventory.fitemid = t_icitem.fitemid and icinventory.fstockid = t_stock.fitemid and t_measureunit.fmeasureunitid = t_icitem.funitid and t_icitem.fnumber like '%" + code + "%' order by t_icitem.fnumber asc";
conn.ConnectionString = "Data Source=222.240.26.98;Initial Catalog=AIS20170114104255;User ID=getstock;Password=getstock";
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
listResult ResultModel = new listResult();
ResultModel.fnumber = dt.Rows[i]["fnumber"].ToString();
ResultModel.fname = dt.Rows[i]["fname"].ToString();
ResultModel.fmodel = dt.Rows[i]["fmodel"].ToString();
ResultModel.jlname = dt.Rows[i]["jlname"].ToString();
ResultModel.fqty = decimal.Parse(dt.Rows[i]["fqty"].ToString());
ResultModel.CKfname = dt.Rows[i]["CKfname"].ToString();
ResultModel.PTname = "金碟平台数据";
list.Add(ResultModel);
}
}
}
public ContentResult GetList(Lib.GridPager pager, string queryStr, string startSendTime, string endSendTime)
{
var list = db.T_Deliver.AsQueryable();
//根据名称或者单号查询
if (!string.IsNullOrWhiteSpace(queryStr))
{
list = list.Where(s => s.MailNo.Equals(queryStr) || s.PostName.Equals(queryStr));
}
//根据日期查询
if (!string.IsNullOrWhiteSpace(startSendTime) && !string.IsNullOrWhiteSpace(endSendTime))
{
DateTime startTime = DateTime.Parse(startSendTime);
DateTime endTime = DateTime.Parse(endSendTime + " 23:59:59");
list = list.Where(s => s.PostTime >= startTime && s.PostTime <= endTime);
}
else if (!string.IsNullOrWhiteSpace(startSendTime))
{
DateTime startTime = DateTime.Parse(startSendTime);
DateTime endTime = startTime.AddDays(5);
list = list.Where(s => s.PostTime >= startTime);
}
else if (!string.IsNullOrWhiteSpace(endSendTime))
{
DateTime endTime = DateTime.Parse(endSendTime + " 23:59:59");
DateTime startTime = endTime.AddDays(-5);
list = list.Where(s => s.PostTime <= endTime);
}
//分页
pager.totalRows = list.Count();
var queryData = list.OrderByDescending(s => s.ID).Skip((pager.page - 1) * pager.rows).Take(pager.rows).Select(item => new
{
item.ID,
item.MailNo,
item.WarehouseCode,
item.Note,
item.OrderNum,
item.PostName,
item.PostTime
});
//结果集合重新包装成需要的数据返回
List <listResult> ResultMod = new List <listResult>();
foreach (var item in queryData)
{
listResult ietmMOD = new listResult();
ietmMOD.ID = item.ID;
ietmMOD.MailNo = item.MailNo;
ietmMOD.Note = item.Note;
ietmMOD.OrderNum = item.OrderNum;
ietmMOD.PostName = item.PostName;
ietmMOD.PostTime = item.PostTime;
ietmMOD.WarehouseCode = getWarehouse(item.WarehouseCode);
ResultMod.Add(ietmMOD);
}
string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(ResultMod, Lib.Comm.setTimeFormat()) + "}";
return(Content(json));
}
public void ArchiveItemListing_InvalidItemListing()
{
Setup();
itemListingToTest.ItemListID = 99;
listResult actual = pMgr.ArchiveItemListing(itemListingToTest);
Assert.AreEqual(listResult.NotChanged, actual);
}
public void UpToGY(string queryStr)
{
string code = "";
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection())
{
queryStr = queryStr.PadLeft(5, '0');
string sql = "select Code from dbo.T_Bas_Goods where Code like '%" + queryStr + "'";
conn.ConnectionString = "Data Source=120.24.176.207;Initial Catalog=ebms3;User ID=erp_ggpt;Password=erp_ggpt123";
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
dt = ds.Tables[0];
}
for (int x = 0; x < dt.Rows.Count; x++)
{
code = dt.Rows[x]["Code"].ToString();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("sid", "hhs2");
dic.Add("appkey", "hhs2-ot");
dic.Add("spec_no", code);
dic.Add("timestamp", GetTimeStamp());
var aa = CreateParam(dic, true);
string ret = Post("http://api.wangdian.cn/openapi2/stock_query.php", aa);
JsonData jsonData = null;
jsonData = JsonMapper.ToObject(ret);
string sd = jsonData[0].ToString();
if (sd == "0")
{
int count = int.Parse(jsonData["total_count"].ToString());
for (int i = 0; i < count; i++)
{
listResult ResultModel = new listResult();
JsonData stocks = jsonData["stocks"][i];
ResultModel.fname = stocks["goods_name"].ToString();
ResultModel.fnumber = stocks["goods_no"].ToString();
ResultModel.fmodel = stocks["spec_name"].ToString();
ResultModel.jlname = "";
ResultModel.fqty = decimal.Parse(stocks["stock_num"].ToString());
ResultModel.CKfname = stocks["warehouse_name"].ToString();
ResultModel.PTname = "旺店通数据";
list.Add(ResultModel);
}
}
}
}
public void EditItemListing_ValidItemListing()
{
Setup();
EditSetup();
listResult actual = pMgr.EditItemListing(itemListingToEdit, itemListingToTest);
Cleanup();
Assert.AreEqual(listResult.Success, actual);
}
public void EditItemListing_NotChanged()
{
Setup();
EditSetup();
itemListingToTest.ItemListID = 99;
listResult actual = pMgr.EditItemListing(itemListingToEdit, itemListingToTest);
Cleanup();
Assert.AreEqual(listResult.NotChanged, actual);
}
public void EditItemListing_NoPriceChange()
{
Setup();
EditSetup();
itemListingToEdit.Price = 20.0000M;
listResult actual = pMgr.EditItemListing(itemListingToEdit, itemListingToTest);
Cleanup();
Assert.AreEqual(listResult.NoPriceChange, actual);
}
public void EditItemListing_MaxSmallerThanCurrent()
{
Setup();
EditSetup();
itemListingToEdit.MaxNumGuests = 1;
listResult actual = pMgr.EditItemListing(itemListingToEdit, itemListingToTest);
Cleanup();
Assert.AreEqual(listResult.MaxSmallerThanCurrent, actual);
}
public void EditItemListing_NoDateChange()
{
Setup();
EditSetup();
itemListingToEdit.StartDate = new DateTime(2025, 5, 28, 8, 30, 0);
listResult actual = pMgr.EditItemListing(itemListingToEdit, itemListingToTest);
Cleanup();
Assert.AreEqual(listResult.NoDateChange, actual);
}
public ContentResult GetList(Lib.GridPager pager, string queryStr, string Type)
{
list = new List <listResult>();
UpToGY(queryStr);
GetKingdee(queryStr);
if (Type != null && Type != "")
{
list = list.Where(a => a.CKfname == Type).ToList();
}
//分页
pager.totalRows = list.Count();
List <listResult> queryData = list.OrderByDescending(c => c.fnumber).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList();
//结果集合重新包装成需要的数据返回
List <listResult> ResultMod = new List <listResult>();
foreach (var item in queryData)
{
listResult ietmMOD = new listResult();
ietmMOD.fnumber = item.fnumber;
ietmMOD.fname = item.fname;
ietmMOD.fmodel = item.fmodel;
ietmMOD.jlname = item.jlname;
ietmMOD.fqty = item.fqty;
ietmMOD.CKfname = item.CKfname;
ietmMOD.PTname = item.PTname;
ResultMod.Add(ietmMOD);
}
List <CashBackStatisticsTotal> footerList = new List <CashBackStatisticsTotal>();
CashBackStatisticsTotal footer = new CashBackStatisticsTotal();
footer.jlname = "总计:";
if (ResultMod.Count() > 0)
{
footer.fqty = decimal.Parse(ResultMod.Sum(s => decimal.Parse(s.fqty.ToString())).ToString());
}
else
{
footer.fqty = 0;
}
footerList.Add(footer);
// string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(ResultMod, Lib.Comm.setTimeFormat()) + "}";
string json = "{\"total\":" + pager.totalRows + ",\"rows\":" + JsonConvert.SerializeObject(ResultMod, setTimeFormat()) + ",\"footer\":" + JsonConvert.SerializeObject(footerList, setTimeFormat()) + "}";
return(Content(json));
}
public void AddItemListing_Success()
{
Setup();
SupplierManager mySupMan = new SupplierManager();
mySupMan.AddANewSupplier(testSupp, "Test");
modSupp = getSupplierListCompName(suppList);
itemListingToTest.SupplierID = modSupp.SupplierID;
listResult actual = pMgr.AddItemListing(itemListingToTest);
Cleanup();
Assert.AreEqual(listResult.Success, actual);
}
public void EditItemListing_DateInPast()
{
Setup();
EditSetup();
itemListingToEdit.StartDate = new DateTime(2014, 5, 28, 10, 30, 0);
itemListingToEdit.EndDate = new DateTime(2015, 5, 28, 8, 30, 0);
itemListingToTest = itemListingToEdit;
listResult actual = pMgr.EditItemListing(itemListingToEdit, itemListingToTest);
Setup();
Cleanup();
Assert.AreEqual(listResult.DateInPast, actual);
}
public void ArchiveItemListing_ValidItemListing()
{
Setup();
SupplierManager myMan = new SupplierManager();
ProductManager otherMan = new ProductManager();
myMan.AddANewSupplier(testSupp, "Test");
modSupp = getSupplierListCompName(suppList);
itemListingToTest.SupplierID = modSupp.SupplierID;
otherMan.AddItemListing(itemListingToTest);
itemListingToTest = getItemListingTestObject(itemList);
itemListingToTest.CurrentNumGuests = 0;
listResult actual = pMgr.ArchiveItemListing(itemListingToTest);
Assert.AreEqual(listResult.Success, actual);
Cleanup();
}
