public static void SetDelete(DBLayer.AbonementIncome.Details det) { ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET IsDeleted = 1 WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET DeleteDate = '" + det.DeleteDate.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET DeleteReason = '" + det.DeleteReason + "' WHERE [Id] = " + det.Id.ToString()); }
public static void Insert(DBLayer.AbonementIncome.Details det) { string sql = "INSERT INTO AbonementIncome (ClientId, AbonementId, UserId, [Date], Summ, IsDeleted, ClientAbonementId) "; sql += " VALUES (" + det.ClientId.ToString() + ", " + det.AbonementId.ToString() + ", " + det.UserId.ToString() + ", '" + det.Date.ToString("yyyyMMdd") + "', " + det.Summ.ToString().Replace(",", ".") + ", 0, " + det.ClientAbonementId.ToString() + ")"; ZFort.DB.Execute.ExecuteString_void(sql); }
void frm3_SelectDateMsg(object sender, FitnessProject.ServiceForms.FrmCalendar.DateSelectEventArgs args) { DBLayer.AbonementIncome.Details det = DBLayer.AbonementIncome.GetDetails(this.Id); det.Date = args.SelectedDate; DBLayer.AbonementIncome.Update(det); LoadData(); }
void frm_SelectReasonMsg(object sender, FitnessProject.ServiceForms.ReasonEventArgs args) { DBLayer.AbonementIncome.Details det = DBLayer.AbonementIncome.GetDetails(this.Id); det.DeleteReason = args.Reason; DBLayer.AbonementIncome.SetDelete(det); LoadData(); }
public static void Update(DBLayer.AbonementIncome.Details det) { ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET [ClientId] = " + det.ClientId.ToString() + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET [AbonementId] = " + det.AbonementId.ToString() + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET [ClientAbonementId] = " + det.ClientAbonementId.ToString() + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET [UserId] = " + det.UserId.ToString() + " WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET [Date] = '" + det.Date.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString()); ZFort.DB.Execute.ExecuteString_void("UPDATE AbonementIncome SET [Summ] = " + det.Summ.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString()); }