/// <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 int Delete(ParamDelete param)
{
var result = 0;
Logger("删除记录", () =>
{
db.UseTransaction(true);
var rtnBefore = this.OnBeforeDelete(new DeleteEventArgs()
{
db = db, data = param.GetData()
});
if (!rtnBefore)
{
return;
}
result = BuilderParse(param).Execute();
Msg.Set(MsgType.Success, APP.MSG_DELETE_SUCCESS);
this.OnAfterDelete(new DeleteEventArgs()
{
db = db, data = param.GetData(), executeValue = result
});
db.Commit();
});
return(result);
}
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);
}
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);
}
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);
}
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_purchaseService();
var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id));
if (result <= 0)
{
throw new HttpResponseException(new HttpResponseMessage()
{
Content = new StringContent("采购单删除失败{BillNo=" + 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_customerService();
var result = service.Delete(ParamDelete.Instance().AndWhere("Id", id));
if (result <= 0)
{
throw new HttpResponseException(new HttpResponseMessage()
{
Content = new StringContent("收货单删除失败{Id=" + 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();
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="param">ParamDelete</param>
/// <returns>int</returns>
public int Delete(ParamDelete param)
{
var result = 0;
db.UseTransaction(true);
var rtnBefore = this.OnBeforeDelete(new DeleteEventArgs()
{
db = db, data = param.GetData()
});
if (!rtnBefore)
{
return(result);
}
result = BuilderParse(param).Execute();
this.CommandResult.Set(true, APP.Msg_Delete_Success);
this.OnAfterDelete(new DeleteEventArgs()
{
db = db, data = param.GetData(), executeValue = result
});
db.Commit();
return(result);
}
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);
}
