public UCProductCheck(VendorProductQueryFilter filter)
{
InitializeComponent();
this.Fitler = filter;
this.spAutoMgmt.DataContext = this.Fitler;
this.isFirst = false;
m_facade = new VendorFacade();
Loaded += new RoutedEventHandler(UCProductCheck_Loaded);
}
private void hlbtnProductListEdit_Click(object sender, RoutedEventArgs e)
{
VendorAgentInfoVM agentView = this.dataGrid.SelectedItem as VendorAgentInfoVM;
VendorProductQueryFilter filter = new VendorProductQueryFilter()
{
VendorManufacturerSysNo = agentView.ManufacturerInfo.SysNo,
UserSysNo = m_sysNo,
C2SysNo = int.Parse(agentView.C2SysNo),
C3SysNo = agentView.C3SysNo,
VendorSysNo = m_vm.VendorSysNo,
ManufacturerSysNo = agentView.AgentSysNo,
};
Vendor_ExVM vm = new Vendor_ExVM()
{
VendorSysNo = filter.VendorSysNo.Value,
InvoiceType = VendorInvoiceType.NEG,
ShippingType = VendorShippingType.MET,//ShippingType = VendorShippingType.NEG,
StockType = VendorStockType.NEG
};
if (filter.VendorSysNo != null)
{
m_facade.QueryByStockShippingeInvoic(vm, (m, n) =>
{
if (n.FaultsHandle())
{
return;
}
if (n.Result.Count > 0)
{
filter.VendorSysNo = 1;
}
m_facade.GetIsAuto(filter, (o, s) =>
{
if (s.FaultsHandle())
{
return;
}
filter.IsAuto = (s.Result == 1) ? true : false;
UCProductCheck proCheck = new UCProductCheck(filter);
proCheck.Dialog = CPApplication.Current.CurrentPage.Context.Window.ShowDialog(ResVendorInfo.Info_ProductListEdit, proCheck, (obj, args) =>
{
if (args.DialogResult == DialogResultType.OK)
{
dataGrid.Bind();
}
}, new Size(800, 700));
});
});
}
}
public int GetIsAuto(VendorProductQueryFilter filter)
{
DataCommand dataCommand = DataCommandManager.GetDataCommand("External_Get_IsAuto");
dataCommand.SetParameterValue("@UserSysNo", filter.UserSysNo);
dataCommand.SetParameterValue("@ManufacturerSysNo", filter.ManufacturerSysNo);
object isAuto = dataCommand.ExecuteScalar();
if (isAuto != null && isAuto != DBNull.Value)
{
return(Convert.ToInt32(isAuto));
}
return(1);
}
public int GetIsAuto(VendorProductQueryFilter filter)
{
return(ObjectFactory <IVendorUserDA> .Instance.GetIsAuto(filter));
}
public QueryResult QueryVendroProduct(VendorProductQueryFilter filter)
{
return(QueryList <VendorProductQueryFilter>(filter, ObjectFactory <IVendorUserDA> .Instance.VendorProductQuery));
}
public void GetIsAuto(VendorProductQueryFilter filter, EventHandler <RestClientEventArgs <int> > callback)
{
string relativeUrl = "/ExternalSYSService/ExternalSYS/GetIsAuto";
restClient.Query <int>(relativeUrl, filter, callback);
}
/// <summary>
/// 查询VendorProduct
/// </summary>
/// <param name="filter"></param>
/// <param name="callback"></param>
public void QueryVendorProduct(VendorProductQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback)
{
string relativeUrl = "/ExternalSYSService/ExternalSYS/QueryVendorProduct";
restClient.QueryDynamicData(relativeUrl, filter, callback);
}
/// <summary>
/// 查询VendorProdcut
/// </summary>
/// <returns></returns>
public DataTable VendorProductQuery(VendorProductQueryFilter filter, out int TotalCount)
{
CustomDataCommand command = DataCommandManager.
CreateCustomDataCommandFromConfig("External_Query_VendorProduct");
using (DynamicQuerySqlBuilder sb = new DynamicQuerySqlBuilder(command.CommandText, command, HelpDA.ToPagingInfo(filter.PagingInfo), "a.SysNo DESC"))
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.ProductType", DbType.Int32,
"@ProductType", QueryConditionOperatorType.Equal,
0);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.Status", DbType.Int32,
"@Status", QueryConditionOperatorType.MoreThanOrEqual,
0);
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.ManufacturerSysNo", DbType.Int32,
"@ManufacturerSysNo", QueryConditionOperatorType.Equal,
filter.VendorManufacturerSysNo);
command.AddInputParameter("@UserSysNo", DbType.Int32, filter.UserSysNo);
if (filter.C3SysNo.HasValue)
{
sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"a.C3SysNo", DbType.Int32,
"@C3SysNo", QueryConditionOperatorType.Equal,
filter.C3SysNo);
}
else
{
if (filter.C2SysNo.HasValue)
{
ConditionConstructor subQueryBuilder = sb.ConditionConstructor.AddSubQueryCondition(
QueryConditionRelationType.AND,
"a.C3SysNo",
QueryConditionOperatorType.In,
@"SELECT [Category3Sysno]
FROM [OverseaContentManagement].[dbo].[V_CM_CategoryInfo]
WHERE [Category2Sysno]=@C2SysNo");
command.AddInputParameter("@C2SysNo", DbType.Int32, filter.C2SysNo);
}
}
if (!filter.IsAuto)
{
QueryConditionOperatorType ot = QueryConditionOperatorType.Exist;
if (!filter.IsMapping)
{
ot = QueryConditionOperatorType.NotExist;
}
sb.ConditionConstructor.AddSubQueryCondition(
QueryConditionRelationType.AND,
null,
ot,
@"SELECT TOP 1 1
FROM [IPP3].[dbo].VendorUser_ProductMapping
WHERE
ProductSysNo=a.sysno
AND UserSysNo=@UserSysNo
AND VendorExSysNo=@VendorExSysNo");
}
sb.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"a.MerchantSysNo",
DbType.Int32,
"@MerchantSysNo",
QueryConditionOperatorType.Equal, filter.VendorSysNo);
command.AddInputParameter(
"@VendorManufacturerSysNo",
DbType.Int32,
filter.ManufacturerSysNo);
command.CommandText = sb.BuildQuerySql();
DataTable dt = command.ExecuteDataTable();
TotalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(dt);
}
}
