protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_BN_WarehouseService(); foreach (DataRow item in dtSheet.Rows) { string dName = item["StoreKeeper"].ToString(); string sql = string.Format(@"SELECT UserCode FROM dbo.SYS_BN_User WHERE IsEnable = 1 AND DepartmentCode = '0107' AND UserName = '******';", dName); string hID = db.Sql(sql).QuerySingle <string>(); item["UserCode"] = hID; string isenable = item["IsEnable"].ToString(); if (isenable == "否") { item["IsEnable"] = 0; } else { item["IsEnable"] = 1; } var WarehouseCode = item["WarehouseCode"].ToString(); var Query = ParamDelete.Instance().AndWhere("WarehouseCode", WarehouseCode); service.Delete(Query); } base.OnAfterHandleExcel(ref dtSheet); }
protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_BN_UserService(); dtSheet.Columns.Add("CreatePerson", typeof(string)); dtSheet.Columns.Add("CreateTime", typeof(DateTime)); dtSheet.Columns.Add("ModifyPerson", typeof(string)); dtSheet.Columns.Add("ModifyTime", typeof(DateTime)); dtSheet.Columns.Add("UserBarcode", typeof(string)); string maxBarCode = db.Sql(@"SELECT ISNULL(MAX(UserBarcode),'USER00000000') FROM dbo.SYS_BN_User WHERE UserBarcode IS NOT NULL AND LTRIM(RTRIM(UserBarcode)) <> ''").QuerySingle <string>(); long maxNum = Convert.ToInt64(maxBarCode.Substring(4)); var userCodeAndBarcodeList = db.Sql(@"SELECT UserCode,UserBarcode FROM dbo.SYS_BN_User WHERE UserBarcode IS NOT NULL AND LTRIM(RTRIM(UserBarcode)) <> ''").QueryMany <dynamic>(); Dictionary <string, string> dicUserCodeAndBarcode = new Dictionary <string, string>(); userCodeAndBarcodeList.ForEach(item => { dicUserCodeAndBarcode.Add(item.UserCode, item.UserBarcode); }); var userName = MmsHelper.GetUserName(); var newDT = DateTime.Now; foreach (DataRow item in dtSheet.Rows) { string dName = item["DepartmentName"].ToString(); string sql = string.Format(@"select DepartmentCode from SYS_BN_Department where DepartmentName='{0}'", dName); string hID = db.Sql(sql).QuerySingle <string>(); item["DepartmentCode"] = hID; string isenable = item["IsEnable"].ToString(); if (isenable == "否") { item["IsEnable"] = 0; } else { item["IsEnable"] = 1; } var UserCode = item["UserCode"].ToString(); item["CreatePerson"] = userName; item["CreateTime"] = newDT; item["ModifyPerson"] = userName; item["ModifyTime"] = newDT; if (dicUserCodeAndBarcode.ContainsKey(UserCode)) { item["UserBarcode"] = dicUserCodeAndBarcode[UserCode]; } else { Interlocked.Increment(ref maxNum); item["UserBarcode"] = "USER" + maxNum.ToString().PadLeft(8, '0'); } var Query = ParamDelete.Instance().AndWhere("UserCode", UserCode); service.Delete(Query); } base.OnAfterHandleExcel(ref dtSheet); }
/// <summary> /// 根据主键值删除记录 /// </summary> /// <param name="value">主键值</param> /// <returns>int</returns> public int DeleteByPrimaryField(object value) { var tableAttribute = AttributeHelper.GetCustomAttribute <TableAttribute>(typeof(T)); ParamDelete p = ParamDelete.Instance().From(tableAttribute.TableName).AndWhere(tableAttribute.PrimaryField, value); return(this.Delete(p)); }
public void Delete(string id) { var service = new mms_drainpipeductService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "信息删除失败[BillNo={0}],请重试或联系管理员!", id); }
protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_BN_SupplierService(); foreach (DataRow item in dtSheet.Rows) { string dName = item["SupplierName"].ToString(); string sql = string.Format(@"select * from SYS_BN_Supplier where SupplierName='{0}'", dName); string isenable = item["IsEnable"].ToString(); if (isenable == "否") { item["IsEnable"] = 0; } else { item["IsEnable"] = 1; } var SupplierCode = item["SupplierCode"].ToString(); var Query = ParamDelete.Instance().AndWhere("SupplierCode", SupplierCode); service.Delete(Query); } base.OnAfterHandleExcel(ref dtSheet); }
public void Delete(string id) { var service = new mms_inspectionwellService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id).From("MANHOLE")); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "信息删除失败[BillNo={0}],请重试或联系管理员!", id); }
protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_PartTypeService(); foreach (DataRow item in dtSheet.Rows) { string dName = item["PartTypeCode"].ToString(); if (dName.Length > 2) { item["PPartTypeCode"] = dName.Substring(0, dName.Length - 2); var row = dtSheet.Select("PartTypeCode='" + item["PPartTypeCode"] + "'"); if (row.Length > 0) { item["PTypeName"] = row[0]["TypeName"]; } } var PartTypeCode = item["PartTypeCode"].ToString(); var Query = ParamDelete.Instance().AndWhere("PartTypeCode", PartTypeCode); service.Delete(Query); } base.OnAfterHandleExcel(ref dtSheet); }
public void PostCreateBoard(out bool result, dynamic data) { try { string SavantCode = data.SavantCode; var Item = new PRS_BlankingResultService().GetModelList(ParamQuery.Instance().AndWhere("SavantCode", SavantCode)); var ItemDetail = new PRS_BlankingPlateDetailService().GetModelList(ParamQuery.Instance().AndWhere("MainID", string.Join(",", Item.Select(a => a.ID)), Cp.In)); var list = from master in Item join detail in ItemDetail on master.ID equals detail.MainID select new { MasterID = master.ID, PartBlankingQuntity = master.PartBlankingQuntity, DetailID = detail.ID, PlateSize = detail.PlateSize }; new Mes_BlankingResultService() .Delete(ParamDelete .Instance() .AndWhere("BlankingResultID", string.Join(",", Item.Select(a => a.ID)), Cp.In)); var BoardCode = MmsHelper.GetOrderNumber("Mes_BlankingResult", "BoardCode", "XJB", "", ""); string PreCode = BoardCode.Substring(0, BoardCode.Length - 3); int StartNumber = Convert.ToInt32(BoardCode.Substring(BoardCode.Length - 3)); foreach (var item in list) { int count = item.PartBlankingQuntity; for (int i = 0; i < count; i++) { BoardCode = PreCode + StartNumber.ToString().PadLeft(3, '0'); StartNumber++; db.UseTransaction(true); db.Insert("Mes_BlankingResult") .Column("BlankingResultID", item.MasterID) .Column("IsEnable", 1) .Column("CreateTime", DateTime.Now) .Column("CreatePerson", MmsHelper.GetUserCode()) .Column("BiankingSize", item.PlateSize.ToString()) .Column("IsBlanking", 0) .Column("BlankingDetailID", item.DetailID) //.Column("BlankingType",1) .Column("BoardCode", BoardCode).Execute(); } } db.Commit(); result = true; } catch { db.Rollback(); result = false; } }
public void Delete(string id) { var service = new psi_customerService(); var result = service.Delete(ParamDelete.Instance().AndWhere("Id", id)); if (result <= 0) { throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("收货单删除失败{Id=" + id + "},请重试或联系管理员!") }); } }
public void RecursionDelete(string id) { var pQuery = ParamQuery.Instance().AndWhere("ParentCode", id); var list = base.BuilderParse(pQuery).QueryManyDynamic(); foreach (var item in list) { RecursionDelete(item.OrganizeCode); } var pDelete = ParamDelete.Instance().AndWhere("OrganizeCode", id); base.BuilderParse(pDelete).Execute(); }
public void Delete(string id) { var service = new psi_purchaseService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); if (result <= 0) { throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("采购单删除失败{BillNo=" + id + "},请重试或联系管理员!") }); } }
protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_BOMService(); foreach (DataRow item in dtSheet.Rows) { string dName = item["PartCode"].ToString(); //if ((dName == "GB/T 27") || (dName == "GB/T 5783") || (dName == "GB/T 93") ||( dName == "GB/T 119")) //{ // item["ParentCode"] = "QS160R-585-F 30"; // //var row = dtSheet.Select("PartTypeCode='" + item["PPartTypeCode"] + "'"); // //if (row.Length > 0) // //{ // // item["PTypeName"] = row[0]["TypeName"]; // //} //} string isEnable = item["IsEnable"].ToString(); if (isEnable == "否") { item["IsEnable"] = 0; } else { item["IsEnable"] = 1; } var PartCode = item["PartCode"].ToString(); var Query = ParamDelete.Instance().AndWhere("PartCode", PartCode); //service.Delete(Query); var ParentCode = item["ParentCode"].ToString(); var Query1 = ParamDelete.Instance().AndWhere("PartCode", PartCode); //service.Delete(Query); var VersionCode = item["VersionCode"].ToString(); var Query2 = ParamDelete.Instance().AndWhere("PartCode", PartCode); service.Delete(Query); } base.OnAfterHandleExcel(ref dtSheet); //GetNoInventory(); }
protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_BN_DepartmentService(); foreach (DataRow item in dtSheet.Rows) { string isworkshop = item["IsWorkshop"].ToString(); if (isworkshop == "是") { item["IsWorkshop"] = 1; } else { item["IsWorkshop"] = 0; } string isenable = item["IsEnable"].ToString(); if (isenable == "否") { item["IsEnable"] = 0; } else { item["IsEnable"] = 1; } } var list = ModelHelper <SYS_BN_Department> .DataTableToModel(dtSheet); dtSheet.Columns.Add("ParentCode", typeof(string)); //数据类型为 文本 foreach (DataRow item in dtSheet.Rows) { item["ParentCode"] = (from p in list where p.DepartmentName == item["ParentName"].ToString() select p.DepartmentCode).FirstOrDefault(); var DepartmentCode = item["DepartmentCode"].ToString(); var Query = ParamDelete.Instance().AndWhere("DepartmentCode", DepartmentCode); service.Delete(Query); } base.OnAfterHandleExcel(ref dtSheet); }
public HttpResponseMessage PostUpload(string BindTableName, string BindCode) { HttpPostedFile fileData = HttpContext.Current.Request.Files[0]; string filePath = HttpContext.Current.Server.MapPath("~/Upload/" + BindTableName + "/"); //获取需要存放的服务器文件夹地址 if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } string fileName = Path.GetFileName(fileData.FileName); //本地上传文件名称 string fileExtension = Path.GetExtension(fileName).Substring(1); //本地上传文件拓展名 string saveName = "[" + DateTime.Now.ToString("yyyyMMddhhmmss") + "]" + fileName; //时间戳前缀+本地上传文件名称 string UploadUrl = string.Format("{0}\\{1}", filePath, saveName); fileData.SaveAs(UploadUrl); new SYS_FileManageService().Delete( ParamDelete.Instance() .From("SYS_FileManage") .AndWhere("BindTableName", BindTableName) .AndWhere("BindCode", BindCode) .AndWhere("FileType", 1) ); new SYS_FileManageService().Insert( ParamInsert.Instance() .Insert("SYS_FileManage") .Column("BindTableName", BindTableName) .Column("BindCode", BindCode) .Column("FileName", fileName) .Column("FileType", 1) .Column("FileSuffix", fileExtension) .Column("FileAddress", UploadUrl) .Column("CreatePerson", "") .Column("CreateTime", DateTime.Now) ); return(new HttpResponseMessage(HttpStatusCode.OK)); }
public void RecursionDelete(string id) { db.UseTransaction(true); var pQuery = ParamQuery.Instance().Where("ParentCode", id); var list = base.BuilderParse(pQuery).QueryManyDynamic(); foreach (var item in list) { RecursionDelete(item.OrganizeCode); } db.Sql(@" -- 删除机构角色Map delete from sys_organizeRoleMap where OrganizeCode = @0; -- 删除用户机构Map delete from sys_userOrganizeMap where OrganizeCode = @0", id).Execute(); var pDelete = ParamDelete.Instance().Where("OrganizeCode", id); base.BuilderParse(pDelete).Execute(); db.Commit(); }
protected override void OnAfterHandleExcel(ref DataTable dtSheet) { var service = new SYS_PartService(); var prsbomServices = new PRS_Process_BOMService(); foreach (DataRow item in dtSheet.Rows) { var PartCode = item["InventoryCode"].ToString(); List <PRS_Process_BOM> part = prsbomServices.GetModelList(ParamQuery.Instance().AndWhere("InventoryCode", PartCode).AndWhere("IsEnable", 1)); if (part.Count > 0) { item["PartCode"] = part[part.Count - 1].PartCode; item["PartName"] = part[part.Count - 1].PartName; item["Weight"] = part[part.Count - 1].Weight; var Query = ParamDelete.Instance().AndWhere("InventoryCode", PartCode); service.Delete(Query); } string dName = item["WarehouseCode"].ToString(); string sql = string.Format(@"select WarehouseName from SYS_BN_Warehouse where WarehouseCode='{0}'", dName); string hID = db.Sql(sql).QuerySingle <string>(); item["WarehouseName"] = hID; string isSelfMade = item["IsSelfMade"].ToString(); if (isSelfMade == "否") { item["IsSelfMade"] = 0; } else { item["IsSelfMade"] = 1; } string isSupplyMade = item["IsSupplyMade"].ToString(); if (isSupplyMade == "否") { item["IsSupplyMade"] = 0; } else { item["IsSupplyMade"] = 1; } string isCastforgeMatch = item["IsCastforgeMatch"].ToString(); if (isCastforgeMatch == "否") { item["IsCastforgeMatch"] = 0; } else { item["IsCastforgeMatch"] = 1; } string isOutsouceWeiding = item["IsOutsouceWeiding"].ToString(); if (isOutsouceWeiding == "否") { item["IsOutsouceWeiding"] = 0; } else { item["IsOutsouceWeiding"] = 1; } string isElectroHydraulicMatch = item["IsElectroHydraulicMatch"].ToString(); if (isElectroHydraulicMatch == "否") { item["IsElectroHydraulicMatch"] = 0; } else { item["IsElectroHydraulicMatch"] = 1; } string isMarketMatch = item["IsMarketMatch"].ToString(); if (isMarketMatch == "否") { item["IsMarketMatch"] = 0; } else { item["IsMarketMatch"] = 1; } string isEnable = item["IsEnable"].ToString(); if (isEnable == "否") { item["IsEnable"] = 0; } else { item["IsEnable"] = 1; } //dName = item["PartTypeCode"].ToString(); //sql = string.Format(@"select PartTypeCode from SYS_PartType where TypeName='{0}'", dName); //hID = db.Sql(sql).QuerySingle<string>(); //item["PartTypeCode"] = hID; } base.OnAfterHandleExcel(ref dtSheet); }
// 删除 DELETE api/trade/send public virtual void Delete(string id) { var result = masterService.Delete(ParamDelete.Instance().Where("Jobno", id)); TradeHelper.ThrowHttpExceptionWhen(result <= 0, "单据删除失败[Jobno={0}],请重试或联系管理员!", id); }
// 删除 DELETE api/mms/send public virtual void Delete(string id) { var result = masterService.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "单据删除失败[BillNo={0}],请重试或联系管理员!", id); }