private void Form1_Load(object sender, EventArgs e)
{
dgvSalesMain.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvSalesMain.ClearSelection();
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView2.ClearSelection();
PurchaseDao.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
PurchaseDao.ClearSelection();
showExpenses();
showSales();
showPurchases();
PublicMainForm = this;
DateTime startDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime startDay2 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 2);
DateTime startDay3 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 3);
DateTime secondlastDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, (DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) - 1));
DateTime lastDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month));
DateTime Now = DateTime.Now;
if (Now.Day == startDay.Day || Now.Day == startDay2.Day || Now.Day == startDay3.Day ||
Now.Day == secondlastDay.Day || Now.Day == lastDay.Day)
{
frmShowDebts frmShowDebts = new frmShowDebts();
frmShowDebts.ShowDialog();
}
DisplayStockEndingAlert();
}
private void Submit_Click(object sender, RoutedEventArgs e)
{
Multiply func = new Multiply();
ListModel listModel = new ListModel();
PurchaseDao purchase = new PurchaseDao();
PurchaseOrder purchaseOrder = new PurchaseOrder()
{
//总订单
TNVal = listModel.timer,
//分订单
SNVal = func.LongConvertor(listModel.subNumber),
//名称
MTNameVal = Name.Text,
//型号
MTNumberVal = Type.Text,
//类别
MTClassVal = Category.Text,
//下单日期
OrderDateVal = Date.Text,
//数量
QuantityVal = func.IntConvertor(Number.Text),
//进价
PurchasePriceVal = func.DoubleConvertor(Price.Text),
//总价
TotalPriceVal = func.DoubleConvertor(Total.Text),
//备注
RemarksVal = Remarks.Text
};
//新建入库订单
purchase.AddPrchase(purchaseOrder, this);
StartTimer();
}
private void RmvBtn_Click(object sender, EventArgs e)
{
try
{
if (dataGridView1.SelectedRows.Count != 0)
{
DialogResult result = MessageBox.Show("Do You Want to Delete?", "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result.Equals(DialogResult.OK))
{
DataGridViewRow row = this.dataGridView1.SelectedRows[0];
string id = row.Cells["id"].Value.ToString();
PurchaseDao d = new PurchaseDao();
d.delete(id);
showlist();
MessageBox.Show("Deleted");
Purchase_Load(sender, e);
}
else
{
///leave
}
}
else
{
MessageBox.Show("Select the row you want to delete");
Purchase_Load(sender, e);
}
}
catch (SqlException error)
{
MessageBox.Show(error.Message.ToString());
}
}
public static void Buy(IApplicationBuilder app)
{
app.Run(async context =>
{
var userId = context.Session.GetInt32("users_id");
if (userId == null)
{
if (context.Request.Cookies.ContainsKey("users_id"))
{
userId = int.Parse(context.Request.Cookies["users_id"]);
var usersName = context.Request.Cookies["users_name"];
context.Session.SetInt32("users_id", (int)userId);
context.Session.SetString("users_name", usersName);
}
context.Response.Headers.Add("result", "error");
return;
}
var courseId = int.Parse(context.Request.Headers["course_id"]);
var usersDao = new UsersDao();
usersDao.AddCourseToUser((int)userId, courseId);
var purchaseDao = new PurchaseDao();
var price = int.Parse(context.Request.Headers["price"]);
var newPurchase = new Purchase((int)userId, courseId, DateTime.Now, price);
purchaseDao.Save(newPurchase);
context.Response.Headers.Add("result", "ok");
});
}
public IActionResult OnGet()
{
var usersId = HttpContext.Session.GetInt32("users_id");
if (usersId == null)
{
if (HttpContext.Request.Cookies.ContainsKey("users_id"))
{
usersId = int.Parse(HttpContext.Request.Cookies["users_id"]);
var usersName = HttpContext.Request.Cookies["users_name"];
HttpContext.Session.SetInt32("users_id", (int)usersId);
HttpContext.Session.SetString("users_name", usersName);
}
else
{
return(Redirect("SignIn"));
}
}
var usersDao = new UsersDao();
Users = usersDao.GetById((int)usersId);
Courses = usersDao.GetCourses((int)usersId);
var purchaseDao = new PurchaseDao();
Purchases = purchaseDao.GetByUsersId((int)usersId);
foreach (var purchase in Purchases)
{
purchase.CourseName = Courses.First(c => c.Id == purchase.CourseId).Name;
}
return(null);
}
// GET: Purchase
public ActionResult Index()
{
ViewData["ContinueShopping"] = "1";
ViewData["Price"] = "0";
ViewData["Cart"] = "0";
int userId = System.Convert.ToInt32(Request.Cookies["userId"].Value);
List <PurchaseItem> piList = PurchaseDao.getPurchaseItems(userId);
ViewData["PurchaseList"] = piList;
return(View());
}
//状态
private void State_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
string item = State.SelectedItem.ToString();
PurchaseDao purchaseDao = new PurchaseDao();
purchaseDao.QueryState(item, DataGrid_OrderView);
}
catch (Exception)
{
}
}
//型号
private void Type_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
string item = Type.SelectedItem.ToString();
PurchaseDao purchaseDao = new PurchaseDao();
purchaseDao.QueryType(item, DataGrid_StockStorage);
}
catch (Exception)
{
}
}
//日期
private void Date_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
{
try
{
string item = Convert.ToDateTime(Date.SelectedDate.ToString()).ToString("yyyy/M/d");
PurchaseDao purchaseDao = new PurchaseDao();
purchaseDao.QueryDate(item, DataGrid_OrderView);
}
catch (Exception)
{
}
}
private void AddCategories(string beginDate, string endDate, int categoryID)
{
List <EtPurchase> tmpLists = new List <EtPurchase>();
ECategory parentCategoryID = (ECategory)categoryID;
tmpLists = PurchaseDao.QueryByPurchaseDate(beginDate, endDate, parentCategoryID);
ClsCategory category = GetClsCategory(tmpLists);
if (category != null)
{
categories.Add(category);
}
}
public void showPurchases()
{
SqlConnection conn = Connection.getConnection();
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT TOP 30 pt.Name as [Part Name], P.Name as [Party Name], Pur.SellingPrice as [Cost Price], Pur.Qty as [Quanitity] FROM Purchase Pur INNER JOIN Party P ON P.Id = Pur.PartyId INNER JOIN Parts pt ON pt.PartNo = Pur.PartNo WHERE DatePurchased = convert(date,GETDATE())", conn);
DataTable dtstudent = new DataTable();
sda.Fill(dtstudent);
PurchaseDao.DataSource = dtstudent;
PurchaseDao.CancelEdit();
conn.Close();
}
public FrmGoodIncome()
{
InitializeComponent();
Goods = new List <ClsGood>();
goodsPreSize = 0;
goodsCurSize = 0;
LblPurchaseID.Text = (PurchaseDao.QueryAll().Last().PurchaseID + 1).ToString();
List <EtStaff> staffs = StaffDao.QueryByRole((int)ERole.采购员);
foreach (EtStaff staff in staffs)
{
CmbOperator.Items.Add(staff.StaffName);
}
}
private void AUbtn_Click(object sender, EventArgs e)
{
if (AUbtn.Text == "Edit")
{
if (prtnotxt.Text.Equals("") || partyidtxt.Text.Equals("") || Qtytxt.Text.Equals("") || slngprizetxt.Text.Equals(""))
{
MessageBox.Show("Required Fields are empty");
}
else
{
PurchaseDao pd = new PurchaseDao();
string sp = slngprizetxt.Text;
string date = dtetxt.Text;
string prtyid = partyidtxt.Text;
string Qty = Qtytxt.Text;
string prtno = prtnotxt.Text;
string id = idtxt.Text;
pd.Update(sp, date, prtyid, Qty, prtno, id);
MessageBox.Show("Updated!");
Purchase_Load(sender, e);
}
}
if (AUbtn.Text == "Add")
{
if (prtnotxt.Text.Equals("") || partyidtxt.Text.Equals("") || Qtytxt.Text.Equals("") || slngprizetxt.Text.Equals(""))
{
MessageBox.Show("Required Fields are empty");
}
else
{
PurchaseDao pd = new PurchaseDao();
string sp = slngprizetxt.Text;
string date = dtetxt.Text;
string prtyid = partyidtxt.Text;
string Qty = Qtytxt.Text;
string prtno = prtnotxt.Text;
string id = idtxt.Text;
pd.insert(sp, date, prtyid, Qty, prtno, id);
MessageBox.Show("added!");
Purchase_Load(sender, e);
}
}
}
private bool Save()
{
EtPurchase purchase;
if (-1 == CmbOperator.SelectedIndex)
{
MsgBoxUtil.ErrMsgBox("经办人不能为空！");
return(false);
}
int staffId = StaffDao.QueryByStaffName(CmbOperator.SelectedItem.ToString())[0].StaffID;
int res = 0;
foreach (ClsGood good in Goods)
{
purchase = new EtPurchase {
PurchaseID = int.Parse(LblPurchaseID.Text),
Category = good.Good.Category,
PurchaseDate = DtpPurchaseDate.Value.ToString("yyyyMMdd"),
Quantity = good.Count,
Cost = good.Good.Cost,
StaffID = staffId
};
res += PurchaseDao.InsertPurchase(purchase);
EtGood g = new EtGood {
Category = good.Good.Category,
ProductionDate = good.Good.ProductionDate,
PurchaseDate = purchase.PurchaseDate,
Cost = good.Good.Cost,
Price = good.Good.Price,
State = good.Good.State
};
for (int i = 0; i < good.Count; i++)
{
GoodDao.InsertGood(g);
}
}
if (res == Goods.Count)
{
return(true);
}
else
{
return(false);
}
}
private void ShowPurchaseDetail()
{
string beginDate = DtpBegin.Value.ToString("yyyyMMdd");
string endDate = DtpEnd.Value.ToString("yyyyMMdd");
if (CmbCategory.SelectedIndex == 0)
{
purchases = PurchaseDao.QueryByPurchaseDate(beginDate, endDate);
}
else
{
ECategory parentCategoryID = (ECategory)(CmbCategory.SelectedIndex - 1);
purchases = PurchaseDao.QueryByPurchaseDate(beginDate, endDate, parentCategoryID);
}
if (purchases.Count == 0)
{
MsgBoxUtil.ErrMsgBox("没有符合条件的记录");
}
DgvPurchaseDetailShow();
}
public ActionResult Checkout()
{
int userId = System.Convert.ToInt32(Request.Cookies["userId"].Value);
HttpCookieCollection cookies = Request.Cookies;
Dictionary <string, string> kV = Utility.CookieUtility.getProductKeyValues(cookies);
//make product id and no of item key value pair
string[] arr = cookies.AllKeys;
//persist in DB
PurchaseDao.InsertPurchase(userId, kV);
//remove items in the cart
foreach (string k in arr)
{
if (k != "userId" && k != "name")
{
HttpCookie cookie = new HttpCookie(k);
cookie.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(cookie);
}
}
return(RedirectToAction("Index", "Purchase"));
}
public PurchaseService()
{
dao = new PurchaseDao();
daoStore = new StoreDao();
}
public PurchaseIndentService()
{
dao = new PurchaseIndentDao();
daoStock = new PurchaseDao();
}
public PurchasePlanService()
{
dao = new PurchasePlanDao();
daoIndent = new PurchaseIndentDao();
daoPur = new PurchaseDao();
}
