2018-07-01B

2018 年 7 月 1 日2018 年 7 月 1 日 by 沧海之树 In 工作

select * from bh20180522.dbo.CardNameItemDetails

select * from khzf.dbo.UpdateManage

update khzf.dbo.UpdateManage set NEW_VERSION='1',FILENAME='HairImplant.exe',FILE_DIR='c:\khzf\',PUBLISH_DIR='c:\khzf\植发HIS\',SYS_NAME='植发HIS',SERVER_USERNAME='implanthis',SERVER_PWD='implanthis'

 

 

 

delete from khzf.dbo.receivesmsdetails; --短消息明细
delete from khzf.dbo.sendsmsdetails;
delete from khzf.dbo.ExcuteRecordTotalPaymodeDetails; --项目执行总表 支付方式对应金额
delete from khzf.dbo.ExcuteRecordTotal; --项目执行总表
delete from khzf.dbo.UnExcuteTotal; --未执行总金额
delete from khzf.dbo.MemberCardChangeRecord; --会员卡更换记录
delete from khzf.dbo.CustomerRequstMemberCardTable; --客户会员卡申请表信息
delete from khzf.dbo.MemberCardInfo;
delete from khzf.dbo.IntegrationDetails;
delete from khzf.dbo.IntegrationUseLog;
delete from khzf.dbo.integrationgeneratelog;
delete from khzf.dbo.MemberCardRequestChangeRank;
delete from khzf.dbo.MemberCardHandle;
delete from khzf.dbo.PrepaymentBalanceLog;
delete from khzf.dbo.PrepaymentDetails;
delete from khzf.dbo.MoneyCardDetails;
delete from khzf.dbo.StatusOfCustomer;
delete from khzf.dbo.SuccessOfCustomer;
delete from khzf.dbo.AccountsOfCustomer;
delete from khzf.dbo.AddCustomerInfo;
delete from khzf.dbo.ArrearsCardPaymentDetails;
delete from khzf.dbo.ArrearsCardPaymentInfo;
delete from khzf.dbo.PayModeForOpenCard;
delete from khzf.dbo.ArrearsPaymentDetails;
delete from khzf.dbo.ArrearsPaymentInfo;
delete from khzf.dbo.PayModeForPrePayment;
delete from khzf.dbo.BlackCustomer;
delete from khzf.dbo.CallDetails;
delete from khzf.dbo.sendsmsdetails;
delete from khzf.dbo.CallRecordDetails;
delete from khzf.dbo.CertainDocStatusLog;
delete from khzf.dbo.ChangeConsultorForCustomerLog;
delete from khzf.dbo.ChargeForCertainDocDetails;
delete from khzf.dbo.ChargeForCertainDocInfo;
delete from khzf.dbo.ChargeForCertainDocStatusLog;
delete from khzf.dbo.ChargeForMHDetails;
delete from khzf.dbo.ChargeForMHInfo;
delete from khzf.dbo.ConsultingDocStatusLog;
delete from khzf.dbo.Reservation;
delete from khzf.dbo.ReservationNumber;
delete from khzf.dbo.ReservationNumberSendDetails;
delete from khzf.dbo.ConsultingProjects_Log;
delete from khzf.dbo.ConsultingProjects;
delete from khzf.dbo.ConsultingInfo;
delete from khzf.dbo.ConsumptionIntention;
delete from khzf.dbo.CustomerAccounts;
delete from khzf.dbo.CustomerAppendInfo;
delete from khzf.dbo.CustomerAssistProjectDetails;
delete from khzf.dbo.CustomerAssistProjectInfo;
delete from khzf.dbo.CustomerBaseInfo_Log;
delete from khzf.dbo.CustomerCategory;
delete from khzf.dbo.CustomerCategoryChangeLog;
delete from khzf.dbo.CustomerComeLog; --客户来院记录表
delete from khzf.dbo.ExcuteAssistProjectInfo;
delete from khzf.dbo.ExcuteCancelDetails;
delete from khzf.dbo.ExcuteDetails;
delete from khzf.dbo.ExcuteDocPrintInfo;
delete from khzf.dbo.ExcuteFinishItem;
delete from khzf.dbo.ExcuteInjectionPlaceDetails;
delete from khzf.dbo.ExcuteInfo; --整形项目表
delete from khzf.dbo.ExcuteStartItem;
delete from khzf.dbo.ExcutionPlanExcuteDate;
delete from khzf.dbo.ExcutionStatus;
delete from khzf.dbo.ExcutionStatusChange;
delete from khzf.dbo.CustomerForCustomerService;
delete from khzf.dbo.CustomerForDepartment;
delete from khzf.dbo.CustomerForGuideMedical;
delete from khzf.dbo.CustomerForScene;
delete from khzf.dbo.CustomerForTMK;
delete from khzf.dbo.CustomerLevelDetails;
delete from khzf.dbo.CustomerStatusChangeLog;
delete from khzf.dbo.CustomerStatusInfo;
delete from khzf.dbo.CustomerStatusRecordDetails;
delete from khzf.dbo.CustomerStatusRecordInfo;
delete from khzf.dbo.CustomerTreatmentImage;
delete from khzf.dbo.DefaultScenePlanResultForSubItemCategory;
delete from khzf.dbo.DefaultScenePlanResultsForTopItemCategory;
delete from khzf.dbo.DefaultPlanResultsInfo;
delete from khzf.dbo.DepartmentForConsulting;
delete from khzf.dbo.DepartmentGetMedicine;
delete from khzf.dbo.DepartmentGetMedicineInfo;
delete from khzf.dbo.EducationInfo;
delete from khzf.dbo.EmployeeCallCenter;
delete from khzf.dbo.GoodsOutKeepAccounts;
delete from khzf.dbo.GoodsOutKeepAccountsNEW;
delete from khzf.dbo.MedicineOutKeepAccounts;
delete from khzf.dbo.MedicineOutKeepAccountsNEW;
delete from khzf.dbo.GoodsCheckOut;
delete from khzf.dbo.GoodsLastestStock;
delete from khzf.dbo.GoodsINDetails; --采购入库明细
delete from khzf.dbo.GoodsINInfo; --采购入库表头
delete from khzf.dbo.GoodsOutDetails; --物资出库记录明细
delete from khzf.dbo.GoodsOutInfo; --物资出库记录
delete from khzf.dbo.GuideLog;
delete from khzf.dbo.ImportAnalysisNetCustomer;
delete from khzf.dbo.IntegrationBalance; --客户的积分余额
delete from khzf.dbo.IntegrationGenerateLog; --会员的积分产生记录
delete from khzf.dbo.IntegrationINOUT;
delete from khzf.dbo.IntegrationScheme; --积分方案信息
delete from khzf.dbo.IntegrationSchemeDetails;
delete from khzf.dbo.IntegrationType; --积分类型
delete from khzf.dbo.ItemCommissionScheme;
delete from khzf.dbo.ItemForIntegrationScheme; --积分方案内容
delete from khzf.dbo.ItemOperationSetupInfo; --项目后续操作设置表
delete from khzf.dbo.LeaderInfo;
delete from khzf.dbo.MedicalPhotoDetails;
delete from khzf.dbo.MedicalPhotoInfo; --照片
delete from khzf.dbo.MedicineCheckout;
delete from khzf.dbo.MedicineKeepAccountStock;
delete from khzf.dbo.MedicineLastestStock;
delete from khzf.dbo.StorageMedicine;
delete from khzf.dbo.StorageMedicineInfo;
delete from khzf.dbo.MedicineOutDetails;
delete from khzf.dbo.MedicineOutInfo;
delete from khzf.dbo.medicinepricechange;
delete from khzf.dbo.MemberShipCardInfo;
delete from khzf.dbo.MergerCustomerBaseInfo;
delete from khzf.dbo.MoneyCardBalanceLog;
delete from khzf.dbo.ReturnMoneyForMHDetails;
delete from khzf.dbo.ReturnMoneyForMHInfo;
delete from khzf.dbo.MorHKeepAccountsDetails; --住院或药品划价明细
delete from khzf.dbo.MorHKeepAccountsInfo; --住院或药品划价信息
delete from khzf.dbo.HospitalizedInfo;
delete from khzf.dbo.NewNetChannelForCustomer;
delete from khzf.dbo.OralExcuteInfo;
delete from khzf.dbo.OtherOutDetails;
delete from khzf.dbo.OtherOutInfo;
delete from khzf.dbo.PlanExcuteDateChange;
delete from khzf.dbo.PrePaymentRecharge;
delete from khzf.dbo.PrescriptionDetails;
delete from khzf.dbo.PrescriptionInfo;
delete from khzf.dbo.ProjectsDiscountsDetails; --折扣表
delete from khzf.dbo.ProjectDiscountsInfo;
delete from khzf.dbo.ProjectsChargeDetails;
delete from khzf.dbo.ProjectsChargeInfo;
delete from khzf.dbo.ResumeCheckDate;
delete from khzf.dbo.ReturnMedicineDetails;
delete from khzf.dbo.ReturnMedicineInfo;
delete from khzf.dbo.ReturnMoneyApply;
delete from khzf.dbo.ReturnMoneyForCardDetails;
delete from khzf.dbo.ReturnMoneyForCardInfo;

delete from khzf.dbo.FinanceTotalDetails; --财务明细表

delete from khzf.dbo.FinanceTotal;

delete from khzf.dbo.ReturnMoneyForCertainDocDetails;
delete from khzf.dbo.ReturnMoneyForCertainDoc;
delete from khzf.dbo.ReturnMoneyForPrePaymentDetails;
delete from khzf.dbo.ReturnMoneyForPrePaymentInfo;
delete from khzf.dbo.ReturnMoneyInfo;
delete from khzf.dbo.ReturnMoneyMode;
delete from khzf.dbo.ReturnVisitRecord;
delete from khzf.dbo.RPMedicineDetails;

delete from khzf.dbo.ScenePlanResultForSubItemCategory;
delete from khzf.dbo.ScenePlanResultsForTopItemCategory;
delete from khzf.dbo.StoreHouse_AmountIncome;
delete from khzf.dbo.StoreHouse_ComeDataDetails;
delete from khzf.dbo.StoreHouse_ComeDataInfo;
delete from khzf.dbo.StoreHouse_DeptAmountDetails;
delete from khzf.dbo.StoreHouse_DeptAmountInfo;
delete from khzf.dbo.StoreHouse_SceneDeptResultsDetails;
delete from khzf.dbo.StoreHouse_SceneDeptResultsInfo;
delete from khzf.dbo.StoreHouseInfo;
delete from khzf.dbo.StoreHouseOutDetails;
delete from khzf.dbo.StoreHouseOutInfo;
delete from khzf.dbo.StoreHouseToDepartmentDetails;
delete from khzf.dbo.StoreHouseToDepartmentInfo;
delete from khzf.dbo.PlanResultsInfo;
delete from khzf.dbo.WaitReturnVisitCustomer;
delete from khzf.dbo.WaitReturnVisitCustomerInfo;
delete from khzf.dbo.TrackedRecord;
delete from khzf.dbo.WaitTrackCustomer;

delete from khzf.dbo.ItemReparationTotal;
delete from khzf.dbo.UnExcuteBalanceTotal;
delete from khzf.dbo.ItemReturnMoneyTotal;
delete from khzf.dbo.ItemExcutedTotal;

delete from khzf.dbo.CertainDocDetailsTotalRecord;
delete from khzf.dbo.PackageItemInfo;
delete from khzf.dbo.CustomerConsumptionDetails;
delete from khzf.dbo.CustomerConsumptionForIntegration;
delete from khzf.dbo.CustomerConsumptionInfo;
delete from khzf.dbo.ArrearsDetails;
delete from khzf.dbo.CardInfo;
delete from khzf.dbo.CustomerPhoneNumberUpdateDetails;
delete from khzf.dbo.CustomerPhoneNumber;
delete from khzf.dbo.CustomerRegisterType;
delete from khzf.dbo.CustomerBaseInfoUpdateDetails; --客户信息更新记录
delete from khzf.dbo.ArrearsOfAccount;
delete from khzf.dbo.CustomerComplaintsProcessRecord;
delete from khzf.dbo.CustomerComplaints;

delete from khzf.dbo.CustomerCarInfo;
delete from khzf.dbo.CustomerPhoneNumber;
delete from khzf.dbo.CustomerBaseInfo; --客户基本信息表

delete from khzf.dbo.CustomerComplaintsArchive; --投诉
delete from khzf.dbo.employee where id <> '00001'; --员工表(管理员除外)
delete from khzf.dbo.PackageItemDetails;
delete from khzf.dbo.PackageItemInfo;

delete from BSItemPriceList_ItemInfoAppendInfo;
delete from khzf.dbo.MemberScontoForDeptDetails;
delete from CardNameItemDetails;
delete from khzf.dbo.ItemForConsultingCategory;
delete from khzf.dbo.ItemInfo;
delete from khzf.dbo.ItemCategory;

delete from khzf.dbo.IncomeCategory;

delete from khzf.dbo.medicineinfo;
delete from khzf.dbo.category;
delete from khzf.dbo.MedicineFactoryInfo;
delete from khzf.dbo.Supply;