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