public int Update(SqlTransaction trans, PurchaseStockModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update Sm_Purchase_Stock set "); builder.Append("scode=@scode,"); builder.Append("pscode=@pscode,"); builder.Append("number=@number,"); builder.Append("sprice=@sprice,"); builder.Append("corp=@corp,"); builder.Append("arrivalDate=@arrivalDate"); builder.Append(" where psid=@psid "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@psid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@pscode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@arrivalDate", SqlDbType.DateTime) }; commandParameters[0].Value = model.psid; commandParameters[1].Value = model.scode; commandParameters[2].Value = model.pscode; commandParameters[3].Value = model.number; commandParameters[4].Value = model.sprice; commandParameters[5].Value = model.corp; if ((model.ArrivalDate != null) && (model.ArrivalDate.ToString() != "")) { commandParameters[6].Value = DateTime.Parse(model.ArrivalDate); } else { commandParameters[6].Value = DBNull.Value; } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
public void stock_AddItem(ProductModel itemToAdd) { if (purchaseStocks.Any(x => x.ProductCode == itemToAdd.Id) && _selectedStock.ProductCode != itemToAdd.Id) { ConfirmationPopup form = new ConfirmationPopup((string)Application.Current.Resources["purchase_already"], header, true); form.ShowDialog(); if (Common._isChecked) { PurchaseStockModel _purchaseStock = new PurchaseStockModel(); _purchaseStock.ProductName = itemToAdd.ItemName; _purchaseStock.productCode = Convert.ToInt64(itemToAdd.Id); purchaseStocks[rowIndex] = _purchaseStock; lstPurchase.ItemsSource = purchaseStocks; } } else { // if (Common._isChecked) // { PurchaseStockModel _purchaseStock = new PurchaseStockModel(); _purchaseStock.ProductName = itemToAdd.ItemName; _purchaseStock.productCode = Convert.ToInt64(itemToAdd.Id); purchaseStocks[rowIndex] = _purchaseStock; lstPurchase.ItemsSource = purchaseStocks; // } } if (_selectedStock.StockId != null) { _deletestocks.Add(new StockModel(_selectedStock.StockId, _purchaseData.PurchaseId.Value, _selectedStock.Quantity, _selectedStock.CostPrice, _selectedStock.SellingPrice, _selectedStock.MRP, _selectedStock.Discount, _selectedStock.BatchNo, _selectedStock.ProductCode, null)); } }
public int Add(SqlTransaction trans, PurchaseStockModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Sm_Purchase_Stock("); builder.Append("psid,scode,pscode,number,sprice,corp,arrivalDate)"); builder.Append(" values ("); builder.Append("@psid,@scode,@pscode,@number,@sprice,@corp,@arrivalDate)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@psid", SqlDbType.NVarChar, 50), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@pscode", SqlDbType.NVarChar, 0x40), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@arrivalDate", SqlDbType.DateTime) }; commandParameters[0].Value = model.psid; commandParameters[1].Value = model.scode; commandParameters[2].Value = model.pscode; commandParameters[3].Value = model.number; commandParameters[4].Value = model.sprice; commandParameters[5].Value = model.corp; if ((model.ArrivalDate != null) && (model.ArrivalDate.ToString() != "")) { commandParameters[6].Value = DateTime.Parse(model.ArrivalDate); } else { commandParameters[6].Value = DBNull.Value; } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
// PUT api/purchasestock/5 public int Put(int id, PurchaseStockModel m) { m.PurchaseStockId = id; int i = PurchaseStockProvider.insertPurchaseStock(m); return(i); }
private void AddpurchaseItemSource(ProductModel purchaseModel) { PurchaseStockModel _purchaseStock = new PurchaseStockModel(); _purchaseStock.ProductName = purchaseModel.ItemName; _purchaseStock.productCode = Convert.ToInt64(purchaseModel.Id); purchaseStocks[rowIndex] = _purchaseStock; lstPurchase.ItemsSource = purchaseStocks; }
private void txtProduct_PreviewMouseDown(object sender, MouseButtonEventArgs e) { productPopUp.IsOpen = true; this.IsEnabled = false; System.Windows.Controls.ListViewItem lvi = GetAncestorByType( e.OriginalSource as DependencyObject, typeof(System.Windows.Controls.ListViewItem)) as System.Windows.Controls.ListViewItem; if (lvi != null) { lstPurchase.SelectedIndex = lstPurchase.ItemContainerGenerator.IndexFromContainer(lvi); rowIndex = lstPurchase.SelectedIndex; _selectedStock = (PurchaseStockModel)lstPurchase.SelectedItem; } }
private void btn_remove_Click(object sender, RoutedEventArgs e) { PurchaseStockModel purchase = (PurchaseStockModel)lstPurchase.SelectedItem; if (purchase.StockId != null) { _deletestocks.Add(new StockModel(purchase.StockId, _purchaseData.PurchaseId.Value, purchase.Quantity, purchase.CostPrice, purchase.SellingPrice, purchase.MRP, purchase.Discount, purchase.BatchNo, purchase.ProductCode, null)); } purchaseStocks.Remove(purchase); lstPurchase.ItemsSource = purchaseStocks; List <PurchaseStockModel> Stocks = lstPurchase.Items.Cast <PurchaseStockModel>().Select(x => x).ToList(); ProductAmount amount = CommonFunctions.RetrunProductAmount(Stocks, purchase_cashdiscount.Text, purchase_cashdiscountDoller.Text, _taxValue, purchase_cashSubChargeAmo.Text); netAmount.Text = Convert.ToString(CommonFunction.Common.RoundOff(amount.NetTotal == null ? Convert.ToDecimal("0.00") : Convert.ToDecimal(amount.NetTotal))); //CommonFunction.Common.RoundOff(amount.NetTotal.ToString()); totalAmount.Text = Convert.ToString(CommonFunction.Common.RoundOff(amount.TotalAmount == null ? Convert.ToDecimal("0.00") : Convert.ToDecimal(amount.TotalAmount))); }
public static int insertPurchaseStock(PurchaseStockModel s) { try { SqlHandler sql = new SqlHandler(); List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@PurchaseStockId", s.PurchaseStockId)); parameter.Add(new KeyValuePair <string, object>("@PurchaseStockGrossWt", s.PurchaseStockGrossWt)); parameter.Add(new KeyValuePair <string, object>("@PurchaseStockNetWt", s.PurchaseStockNetWt)); parameter.Add(new KeyValuePair <string, object>("@AmountPaid", s.AmountPaid)); parameter.Add(new KeyValuePair <string, object>("@StockId", s.StockId)); parameter.Add(new KeyValuePair <string, object>("@PaymentType", s.PaymentType)); parameter.Add(new KeyValuePair <string, object>("@PurchaseInvoiceNo", s.PurchaseInvoiceNo)); parameter.Add(new KeyValuePair <string, object>("@Amount", s.Amount)); parameter.Add(new KeyValuePair <string, object>("@CrAcccountId", s.AccountId)); parameter.Add(new KeyValuePair <string, object>("@FinancialYearId", s.FinancialYearId)); parameter.Add(new KeyValuePair <string, object>("@CompanyId", s.CompanyId)); parameter.Add(new KeyValuePair <string, object>("@insertBy", s.InsertBy)); parameter.Add(new KeyValuePair <string, object>("@insertDate", s.InsertDate)); parameter.Add(new KeyValuePair <string, object>("@DrAccountId", s.PaidBy)); parameter.Add(new KeyValuePair <string, object>("@Gold", s.DueGold)); parameter.Add(new KeyValuePair <string, object>("@PaidGold", s.PaidGold)); parameter.Add(new KeyValuePair <string, object>("@transactionId", 0)); int i = sql.ExecuteNonQueryI("Usp_AddPurchaseStockDetails", parameter); return(i); } catch (Exception ex) { throw ex; } }
protected void btnDelete_Click(object sender, EventArgs e) { List <string> listFromJson = JsonHelper.GetListFromJson(this.hfldPurchaseplanChecked.Value); if (this.ViewState["modifyStockAction"].ToString() == "edit") { List <string> list = new List <string>(); if (this.ViewState["modifyStockIds"] != null) { list = (List <string>) this.ViewState["modifyStockIds"]; } List <string> listFromJson2 = JsonHelper.GetListFromJson(this.hfldModifyStockId.Value); foreach (string current in listFromJson2) { if (!string.IsNullOrEmpty(current)) { list.Add(current); } } this.ViewState["modifyStockIds"] = list; } List <string> listFromJson3 = JsonHelper.GetListFromJson(this.hfldPurchaseIds.Value); List <string> list2 = new List <string>(); List <string> list3 = new List <string>(); foreach (string current2 in listFromJson3) { DataTable infoByPurchaseId = this.balanceStock.GetInfoByPurchaseId(current2); if (infoByPurchaseId.Rows.Count > 0) { PurchaseStockModel model = this.purchaseStock.GetModel(current2); if (model != null) { list3.Add(model.scode); listFromJson.Remove(model.scode); } if (this.ViewState["modifyStockIds"] != null) { list2 = (List <string>) this.ViewState["modifyStockIds"]; DataTable infoByModifyId = this.modifyStock.GetInfoByModifyId(this.hfldModifyId.Value); if (infoByModifyId.Rows.Count > 0) { DataRow[] array = infoByModifyId.Select("PurchaseId='" + current2 + "'"); DataRow[] array2 = array; for (int i = 0; i < array2.Length; i++) { DataRow dataRow = array2[i]; string item = dataRow["ModifyStockId"].ToString(); list2.Remove(item); } } } this.ViewState["modifyStockIds"] = list2; } } this.UpdatePurchaseplanStockDataSource(); this.DeleteResource(listFromJson); if (list3.Count > 0) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("alert('编号为"); foreach (string current3 in list3) { stringBuilder.Append(current3.Trim() + ","); } stringBuilder.Remove(stringBuilder.Length - 1, 1); stringBuilder.Append("的物资已经被结算,不能进行删除操作!');"); base.RegisterScript(stringBuilder.ToString()); } this.DataBindPurchaseplanStock(); }
public void Add(SqlTransaction trans, PurchaseStockModel model) { this.dal.Add(trans, model); }
public void Update(SqlTransaction trans, PurchaseStockModel model) { this.dal.Update(trans, model); }
public void Update(PurchaseStockModel model) { this.dal.Update(null, model); }
public void Add(PurchaseStockModel model) { this.dal.Add(null, model); }
// POST api/purchasestock public int Post(PurchaseStockModel m) { int i = PurchaseStockProvider.insertPurchaseStock(m); return(i); }
public void CommitEvent(object key) { string primarykey = key.ToString(); ConPayoutModify payOutModify = (from r in this.payOutSer where r.ModifyID == primarykey select r).FirstOrDefault <ConPayoutModify>(); BudModify budModify = (from r in this.modifySer where r.ModifyId == payOutModify.BudModifyId select r).FirstOrDefault <BudModify>(); budModify.Flowstate = 1; this.modifySer.Update(budModify); using (List <BudModifyTask> .Enumerator enumerator = (from p in this.budModifyTaskSer where p.ModifyId == budModify.ModifyId select p).ToList <BudModifyTask>().GetEnumerator()) { BudModifyTask task; while (enumerator.MoveNext()) { task = enumerator.Current; BudTask item = (from p in this.budTaskSer where p.TaskId == task.TaskId select p).FirstOrDefault <BudTask>(); if ((item != null) && (budModify.Flowstate == 1)) { if (task.ModifyType == 0) { item.IsValid = true; this.budTaskSer.Update(item); this.budModifyTaskSer.UpdateTotal2(task.ModifyTaskId); } if (item.ModifyId != task.ModifyId) { item.ModifyId = task.ModifyId; item.Total2 += task.Total2; decimal?quantity = item.Quantity; decimal num = task.Quantity; item.Quantity = quantity.HasValue ? new decimal?(quantity.GetValueOrDefault() + num) : null; if (item.Quantity != 0M) { item.UnitPrice = item.Total2 / item.Quantity; } this.budTaskSer.Update(item); this.budModifyTaskSer.UpdateTotal2(task.ModifyTaskId); } } } } string cmdText = string.Format(" SELECT * FROM Con_Modify_Stock where ModifyId='{0}' ", primarykey); if (SqlHelper.ExecuteQuery(CommandType.Text, cmdText, null).Rows.Count != 0) { string str2 = string.Format("SELECT ModifyStock.*FROM Con_Modify_Stock ModifyStock\r\n INNER JOIN Sm_Purchase_Stock purchaseStock ON ModifyStock.purchaseId=purchaseStock.psid\r\n WHERE ModifyId='{0}'", primarykey); DataTable table2 = SqlHelper.ExecuteQuery(CommandType.Text, str2, null); string str3 = string.Format("SELECT purchaseStock.* FROM Sm_Purchase_Stock purchaseStock \r\n LEFT JOIN (SELECT *FROM Con_Modify_Stock where ModifyId='{0}') ModifyStock\r\n ON purchaseStock.psid=ModifyStock.purchaseId\r\n WHERE purchaseStock.pscode in (SELECT DISTINCT Pscode FROM Con_Modify_Stock WHERE ModifyId='{0}')\r\n AND ModifyStockId IS NULL", primarykey); DataTable table3 = SqlHelper.ExecuteQuery(CommandType.Text, str3, null); string str4 = string.Format("SELECT ModifyStock.* FROM Con_Modify_Stock ModifyStock\r\n LEFT JOIN Sm_Purchase_Stock purchaseStock ON ModifyStock.purchaseId=purchaseStock.psid\r\n WHERE ModifyId='{0}'AND psid IS NULL", primarykey); DataTable table4 = SqlHelper.ExecuteQuery(CommandType.Text, str4, null); using (SqlConnection connection = new SqlConnection(SqlHelper.ConnectionString)) { connection.Open(); SqlTransaction trans = connection.BeginTransaction(); foreach (DataRow row in table2.Rows) { PurchaseStockModel model = new PurchaseStockModel { psid = row["PurchaseId"].ToString(), sprice = DBHelper.GetDecimal(row["Sprice"]), number = DBHelper.GetDecimal(row["Quantity"]), corp = DBHelper.GetString(row["Corp"]) }; if (row["ArrivalDate"] != null) { model.ArrivalDate = row["ArrivalDate"].ToString(); } else { model.ArrivalDate = null; } model.pscode = row["Pscode"].ToString(); model.scode = row["Scode"].ToString(); this.purchaseSotck.Update(trans, model); } foreach (DataRow row2 in table3.Rows) { this.purchaseSotck.Delete(trans, row2["psid"].ToString()); } foreach (DataRow row3 in table4.Rows) { PurchaseStockModel model2 = new PurchaseStockModel { psid = row3["PurchaseId"].ToString(), sprice = DBHelper.GetDecimal(row3["Sprice"]), number = DBHelper.GetDecimal(row3["Quantity"]), corp = DBHelper.GetString(row3["Corp"]) }; if (row3["ArrivalDate"] != null) { model2.ArrivalDate = row3["ArrivalDate"].ToString(); } else { model2.ArrivalDate = null; } model2.pscode = row3["Pscode"].ToString(); model2.scode = row3["Scode"].ToString(); this.purchaseSotck.Add(trans, model2); } trans.Commit(); return; } } string str5 = string.Format("\r\n\t\t\t\t\t\t\t\t\tSELECT PCode FROM Sm_Purchase purchase\r\n\t\t\t\t\t\t\t\t\tINNER JOIN Con_Payout_Modify payoutModify ON purchase.Contract=payoutModify.ContractId\r\n\t\t\t\t\t\t\t\t\tWHERE ModifyId='{0}' AND purchase.FlowState=1", primarykey); DataTable table5 = SqlHelper.ExecuteQuery(CommandType.Text, str5, null); if (table5.Rows.Count > 0) { using (SqlConnection connection2 = new SqlConnection(SqlHelper.ConnectionString)) { connection2.Open(); SqlTransaction transaction2 = connection2.BeginTransaction(); foreach (DataRow row4 in table5.Rows) { this.purchaseSotck.DeleteByPscode(transaction2, row4["PCode"].ToString()); } transaction2.Commit(); } } }