public static void Update(DBLayer.Charges.Details det) { ZFort.DB.Execute.ExecuteString_void("UPDATE Charges SET [GroupId] = " + det.GroupId.ToString() + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE Charges SET [Name] = '" + det.Name + "' WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE Charges SET [Summ] = " + det.Summ.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE Charges SET [Date] = '" + det.Date.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString()); }
public static int Insert(DBLayer.Charges.Details det) { string sql = "INSERT INTO Charges (GroupId, [Name], Summ, [Date], AdministratorId) "; sql += " VALUES (" + det.GroupId.ToString() + ", '" + det.Name + "', " + det.Summ.ToString().Replace(",", ".") + ", '" + det.Date.ToString("yyyyMMdd") + "', " + det.AdminstratorId.ToString() + ")"; ZFort.DB.Execute.ExecuteString_void(sql); sql = "SELECT Max(Id) FROM Charges"; return((int)ZFort.DB.Execute.ExecuteString_Scalar(sql)); }
public FrmEditCharge(int id) { InitializeComponent(); this.Id = id; this.Details = DBLayer.Charges.GetDetails(id); tbDate.Text = this.Details.Date.ToString("dd-MMM-yyyy"); tbName.Text = this.Details.Name; tbSumm.Text = this.Details.Summ.ToString(); //MessageBox.Show(this.Details.GroupId.ToString()); LoadList(this.Details.GroupId); }
public static void Delete(int id) { string user = ((DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User")).FIO; DBLayer.Charges.Details cDet = DBLayer.Charges.GetDetails(id); DBLayer.DeletingLog.DeletingLog_Details det = new DeletingLog.DeletingLog_Details(); det.Date = DateTime.Now; det.Name = cDet.Name + "(" + cDet.Summ.ToString() + ")"; det.Type = 1; det.User = user; DBLayer.DeletingLog.Insert(det); ZFort.DB.Execute.ExecuteString_void("DELETE FROM Charges WHERE [Id] = " + id.ToString()); }
private void btnOk_Click(object sender, EventArgs e) { this.Details.SupplierId = ((Lib.ServiceFunctions.ListItem)cbSuppliers.SelectedItem).ID; this.Details.ProductId = ((Lib.ServiceFunctions.ListItem)cbProduct.SelectedItem).ID; this.Details.Date = Convert.ToDateTime(tbDate.Text); this.Details.Price = Convert.ToDouble(tbPrice.Text); this.Details.Quantity = Convert.ToDouble(tbQuantity.Text); if (this.Id == 0) { this.Details.Id = DBLayer.ArrivalDetails.Insert(this.Details); DBLayer.Charges.Details det = new FitnessProject.DBLayer.Charges.Details(); det.AdminstratorId = ((DBLayer.Users.Details)AppDomain.CurrentDomain.GetData("User")).Id; det.Date = DateTime.Now.Date; det.GroupId = 4; det.Name = "Закупка " + ((Lib.ServiceFunctions.ListItem)cbProduct.SelectedItem).Name; det.Summ = this.Details.Price * this.Details.Quantity; int id = DBLayer.Charges.Insert(det); this.Details.ChargeId = id; DBLayer.ArrivalDetails.Update(this.Details); } else { DBLayer.ArrivalDetails.Update(this.Details); if (this.Details.ChargeId != 0) { DBLayer.Charges.Details chDet = DBLayer.Charges.GetDetails(this.Details.ChargeId); chDet.Date = this.Details.Date; chDet.Summ = this.Details.Price * this.Details.Quantity; DBLayer.Charges.Update(chDet); } } this.Close(); }