123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- using Common.Model;
- using CoreEntity.Entity;
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Text;
- using ZcPeng.PublicLibrary;
- namespace CoreEntity.DAL
- {
- class SupplyDAL
- {
- public static SupplyDoc getSupply(string BusinessCode)
- {
- DataTable dt = new DataTable();
- string commandTextSupp = "Select SuppliersId,DftAddress From SUPPLYDOC Where gysbh=@BusinessCode";
- string resultSupp;
- List<List<Object>> parametersSupp = new List<List<Object>>();
- if (BusinessCode != null)
- {
- parametersSupp.Add(new List<Object>() { "BusinessCode", BusinessCode });
- DataAccess.GetValues(commandTextSupp, ref dt, DataAccess.ToParameters(parametersSupp).ToArray(), out resultSupp);
- }
- if (dt.Rows.Count > 0)
- {
- List<SupplyDoc> suplist = (List<SupplyDoc>)ModelConvertHelper<SupplyDoc>.ConvertToModel(dt);
- SupplyDoc[] sups = suplist.ToArray();
- return sups[0];
- }
- return null;
- }
- public static SupplyDoc getSupplyByContactId(string ContactId)
- {
- DataTable dt = new DataTable();
- string commandTextSupp = "Select * From SUPPLYDOC " +
- "Where SuppliersId in (select BusinessId from ContactDoc where ContactId = @ContactId)";
- string resultSupp;
- List<List<Object>> parametersSupp = new List<List<Object>>();
- if (ContactId != null)
- {
- parametersSupp.Add(new List<Object>() { "ContactId", ContactId });
- DataAccess.GetValues(commandTextSupp, ref dt, DataAccess.ToParameters(parametersSupp).ToArray(), out resultSupp);
- }
- if (dt.Rows.Count > 0)
- {
- List<SupplyDoc> suplist = (List<SupplyDoc>)ModelConvertHelper<SupplyDoc>.ConvertToModel(dt);
- SupplyDoc[] sups = suplist.ToArray();
- return sups[0];
- }
- return null;
- }
- }
- }
|