public void SaveEndTime(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddNullableDateTime("EndTime", endTime);
if (id != 0)
{
cmd.CommandText = "update Watching set EndTime=@EndTime where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void SaveDischargeData(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("DischargeTypeId", (int)dischargeTypeId);
cmd.AddString("DischargeData", dischargeData.GetXmlString());
cmd.AddNullableDateTime("DischargeDate", dischargeDate);
if (id == 0)
{
cmd.CommandText = "insert into Patients values (DischargeTypeId,@DischargeData,@DischargeDate) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = @"update Patients set DischargeTypeId=@DischargeTypeId,DischargeData=@DischargeData,DischargeDate=@DischargeDate where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PatientId", patientId);
cmd.AddDateTime("RequestDate", requestDate);
cmd.AddNullableDateTime("ExecutionDate", executionDate);
cmd.AddString("ConsultationData", consultationData.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into PatientConsultations values (@PatientId,@RequestDate,@ExecutionDate,@ConsultationData) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PatientConsultations set PatientId=@PatientId,RequestDate=@RequestDate,ExecutionDate=@ExecutionDate,ConsultationData=@ConsultationData where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("UserId", userId);
cmd.AddDateTime("StartTime", startTime);
cmd.AddNullableDateTime("EndTime", endTime);
cmd.AddString("Data", data.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into Watching values (@UserId,@StartTime,@EndTime,@Data) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Watching set UserId=@UserId,StartTime=@StartTime,EndTime=@EndTime,Data=@Data where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Surname", surname);
cmd.AddString("Name", name);
cmd.AddString("MiddleName", middleName);
cmd.AddInt("Gender", (int)gender);
cmd.AddNullableDateTime("Birthday", birthday);
cmd.AddString("IdentificationData", identificationData.GetXmlString());
if (id == 0)
{
cmd.CommandText = "insert into PatientIdentifications values (@Surname,@Name,@MiddleName,@Gender,@Birthday,@IdentificationData) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PatientIdentifications set Surname=@Surname,Name=@Name,MiddleName=@MiddleName,Gender=@Gender,Birthday=@Birthday,IdentificationData=@IdentificationData where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn, DbTransaction trans)
{
GmCommand cmd = conn.CreateCommand(trans);
cmd.AddInt("Id", id);
cmd.AddInt("ProductId", productId);
cmd.AddDecimal("Price", price);
cmd.AddNullableDateTime("ExpiredDate", expiredDate);
cmd.AddDecimal("CurrentCount", currentCount);
cmd.AddDecimal("ReservedCount", reservedCount);
cmd.AddString("Series", series);
if (id == 0)
{
cmd.CommandText = "insert into StoreProducts values (@ProductId,@Price,@ExpiredDate,@CurrentCount,@ReservedCount,@Series) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update StoreProducts set ProductId=@ProductId,Price=@Price,ExpiredDate=@ExpiredDate,CurrentCount=@CurrentCount,ReservedCount=@ReservedCount,Series=@Series where Id=@Id";
cmd.ExecuteNonQuery();
}
}
