public static string PrepareCause(CauseObject_V_MCE_ASSET_OUTSTOCK_BACK cause, out OracleParameter[] parameters)
{
//平台自动生成代码
System.Text.StringBuilder strBuf = new System.Text.StringBuilder();
ArrayList paramList = new ArrayList();
OracleParameter param = null;
#region Push Block
if (!string.IsNullOrEmpty(cause.ASSETS_CODE))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.ASSETS_CODE ").Append((cause.ASSETS_CODE.StartsWith("%") || cause.ASSETS_CODE.EndsWith("%")) ? " like " : " = ").Append(" :C_ASSETS_CODE");
param = new OracleParameter();
param.ParameterName = ":C_ASSETS_CODE";
param.OracleType = System.Data.OracleClient.OracleType.VarChar;
param.Size = 50;
param.Value = cause.ASSETS_CODE;
paramList.Add(param);
}
if (cause.HasINValue("ASSETS_CODE"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "ASSETS_CODE"));
}
if (!string.IsNullOrEmpty(cause.BASE_ID))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.BASE_ID ").Append((cause.BASE_ID.StartsWith("%") || cause.BASE_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_BASE_ID");
param = new OracleParameter();
param.ParameterName = ":C_BASE_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.BASE_ID;
paramList.Add(param);
}
if (cause.HasINValue("BASE_ID"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "BASE_ID"));
}
if (!string.IsNullOrEmpty(cause.CARD_CODE))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.CARD_CODE ").Append((cause.CARD_CODE.StartsWith("%") || cause.CARD_CODE.EndsWith("%")) ? " like " : " = ").Append(" :C_CARD_CODE");
param = new OracleParameter();
param.ParameterName = ":C_CARD_CODE";
param.OracleType = System.Data.OracleClient.OracleType.VarChar;
param.Size = 50;
param.Value = cause.CARD_CODE;
paramList.Add(param);
}
if (cause.HasINValue("CARD_CODE"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "CARD_CODE"));
}
if (!string.IsNullOrEmpty(cause.OUT_D_ID))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.OUT_D_ID ").Append((cause.OUT_D_ID.StartsWith("%") || cause.OUT_D_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_OUT_D_ID");
param = new OracleParameter();
param.ParameterName = ":C_OUT_D_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.OUT_D_ID;
paramList.Add(param);
}
if (cause.HasINValue("OUT_D_ID"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "OUT_D_ID"));
}
if (!string.IsNullOrEmpty(cause.SPEC))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.SPEC ").Append((cause.SPEC.StartsWith("%") || cause.SPEC.EndsWith("%")) ? " like " : " = ").Append(" :C_SPEC");
param = new OracleParameter();
param.ParameterName = ":C_SPEC";
param.OracleType = System.Data.OracleClient.OracleType.VarChar;
param.Size = 50;
param.Value = cause.SPEC;
paramList.Add(param);
}
if (cause.HasINValue("SPEC"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "SPEC"));
}
if (!string.IsNullOrEmpty(cause.ID))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.ID ").Append((cause.ID.StartsWith("%") || cause.ID.EndsWith("%")) ? " like " : " = ").Append(" :C_ID");
param = new OracleParameter();
param.ParameterName = ":C_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.ID;
paramList.Add(param);
}
if (cause.HasINValue("ID"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "ID"));
}
if (!string.IsNullOrEmpty(cause.ASSETS_NAME))
{
strBuf.Append(" And V_MCE_ASSET_OUTSTOCK_BACK.ASSETS_NAME ").Append((cause.ASSETS_NAME.StartsWith("%") || cause.ASSETS_NAME.EndsWith("%")) ? " like " : " = ").Append(" :C_ASSETS_NAME");
param = new OracleParameter();
param.ParameterName = ":C_ASSETS_NAME";
param.OracleType = System.Data.OracleClient.OracleType.VarChar;
param.Size = 50;
param.Value = cause.ASSETS_NAME;
paramList.Add(param);
}
if (cause.HasINValue("ASSETS_NAME"))
{
strBuf.Append(cause.GetINSQL("V_MCE_ASSET_OUTSTOCK_BACK", "ASSETS_NAME"));
}
if (!string.IsNullOrEmpty(cause.GetCustomCondition()))
{
strBuf.Append(cause.GetCustomCondition());
}
#endregion
parameters = new OracleParameter[paramList.Count];
paramList.CopyTo(parameters);
return(strBuf.ToString());
}
