public static int RemoveDocumentProducts(GmConnection conn, int documentId)
{
GmCommand cmd = conn.CreateCommand("delete from DocumentProducts where DocumentId=@DocumentId");
cmd.AddInt("DocumentId", documentId);
return(cmd.ExecuteNonQuery());
}
internal void Remove(Context context, bool updateParentType)
{
if (types != null)
{
foreach (GType type in types)
{
type.Remove(context, false);
}
types.Clear();
types = null;
}
if (ranges != null)
{
foreach (GRange range in ranges)
{
range.Remove(context, false);
}
ranges.Clear();
ranges = null;
}
if (context != null && id != 0)
{
GmCommand cmd = context.Conn.CreateCommandById("deleteFromGisTypesWhereId");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
if (updateParentType)
{
ParentComposite.Remove(this);
}
else
{
lib.Unregister(this);
}
}
private void Remove()
{
try
{
DataRow selRow = SelectedRow;
if (selRow != null)
{
object obj = selRow[0];
if (obj is int)
{
int id = (int)obj;
using (GmConnection conn = App.CreateConnection())
{
GmCommand cmd = conn.CreateCommand("delete from Prescriptions where Id=@Id");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
}
dataTable.Rows.Remove(selRow);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
public void Save(Context context)
{
if (context.ExportMode || updateAttr[Constants.updateAttrCreated])
{
GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisRanges");
cmd.AddInt("Id", id);
cmd.AddInt("TypeId", type.Id);
context.Buf.SetRect(cmd.AddBinary("Code"), bounds);
cmd.ExecuteNonQuery();
if (!context.ExportMode)
{
updateAttr = 0;
}
}
if (context.Filter == null)
{
return;
}
if (!context.Filter.Includes(BatchLevel.Object))
{
return;
}
if (objects != null)
{
foreach (GObject obj in objects)
{
obj.Save(context);
}
}
}
internal void Remove(Context context, bool updateType)
{
if (context != null && objects == null)
{
Load(context);
}
foreach (GObject obj in objects)
{
obj.Remove(context, false);
}
if (context != null && id != 0)
{
GmCommand cmd = context.Conn.CreateCommandById("deleteFromGisRangesWhereId");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
if (updateType)
{
type.Remove(this);
}
else
{
Lib.Unregister(this);
}
Unload();
}
internal void Save(GmConnection conn, int id)
{
this.id = id;
if (id != 0)
{
foreach (DataRow dr in dt.Rows)
{
if (dr.RowState == DataRowState.Modified)
{
int groupId = (int)dr[dcId];
bool isChecked = (bool)dr[dcChecked];
GmCommand cmd = conn.CreateCommand();
if (isChecked)
{
cmd.CommandText = string.Format("insert into {0} values(@{1},@MedicamentGroupId)", tableName, fieldName);
}
else
{
cmd.CommandText = string.Format("delete from {0} where {1}=@{1} and MedicamentGroupId=@MedicamentGroupId", tableName, fieldName);
}
cmd.AddInt(fieldName, id);
cmd.AddInt("MedicamentGroupId", groupId);
cmd.ExecuteNonQuery();
}
}
dt.AcceptChanges();
}
}
public void Write(LogType logType, string msg)
{
try
{
using (GmConnection conn = Global.CreateConnection())
{
GmCommand cmd = conn.CreateCommand("insert into Log values (@Time,@SessionId,@LogTypeId,@Page,@Message)");
cmd.AddDateTime("Time", DateTime.Now);
cmd.AddInt("SessionId", (int)sessionId);
cmd.AddInt("LogTypeId", (int)logType);
cmd.AddString("Page", page);
cmd.AddString("Message", msg, MaxLength.Log.Message);
cmd.ExecuteNonQuery();
}
}
catch
{
}
switch (logType)
{
case LogType.Error:
case LogType.Exception:
if (ctl != null)
{
ctl.Page.Response.Write(string.Format("<p>{0}</p>", msg));
}
break;
}
}
public static int Remove(GmConnection conn, int id)
{
GmCommand cmd = conn.CreateCommand("delete from PatientIdentifications where Id=@Id");
cmd.AddInt("Id", id);
return(cmd.ExecuteNonQuery());
}
public static int Remove(GmConnection conn, int id)
{
GmCommand cmd = conn.CreateCommand("delete from LinkExchange where Id=@Id"); //!!!
cmd.AddInt("Id", id);
return(cmd.ExecuteNonQuery());
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("SerialNumber", serialNumber);
cmd.AddString("IssueDepartment", issueDepartment);
cmd.AddDateTime("IssueDate", issueDate);
cmd.AddString("DepartmentCode", departmentCode);
cmd.AddString("Surname", surname);
cmd.AddString("Name", name);
cmd.AddString("MiddleName", middleName);
cmd.AddInt("Gender", (int)gender);
cmd.AddDateTime("Birthday", birthday);
cmd.AddString("BirthPlace", birthPlace);
cmd.AddString("Registration", registration);
if (id == 0)
{
cmd.CommandText = "insert into Passports values (@SerialNumber,@IssueDepartment,@IssueDate,@DepartmentCode,@Surname,@Name,@MiddleName,@Gender,@Birthday,@BirthPlace,@Registration) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Passports set SerialNumber=@SerialNumber,IssueDepartment=@IssueDepartment,IssueDate=@IssueDate,DepartmentCode=@DepartmentCode,Surname=@Surname,Name=@Name,MiddleName=@MiddleName,Gender=@Gender,Birthday=@Birthday,BirthPlace=@BirthPlace,Registration=@Registration where Id=@Id";
cmd.ExecuteNonQuery();
}
}
/* public static StoreProduct GetStoreProduct(GmConnection conn, int id)
* {
* if (id == 0) return null;
* GmCommand cmd = conn.CreateCommand("select * from StoreProducts where Id=@Id");
* cmd.AddInt("Id", id);
* using (DbDataReader dr = cmd.ExecuteReader())
* {
* if (dr.Read()) return new StoreProduct(dr);
* }
* return null;
* }*/
public static int Remove(GmConnection conn, int id, DbTransaction trans)
{
GmCommand cmd = conn.CreateCommand("delete from StoreProducts where Id=@Id", trans);
cmd.AddInt("Id", id);
return(cmd.ExecuteNonQuery());
}
public void Update(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
// cmd.AddInt("RecordId", recordId);
cmd.AddDateTime("Date", date);
cmd.AddString("Name", name, MaxLength.UserInfo.Name);
cmd.AddString("Email", email, MaxLength.UserInfo.Email);
cmd.CommandText = "update UserInfo set Date=@Date,Name=@Name,Email=@Email";
if (psw.Length > 0)
{
cmd.CommandText += ",Psw=@Psw";
cmd.AddString("Psw", psw, MaxLength.UserInfo.Psw);
}
if (picture.Length > 0)
{
cmd.CommandText += ",Picture=@Picture";
cmd.AddString("Picture", picture, MaxLength.UserInfo.Picture);
}
// cmd.AddInt("UserRole", (int)userRole);
// cmd.AddInt("Status", (int)status);
cmd.CommandText += " where Id=@Id";
cmd.ExecuteNonQuery();
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name, MaxLength.BannerTopics.Name);
cmd.AddInt("B1", b1);
cmd.AddInt("B2", b2);
cmd.AddInt("B3", b3);
cmd.AddInt("B4", b4);
cmd.AddInt("B5", b5);
cmd.AddInt("B6", b6);
cmd.AddInt("B7", b7);
cmd.AddInt("B8", b8);
cmd.AddInt("B9", b9);
if (id == 0)
{
cmd.CommandText = "insert into BannerTopics values (@Name,@B1,@B2,@B3,@B4,@B5,@B6,@B7,@B8,@B9) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update BannerTopics set Name=@Name,B1=@B1,B2=@B2,B3=@B3,B4=@B4,B5=@B5,B6=@B6,B7=@B7,B8=@B8,B9=@B9 where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("PassportId", passportId);
cmd.AddInt("InsuranceId", insuranceId);
cmd.AddInt("PatientIdentificationId", patientIdentificationId);
cmd.AddInt("DoctorId", doctorId);
cmd.AddInt("DiagnosisId", diagnosisId);
cmd.AddString("PatientData", patientData.GetXmlString());
cmd.AddString("PatientDescription", patientDescription.GetXmlString());
cmd.AddDateTime("AdmissionDate", admissionDate);
cmd.AddInt("WardId", wardId);
cmd.AddInt("PatientTypeId", (int)patientTypeId);
cmd.AddString("PatientDiagnoses", patientDiagnoses.GetXmlString());
cmd.AddString("DietNumber", dietNumber);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into Patients values (@PassportId,@InsuranceId,@PatientIdentificationId,@DoctorId,@DiagnosisId,@PatientData,@PatientDescription,@AdmissionDate,@WardId,@PatientTypeId,0,null,null,@PatientDiagnoses,@DietNumber, @Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = @"update Patients set PassportId=@PassportId,InsuranceId=@InsuranceId,PatientIdentificationId=@PatientIdentificationId,DoctorId=@DoctorId,DiagnosisId=@DiagnosisId,PatientData=@PatientData,PatientDescription=@PatientDescription,AdmissionDate=@AdmissionDate,WardId=@WardId,PatientTypeId=@PatientTypeId,PatientDiagnoses=@PatientDiagnoses,DietNumber=@DietNumber, Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Remove(Context context)
{
GmCommand cmd = context.Conn.CreateCommandById("deleteFromGisLayersWhereId");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
public static void Vote(GmConnection conn, int pollAnswerId)
{
GmCommand cmd = conn.CreateCommand("update PollAnswers set Count=Count+1 where Id=@Id");
cmd.AddInt("Id", pollAnswerId);
cmd.ExecuteNonQuery();
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddInt("ParentId", (int)parentId);
cmd.AddDateTime("Date", date);
cmd.AddString("Person", person);
cmd.AddString("Title", title);
cmd.AddString("Preview", preview);
cmd.AddString("Header", header);
cmd.AddString("Text", text);
cmd.AddString("Company", company);
cmd.AddInt("CityId", cityId);
cmd.AddString("Address", address);
cmd.AddString("Phone", phone);
cmd.AddString("Link", link);
cmd.AddString("Email", email);
cmd.AddInt("Status", (int)status);
cmd.AddString("Tag", tag);
cmd.AddBoolean("IsGroup", isGroup);
if (id == 0)
{
cmd.CommandText = "insert into Articles values (@ParentId,@Date,@Person,@Title,@Preview,@Header,@Text,@Company,@CityId,@Address,@Phone,@Link,@Email, @Status,@Tag,@IsGroup) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Articles set ParentId=@ParentId,Date=@Date,Person=@Person,Title=@Title,Preview=@Preview,Header=@Header,Text=@Text,Company=@Company,CityId=@CityId,Address=@Address,Phone=@Phone,Link=@Link,Email=@Email,Status=@Status, Tag=@Tag, IsGroup=@IsGroup where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public static int SetStatus(GmConnection conn, int id, Status status)
{
GmCommand cmd = conn.CreateCommand("update Patients set Status=@Status where Id=@Id");
cmd.AddInt("Id", id);
cmd.AddInt("Status", (int)status);
return(cmd.ExecuteNonQuery());
}
public void UpdateState(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand("update Document set DocumentStateId=@DocumentStateId where DocumentId=@DocumentId");
cmd.AddInt("DocumentId", DocumentId);
cmd.AddInt("DocumentStateId", DocumentStateId);
cmd.ExecuteNonQuery();
}
public void Remove(Context context)
{
if (id < 0)
{
return;
}
GmCommand cmd = context.Conn.CreateCommandById("deleteFromGisBgWhereId");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
public void UpdateTerminalId()
{
using (GmConnection conn = App.ConnectionFactory.CreateConnection())
{
GmCommand cmd = conn.CreateCommand("update [User] set TerminalId=@TerminalId where UserCode=@UserId");
cmd.AddInt("TerminalId", TerminalId);
cmd.AddInt("UserId", UserId);
cmd.ExecuteNonQuery();
}
}
public void Remove(Context context)
{
if (this.IsOverall)
{
return;
}
GmCommand cmd = context.Conn.CreateCommandById("deleteFromGisViewsWhereId");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
public void UpdateResume(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Resume", resume);
if (id != 0)
{
cmd.CommandText = "update Candidates set Resume=@Resume where Id=@Id";
cmd.ExecuteNonQuery();
}
}
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();
}
}
internal void Remove(Context context, bool updateRange)
{
if (context != null)
{
GmCommand cmd = context.Conn.CreateCommandById("deleteFromGisObjectsWhereId");
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
if (updateRange)
{
range.Remove(this);
Lib.SetChanged();
}
}
private void BackupDb(string filePath)
{
string dbName = App.AppConfig.GetDbName();
if (dbName.Length == 0)
{
throw new HospitalDepartmentException("Не найдено имя базы данных.");
}
using (GmConnection conn = App.CreateConnection())
{
string cmdText = string.Format("BACKUP DATABASE {0} TO DISK='{1}'", dbName, filePath);
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.ExecuteNonQuery();
// SqlServerBackup bk=new SqlServerBackup(conn.DbConnection as SqlConnection);
// bk.BackupDatabase(dbName, dlgBackup.FileName);
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name);
cmd.AddInt("Status", (int)status);
if (id == 0)
{
cmd.CommandText = "insert into Medicaments values (@Name,@Status) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update Medicaments set Name=@Name,Status=@Status where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddString("Name", name);
cmd.AddString("ShortName", shortName);
if (id == 0)
{
cmd.CommandText = "insert into PrescriptionTypes values (@Name,@ShortName) select @@Identity";
id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update PrescriptionTypes set Name=@Name,ShortName=@ShortName where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(GmConnection conn)
{
GmCommand cmd = conn.CreateCommand();
cmd.AddInt("Id", id);
cmd.AddDateTime("Date", date);
cmd.AddString("Text", text, MaxLength.LinkExchangePages.Text);
if (id == 0)
{
cmd.CommandText = "insert into LinkExchange values (@Id,@Date,@Text)";
// id = (int)(decimal)cmd.ExecuteScalar();
}
else
{
cmd.CommandText = "update LinkExchange set Date=@Date,Text=@Text where Id=@Id";
cmd.ExecuteNonQuery();
}
}
public void Save(Context context)
{
if (this.IsOverall)
{
return;
}
if (context.ExportMode || updateAttr[Constants.updateAttrCreated])
{
GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisViews");
cmd.AddInt("Id", id);
cmd.AddInt("Attr", attr);
cmd.AddString("Name", name, MaxLength.Name);
context.Buf.SetIntArray(cmd.AddBinary("Code"), GetIntArray());
cmd.ExecuteNonQuery();
}
else if (updateAttr.NonEmpty)
{
GmCommand cmd = context.Conn.CreateCommand();
string cmdText = "";
if (updateAttr[(int)ViewField.Attr])
{
cmdText += "Attr= @Attr,";
cmd.AddInt("Attr", attr);
}
if (updateAttr[(int)ViewField.Name])
{
cmdText += "Name= @Name,";
cmd.AddString("Name", name, MaxLength.Name);
}
if (updateAttr[(int)ViewField.Code])
{
cmdText += "Code= @Code,";
context.Buf.SetIntArray(cmd.AddBinary("Code"), this.GetIntArray());
}
Geomethod.StringUtils.RemoveLastChar(ref cmdText);
cmd.CommandText = "update gisViews set " + cmdText + " where Id= @Id";
cmd.AddInt("Id", id);
cmd.ExecuteNonQuery();
}
if (!context.ExportMode)
{
updateAttr = 0;
}
}
