public static void DeletePatch(string CompanyID, string IDs)
{
DataHelper.DeleteByIDs("Patch", IDs);
string sql = "delete companyCase_{0} where PatchID in ({1})";
DataHelper.ExecuteQuerys(string.Format(sql, CompanyID, IDs));
}
public static void UpdateCaseType(string CaseTypeName, string isdisplay, string caseTypeID)
{
string sql = "update CaseType set CaseTypeName= '{0}',isDisplay={1} where ID={2} ";
DataHelper.ExecuteQuerys(string.Format(sql, CaseTypeName, isdisplay, caseTypeID));
}
public static void InsertCaseType(string CaseTypeName, string UserID, string isdisplay)
{
string sql = "insert CaseType values( {0},'{1}',{2})";
DataHelper.ExecuteQuerys(string.Format(sql, UserID, CaseTypeName, isdisplay));
}
public static void InsertCaseTypeData(string CaseID, string CompanyID, string CaseTypeID)
{
string sql = "insert CaseTypeData values( {0},{1},{2})";
DataHelper.ExecuteQuerys(string.Format(sql, CaseID, CompanyID, CaseTypeID));
}
public static void UpdateNote(string ID, string body, string tel, string phoneType, string contactor, string contactorType, string contractResult)
{
string sql = "Update NoteTable set body='{0}',Str1='{1}', Str2='{2}',contactor='{4}',contactorType='{5}', contractResult='{6}' where ID={3}";
DataHelper.ExecuteQuerys(string.Format(sql, new object[] { body, tel, phoneType, ID, contactor, contactorType, contractResult }));
}
public static void UpdateVisitNote(string ID, string body, decimal num, string contactor, string contactorType, string contractResult)
{
string sql = "Update NoteTable set body='{0}',Num1='{1}',contactor='{3}',contactorType='{4}', contractResult='{5}' where ID={2}";
DataHelper.ExecuteQuerys(string.Format(sql, new object[] { body, num, ID, contactor, contactorType, contractResult }));
}
public static void InsertOpenedCase(string CaseID, string UserID, string CompanyID)
{
string sql = "insert openedcase values( {0},{1},{2})";
DataHelper.ExecuteQuerys(string.Format(sql, UserID, CompanyID, CaseID));
}
public static void UpdateNote(string ID, string body)
{
string sql = "Update NoteTable set body='{0}' where ID={1}";
DataHelper.ExecuteQuerys(string.Format(sql, body, ID));
}
public static void UpdateReceivedMessageStatus(string status, string where)
{
string sql = "Update MessageReceivedList set status='{0}' where {1} ";
DataHelper.ExecuteQuerys(string.Format(sql, status, where));
}
public static void DeleteOpenedCaseByCaseIDandCompanyID(string companyID, string caseID)
{
string sql = "Delete OpenedCase where companyID={0} and caseID={1}";
DataHelper.ExecuteQuerys(string.Format(sql, companyID, caseID));
}
public void UpdateCaseOwer(int ownerID, string IDs)
{
string sql = "Update {0} set OwnerID={1} where ID in ({2})";
DataHelper.ExecuteQuerys(string.Format(sql, this.TableName, ownerID, IDs));
}
public void MarkRepeatedCase(int Repeated, string IDs)
{
string sql = "Update {0} set Repeated={1} where ID in ({2})";
DataHelper.ExecuteQuerys(string.Format(sql, this.TableName, Repeated, IDs));
}
private static void DeletePatch(string IDs)
{
string sql = "Delete Patch where CompanyID in ({0})";
DataHelper.ExecuteQuerys(string.Format(sql, IDs));
}
private static void DeleteReadUsers(string IDs)
{
string sql = "Delete ReadCaseUsers where CompanyID in ({0})";
DataHelper.ExecuteQuerys(string.Format(sql, IDs));
}
public static void CreateTableColumns(string CompanyID, string ImportTableType, DataSet ds)
{
DataHelper.ExecuteQuerys(GetAddTableColumnsSql(CompanyID, ImportTableType, ds));
}