public int DeleteByTrans2(CauseObject_MCE_B_ASSETS_AFFIX cause, IDbTransaction transaction)
{
if (LocalMode)
{
return(HelperObject_MCE_B_ASSETS_AFFIX.Delete(cause, transaction));
//平台自动生成代码
}
else
{
throw new InvalidConstraintException();
}
}
public DisplayObject_MCE_B_ASSETS_AFFIX[] Query(CauseObject_MCE_B_ASSETS_AFFIX cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_AFFIX.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_AFFIX> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_AFFIX>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public BizLogicMsg Delete(CauseObject_MCE_B_ASSETS_AFFIX cause)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
int amount = HelperObject_MCE_B_ASSETS_AFFIX.Delete(cause, transaction);
//平台自动生成代码
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_AFFIX> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_AFFIX>(ServiceUri))
{
return(smgr.Service.Delete(cause));
}
}
}
private string GectAssetsAffixCode(string assets_id)
{
string strAffixCode = "";
string strCode = "";
EntityObject_MCE_B_ASSETS obj = new EntityObject_MCE_B_ASSETS();
if (!string.IsNullOrEmpty(assets_id))
{
obj.ID = assets_id;
obj = HelperObject_MCE_B_ASSETS.Get(obj);
if (obj != null)
{
strCode = obj.ASSETS_CODE;
}
}
int code = 1;
var cause = new CauseObject_MCE_B_ASSETS_AFFIX();
cause.SetCustomCondition(" and MCE_B_ASSETS_AFFIX.CODE like '" + strCode + "%'");
var list = BizLogicObject_MCE_B_ASSETS_AFFIX.Proxy.Query(cause);
if (list != null && list.Length > 0)
{
var s_code = list.Max(p => p.CODE);
var rightCode = s_code.Replace(strCode, "").TrimStart('0');
code = int.Parse(rightCode) + 1;
}
strAffixCode = strCode + (code).ToString().PadLeft(3, '0');
return(strAffixCode);
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE";
//PagingParamter pager = new PagingParamter();
//pager.PageSize = int.MaxValue;
//pager.PageIndex = 0;
StringBuilder strCondition = new StringBuilder();
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
CauseObject_MCE_B_ASSETS_AFFIX p = new CauseObject_MCE_B_ASSETS_AFFIX();
p.ASSETS_ID = request["id"];
if (!string.IsNullOrEmpty(request["condition"]))//
{
strCondition.Append(" and (MCE_B_ASSETS_AFFIX.CODE like '%" + request["condition"].ToString().Trim() + "%' or MCE_B_ASSETS_AFFIX.NAME like '%" + request["condition"].ToString().Trim() + "%' or MCE_B_ASSETS_AFFIX.SPEC like '%" + request["condition"].ToString().Trim() + "%' )");
}
if (!string.IsNullOrEmpty(strCondition.ToString()))
{
p.SetCustomCondition(strCondition.ToString());
}
DisplayObject_MCE_B_ASSETS_AFFIX[] list = BizLogicObject_MCE_B_ASSETS_AFFIX.Proxy.Query(p, null, orderBy);
if (list != null && list.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_AFFIX item in list)
{
string strFiles = "";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = item.ID;
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_AFFIX";
DisplayObject_COM_FILE[] listCOM_FILE = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE);
if (listCOM_FILE != null && listCOM_FILE.Length > 0)
{
foreach (DisplayObject_COM_FILE file in listCOM_FILE)
{
if (!string.IsNullOrEmpty(file.SERVER_NAME))
{
strFiles = strFiles + file.SERVER_NAME + "/" + file.CLIENT_NAME + ",";
}
}
strFiles = strFiles.TrimEnd(',');
}
item.BACKUP1 = strFiles;
item.BACKUP2 = BarCodeHelper.GenerateBarCode(item.CODE);
}
}
//JSON_PAGER jsonPager = new JSON_PAGER();
//jsonPager.total = pager.TotalRecords;
//jsonPager.rows = list;
jsonMsg.Message = list;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
