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();
}
