public DeliverChargeInfo GetChargeParmOfWeight(int areaType, int deliverType)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@AreaType", DbType.Int32, areaType);
cmdParams.AddInParameter("@DeliverType", DbType.Int32, deliverType);
using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Shop_DeliverCharge_GetChargeParmOfWeight", cmdParams))
{
if (reader.Read())
{
DeliverChargeInfo deliverChargeInfo = new DeliverChargeInfo();
DeliverChargeInfoFromrdr(deliverChargeInfo, reader);
return(deliverChargeInfo);
}
return(new DeliverChargeInfo(true));
}
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static LogEntity GetEntityFromrdr(NullableDataReader rdr)
{
LogEntity info = new LogEntity();
info.LogID = rdr.GetInt32("LogID");
info.Category = rdr.GetInt32("Category");
info.Priority = rdr.GetInt32("Priority");
info.Title = rdr.GetString("Title");
info.Message = rdr.GetString("Message");
info.Timestamp = rdr.GetNullableDateTime("Timestamp");
info.UserName = rdr.GetString("UserName");
info.UserIP = rdr.GetString("UserIP");
info.Source = rdr.GetString("Source");
info.ScriptName = rdr.GetString("ScriptName");
info.PostString = rdr.GetString("PostString");
return(info);
}
public string GetStatusCodeToProcessStatusCode(int flowId, string rolesId)
{
StringBuilder sb = new StringBuilder();
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@FlowID", DbType.Int32, flowId);
string strCommand = "SELECT StatusCode FROM PE_ProcessStatusCode WHERE FlowID = @FlowID AND ProcessID IN (SELECT ProcessID FROM PE_Process_Roles WHERE FlowID = @FlowID AND RoleID IN(" + rolesId + "))";
using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
{
while (reader.Read())
{
StringHelper.AppendString(sb, reader.GetInt32("StatusCode").ToString());
}
}
return(sb.ToString());
}
private static ArrayList GetIncomeAndPayout(string sql)
{
ArrayList list = new ArrayList();
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(sql))
{
if (reader.Read())
{
list.Add(reader[0]);
}
if (reader.NextResult() && reader.Read())
{
list.Add(reader[0]);
}
}
return(list);
}
public IList <ProductPriceInfo> GetProductPrice(int productId, string tableName, string property)
{
IList <ProductPriceInfo> list = new List <ProductPriceInfo>();
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@TableName", DbType.String, tableName);
cmdParams.AddInParameter("@ProductId", DbType.Int32, productId);
cmdParams.AddInParameter("@Property", DbType.String, property);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT ID, GroupID, Price, PropertyValue FROM PE_ProductPrice WHERE TableName = @TableName AND ProductId = @ProductId AND PropertyValue = @Property", cmdParams))
{
while (reader.Read())
{
list.Add(ProductPriceFromrdr(reader));
}
}
return(list);
}
private static DeliverItemInfo DeliverItemFromrdr(NullableDataReader rdr)
{
DeliverItemInfo info = new DeliverItemInfo();
info.DeliverId = rdr.GetInt32("DeliverID");
info.OrderId = rdr.GetInt32("OrderID");
info.DeliverDate = rdr.GetDateTime("DeliverDate");
info.DeliverDirection = rdr.GetInt32("DeliverDirection");
info.HandlerName = rdr.GetString("HandlerName");
info.CourierId = rdr.GetInt32("CourierId");
info.ExpressNumber = rdr.GetString("ExpressNumber");
info.Inputer = rdr.GetString("Inputer");
info.Remark = rdr.GetString("Remark");
info.Received = rdr.GetBoolean("Received");
info.Memo = rdr.GetString("Memo");
return(info);
}
public UserOrderCommonInfo GetDownloadInfo(string userName, int orderItemId)
{
UserOrderCommonInfo info = new UserOrderCommonInfo();
string strSql = "SELECT I.* FROM PE_Orders O INNER JOIN PE_OrderItem I ON O.OrderID = I.OrderID WHERE O.UserName = @UserName AND EnableDownload = 1 AND I.ItemID = @ItemID";
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@UserName", DbType.String, userName);
cmdParams.AddInParameter("@ItemID", DbType.Int32, orderItemId);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
if (reader.Read())
{
return(GetUserOrderCommonInfo(reader));
}
return(new UserOrderCommonInfo(true));
}
}
private static AdministratorInfo GetAdminInfoFromrdr(NullableDataReader rdr)
{
AdministratorInfo info = new AdministratorInfo();
info.AdminId = rdr.GetInt32("AdminId");
info.AdminName = rdr.GetString("AdminName");
info.AdminPassword = rdr.GetString("AdminPassword");
info.UserName = rdr.GetString("UserName");
info.EnableMultiLogOn = rdr.GetBoolean("EnableMultilogin");
info.RndPassword = rdr.GetString("RndPassword");
info.LogOnTimes = rdr.GetInt32("LoginTimes");
info.LastLogOnIP = rdr.GetString("LastLoginIp");
info.LastLogOnTime = rdr.GetNullableDateTime("LastLoginTime");
info.LastLogOffTime = rdr.GetNullableDateTime("LastLogoutTime");
info.LastModifyPasswordTime = rdr.GetNullableDateTime("LastModifyPasswordTime");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static BankEntity GetEntityFromrdr(NullableDataReader rdr)
{
BankEntity info = new BankEntity();
info.BankID = rdr.GetInt32("BankID");
info.BankShortName = rdr.GetString("BankShortName");
info.BankName = rdr.GetString("BankName");
info.Accounts = rdr.GetString("Accounts");
info.CardNum = rdr.GetString("CardNum");
info.HolderName = rdr.GetString("HolderName");
info.BankIntro = rdr.GetString("BankIntro");
info.BankPic = rdr.GetString("BankPic");
info.OrderSort = rdr.GetInt32("OrderSort");
info.IsDefault = rdr.GetBoolean("IsDefault");
info.IsDisabled = rdr.GetBoolean("IsDisabled");
return(info);
}
private static SpecialCategoryInfo SpecialCategoryInfoFromrdr(NullableDataReader rdr)
{
SpecialCategoryInfo info = new SpecialCategoryInfo();
info.SpecialCategoryId = rdr.GetInt32("SpecialCategoryID");
info.SpecialCategoryDir = rdr.GetString("SpecialCategoryDir");
info.SpecialCategoryName = rdr.GetString("SpecialCategoryName");
info.SpecialTemplatePath = rdr.GetString("SpecialTemplatePath");
info.SearchTemplatePath = rdr.GetString("SearchTemplatePath");
info.OrderId = rdr.GetInt32("OrderId");
info.OpenType = rdr.GetBoolean("OpenType");
info.Description = rdr.GetString("Description");
info.IsCreateHtml = rdr.GetBoolean("IsCreateHtml");
info.PagePostfix = rdr.GetString("PagePostfix");
info.NeedCreateHtml = rdr.GetBoolean("NeedCreateHtml");
return(info);
}
private static SaleCountInfo SaleCountInfoFromrdataReader(NullableDataReader dataReader, string infoType)
{
SaleCountInfo info = new SaleCountInfo();
info.ProductId = dataReader.GetInt32("ProductID");
info.ProductName = dataReader.GetString("ProductName");
info.Unit = dataReader.GetString("Unit");
info.TableName = dataReader.GetString("TableName");
if (infoType == "NoDeliver")
{
info.NoDeliverAmount = dataReader.GetInt32("NoDeliverAmount");
return(info);
}
info.TotalAmount = dataReader.GetInt32("tAmount");
info.SubTotal = dataReader.GetDecimal("tSubTotal");
return(info);
}
public IList <RoleInfo> GetRoleListByFlowIdAndProcessId(int flowId, int processId)
{
string strSql = "SELECT * FROM PE_Roles AS U WHERE (NOT EXISTS(SELECT NULL AS Exp FROM PE_Process_Roles AS P WHERE P.FlowId = @FlowId AND P.ProcessId<>@ProcessId AND U.RoleId = P.RoleId))";
IList <RoleInfo> list = new List <RoleInfo>();
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@FlowId", DbType.Int32, flowId);
cmdParams.AddInParameter("@ProcessId", DbType.Int32, processId);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
while (reader.Read())
{
list.Add(GetRoleInfoFromrdr(reader));
}
}
return(list);
}
private static TransferLogInfo TransferLogFromrdr(NullableDataReader rdr)
{
TransferLogInfo info = new TransferLogInfo();
info.TransferLogId = rdr.GetInt32("TransferLogID");
info.OrderId = rdr.GetInt32("OrderId");
info.TransferTime = rdr.GetNullableDateTime("TransferTime");
info.Poundage = rdr.GetDecimal("Poundage");
info.OwnerUserName = rdr.GetString("OwnerUserName");
info.TargetUserName = rdr.GetString("TargetUserName");
info.PayerUserName = rdr.GetString("PayerUserName");
info.Inputer = rdr.GetString("Inputer");
info.Remark = rdr.GetString("Remark");
info.UserName = rdr.GetString("UserName");
info.OrderNum = rdr.GetString("OrderNum");
return(info);
}
public static List <NovedadDocumentacion> Traer_Documentacion(long idPrestado, DateTime?F_Recep_Desde, DateTime?F_Recep_Hasta, int?idEstado_documentacion,
long?id_Novedad, long?id_Beneficiario)
{
string sql = "NovedadesDocumentacion_TXEstado";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
List <NovedadDocumentacion> rta = new List <NovedadDocumentacion>();
db.AddInParameter(dbCommand, "@idPrestador", DbType.Int64, idPrestado);
db.AddInParameter(dbCommand, "@fRecepcion_desde", DbType.String, F_Recep_Desde.HasValue ? F_Recep_Desde.Value.ToString("yyyyMMdd") : null);
db.AddInParameter(dbCommand, "@fRecepcion_Hasta", DbType.String, F_Recep_Hasta.HasValue ? F_Recep_Hasta.Value.ToString("yyyyMMdd") : null);
db.AddInParameter(dbCommand, "@idEstadoDocumentacion", DbType.Int32, !idEstado_documentacion.HasValue ? null : idEstado_documentacion.Value.ToString());
db.AddInParameter(dbCommand, "@idNovedad", DbType.Int64, id_Novedad.HasValue ? id_Novedad.Value.ToString(): null);
db.AddInParameter(dbCommand, "@idBeneficiario", DbType.Int64, id_Beneficiario.HasValue ? id_Beneficiario.Value.ToString(): null);
try
{
using (NullableDataReader dr = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (dr.Read())
{
rta.Add(new NovedadDocumentacion(Convert.ToInt64(dr["idNovedad"]),
new EstadoDocumentacion(Convert.ToInt32(dr["idEstadoDocumentacion"]),
dr["descripcion"].ToString(), false, false, false, false),
new Beneficiario(Convert.ToInt64(dr["IdBeneficiario"]), Convert.ToInt64(dr["Cuil"]),
dr["ApellidoNombre"].ToString()),
Convert.ToDouble(dr["montoPrestamo"]), Convert.ToDateTime(dr["fRecepcion"]),
string.IsNullOrEmpty(dr["nroCaja"].ToString())? new int() : Convert.ToInt32(dr["nroCaja"]),
string.IsNullOrEmpty(dr["CantCuotas"].ToString()) ? new int() : Convert.ToInt32(dr["CantCuotas"])
));
}
}
return(rta);
}
catch (Exception err)
{
log.Error(string.Format("{0}->{1}->Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), err.Source, err.Message));
throw err;
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public DataTable GetShopModelListByNodeId(int nodeId, bool enable)
{
bool flag = false;
if (!enable)
{
flag = true;
}
DataTable table = new DataTable();
table.Columns.Add("NodeId");
table.Columns.Add("ModelId");
table.Columns.Add("DefaultTemplateFile");
table.Columns.Add("ModelName");
table.Columns.Add("ItemName");
table.Columns.Add("IsEshop");
table.Columns.Add("AddInfoFilePath");
table.Columns.Add("ManageInfoFilePath");
table.Columns.Add("PreviewInfoFilePath");
table.Columns.Add("BatchInfoFilePath");
table.Columns.Add("MaxPerUser");
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
cmdParams.AddInParameter("@Disabled", DbType.Boolean, flag);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT R.NodeId, R.ModelId, R.DefaultTemplateFile, M.ModelName, M.ItemName, M.IsEshop, M.AddInfoFilePath, M.ManageInfoFilePath, M.PreviewInfoFilePath, M.BatchInfoFilePath, M.MaxPerUser FROM PE_Nodes_Model_Template R INNER JOIN PE_Model M ON R.ModelId = M.ModelID WHERE R.NodeId = @NodeId AND M.Disabled = @Disabled AND M.IsEshop = 1", cmdParams))
{
while (reader.Read())
{
DataRow row = table.NewRow();
row["NodeId"] = reader.GetInt32("NodeId");
row["ModelId"] = reader.GetInt32("ModelId");
row["DefaultTemplateFile"] = reader.GetString("DefaultTemplateFile");
row["ModelName"] = reader.GetString("ModelName");
row["ItemName"] = reader.GetString("ItemName");
row["IsEshop"] = reader.GetBoolean("IsEshop");
row["AddInfoFilePath"] = reader.GetString("AddInfoFilePath");
row["ManageInfoFilePath"] = reader.GetString("ManageInfoFilePath");
row["PreviewInfoFilePath"] = reader.GetString("PreviewInfoFilePath");
row["BatchInfoFilePath"] = reader.GetString("BatchInfoFilePath");
row["MaxPerUser"] = reader.GetInt32("MaxPerUser");
table.Rows.Add(row);
}
}
return(table);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static MentionLogEntity GetEntityFromrdr(NullableDataReader rdr)
{
MentionLogEntity info = new MentionLogEntity();
info.ID = rdr.GetInt32("ID");
info.Applicant = rdr.GetString("Applicant");
info.ApplicationTime = rdr.GetNullableDateTime("ApplicationTime");
info.ApplicationAmount = rdr.GetDecimal("ApplicationAmount");
info.HandlingCharge = rdr.GetDecimal("HandlingCharge");
info.BankAccount = rdr.GetString("BankAccount");
info.MentionStatus = rdr.GetInt32("MentionStatus");
info.Operator = rdr.GetString("Operator");
info.OperatingTime = rdr.GetNullableDateTime("OperatingTime");
info.Remark = rdr.GetString("Remark");
info.LogTime = rdr.GetNullableDateTime("LogTime");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static StatVisitEntity GetEntityFromrdr(NullableDataReader rdr)
{
StatVisitEntity info = new StatVisitEntity();
info.ID = rdr.GetInt32("ID");
info.D1 = rdr.GetInt32("D1");
info.D2 = rdr.GetInt32("D2");
info.D3 = rdr.GetInt32("D3");
info.D4 = rdr.GetInt32("D4");
info.D5 = rdr.GetInt32("D5");
info.D6 = rdr.GetInt32("D6");
info.D7 = rdr.GetInt32("D7");
info.D8 = rdr.GetInt32("D8");
info.D9 = rdr.GetInt32("D9");
info.D10 = rdr.GetInt32("D10");
return(info);
}
public int ValidateUser(string userName, string password)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@UserName", DbType.String, userName);
cmdParams.AddInParameter("@Password", DbType.String, password);
int num = -1;
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT UserId FROM [PE_Users] WHERE UserName = @UserName AND UserPassword = @Password", cmdParams))
{
if (reader.Read())
{
num = reader.GetInt32("UserId");
}
}
return(num);
}
public IList <EasyOne.Model.Collection.CollectionPagingRuleInfo> GetCollectionPagingRuleList(int itemId)
{
Parameters cmdParams = new Parameters();
string strCommand = "SELECT * FROM PE_CollectionPagingRules WHERE ItemId = @ItemId";
cmdParams.AddInParameter("@ItemId", DbType.Int32, itemId);
IList <EasyOne.Model.Collection.CollectionPagingRuleInfo> list = new List <EasyOne.Model.Collection.CollectionPagingRuleInfo>();
using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
{
if (reader.Read())
{
list.Add(CollectionPagingRuleInfo(reader));
}
}
return(list);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static SpecialCategoryEntity GetEntityFromrdr(NullableDataReader rdr)
{
SpecialCategoryEntity info = new SpecialCategoryEntity();
info.SpecialCategoryID = rdr.GetInt32("SpecialCategoryID");
info.SpecialCategoryName = rdr.GetString("SpecialCategoryName");
info.SpecialCategoryDir = rdr.GetString("SpecialCategoryDir");
info.SpecialTemplatePath = rdr.GetString("SpecialTemplatePath");
info.OrderSort = rdr.GetInt32("OrderSort");
info.IsNewOpen = rdr.GetBoolean("IsNewOpen");
info.Description = rdr.GetString("Description");
info.IsCreateHtml = rdr.GetBoolean("IsCreateHtml");
info.PagePostfix = rdr.GetString("PagePostfix");
info.SearchTemplatePath = rdr.GetString("SearchTemplatePath");
info.IsNeedCreateHtml = rdr.GetBoolean("IsNeedCreateHtml");
return(info);
}
public IList<SourceInfo> GetSourceTypeList()
{
string strSql = "SELECT Type FROM PE_Source GROUP BY Type";
IList<SourceInfo> list = new List<SourceInfo>();
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql))
{
while (reader.Read())
{
if (!string.IsNullOrEmpty(reader.GetString(0)))
{
SourceInfo item = new SourceInfo(reader.GetString(0));
list.Add(item);
}
}
}
return list;
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static ComplaintsEntity GetEntityFromrdr(NullableDataReader rdr)
{
ComplaintsEntity info = new ComplaintsEntity();
info.CID = rdr.GetInt32("CID");
info.CNO = rdr.GetString("CNO");
info.CName = rdr.GetString("CName");
info.CType = rdr.GetInt32("CType");
info.CDType = rdr.GetInt32("CDType");
info.CContent = rdr.GetString("CContent");
info.CContact = rdr.GetString("CContact");
info.CTime = rdr.GetNullableDateTime("CTime");
info.CIP = rdr.GetString("CIP");
info.CState = rdr.GetInt32("CState");
info.CAdminID = rdr.GetInt32("CAdminID");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static LogInfo GetLogInfoFromrdr(NullableDataReader rdr)
{
LogInfo info = new LogInfo();
info.LogId = rdr.GetInt32("LogID");
info.Category = (LogCategory)rdr.GetInt32("Category");
info.Priority = (LogPriority)rdr.GetInt32("Priority");
info.Title = rdr.GetString("Title");
info.Message = rdr.GetString("Message");
info.Timestamp = rdr.GetNullableDateTime("Timestamp").Value;
info.UserName = rdr.GetString("UserName");
info.UserIP = rdr.GetString("UserIP");
info.Source = rdr.GetString("Source");
info.ScriptName = rdr.GetString("ScriptName");
info.PostString = rdr.GetString("PostString");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static HirePurchaseEntity GetEntityFromrdr(NullableDataReader rdr)
{
HirePurchaseEntity info = new HirePurchaseEntity();
info.ID = rdr.GetInt32("ID");
info.NodeID = rdr.GetInt32("NodeID");
info.ProductID = rdr.GetInt32("ProductID");
info.DownPayment = rdr.GetDecimal("DownPayment");
info.DownPaymentMax = rdr.GetDecimal("DownPaymentMax");
info.YearRate = rdr.GetDecimal("YearRate");
info.Fee = rdr.GetDecimal("Fee");
info.MerchantRebate = rdr.GetDecimal("MerchantRebate");
info.Deadline = rdr.GetInt32("Deadline");
info.MinLoanMoney = rdr.GetDecimal("MinLoanMoney");
info.MaxLoanMoney = rdr.GetDecimal("MaxLoanMoney");
return(info);
}
public IList <CardInfo> GetUnsoldCard(string tableName, int productId, int amount)
{
string strSql = "SELECT TOP " + amount.ToString() + " * FROM PE_Cards WHERE OrderItemID = 0 AND ProductID = @ProductID AND TableName = @TableName";
IList <CardInfo> list = new List <CardInfo>();
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ProductID", DbType.Int32, productId);
cmdParams.AddInParameter("@TableName", DbType.String, tableName);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
while (reader.Read())
{
list.Add(CardFromDataReader(reader));
}
}
return(list);
}
public CardInfo GetCardByOrderItemId(int productId, string tableName, int orderItemId)
{
string strSql = "SELECT TOP 1 * FROM PE_Cards WHERE ProductId = @ProductId AND TableName = @TableName AND OrderItemId = @OrderItemId";
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ProductId", DbType.Int32, productId);
cmdParams.AddInParameter("@TableName", DbType.String, tableName);
cmdParams.AddInParameter("@OrderItemId", DbType.Int32, orderItemId);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
{
if (reader.Read())
{
return(CardFromDataReader(reader));
}
return(new CardInfo(true));
}
}
public IList <NodeInfo> GetNodesListByRootId(int rootId)
{
IList <NodeInfo> list = new List <NodeInfo>();
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@RootID", DbType.Int32, rootId);
string strCommand = "SELECT * FROM PE_Nodes WHERE RootID = @RootID AND ParentID > 0 ORDER BY OrderID";
using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
{
while (reader.Read())
{
list.Add(NodesFromrdr(reader));
}
}
return(list);
}
private static OrderInfo OrderFromrdr(NullableDataReader rdr, string action)
{
OrderInfo info = new OrderInfo();
info.OrderId = rdr.GetInt32("OrderID");
info.OrderNum = rdr.GetString("OrderNum");
info.UserName = rdr.GetString("UserName");
info.ClientId = rdr.GetInt32("ClientID");
info.ClientName = rdr.GetString("ClientName");
info.MoneyTotal = rdr.GetDecimal("MoneyTotal");
info.NeedInvoice = rdr.GetBoolean("NeedInvoice");
info.Invoiced = rdr.GetBoolean("Invoiced");
info.Remark = rdr.GetString("Remark");
info.MoneyReceipt = rdr.GetDecimal("MoneyReceipt");
info.InputTime = rdr.GetDateTime("InputTime");
info.Status = (OrderStatus)rdr.GetInt32("Status");
info.DeliverStatus = (DeliverStatus)rdr.GetInt32("DeliverStatus");
if (string.IsNullOrEmpty(action))
{
info.EnableDownload = rdr.GetBoolean("EnableDownload");
info.PresentMoney = rdr.GetDecimal("PresentMoney");
info.PresentPoint = rdr.GetInt32("PresentPoint");
info.PresentExp = rdr.GetInt32("PresentExp");
info.DiscountPayment = rdr.GetDouble("Discount_Payment");
info.ChargeDeliver = rdr.GetDecimal("Charge_Deliver");
}
info.AgentName = rdr.GetString("AgentName");
info.Functionary = rdr.GetString("Functionary");
info.InvoiceContent = rdr.GetString("InvoiceContent");
info.BeginDate = rdr.GetDateTime("BeginDate");
info.ContacterName = rdr.GetString("ContacterName");
info.Address = rdr.GetString("Address");
info.ZipCode = rdr.GetString("ZipCode");
info.Mobile = rdr.GetString("Mobile");
info.Phone = rdr.GetString("Phone");
info.Email = rdr.GetString("Email");
info.PaymentType = rdr.GetInt32("PaymentType");
info.DeliverType = rdr.GetInt32("DeliverType");
info.Memo = rdr.GetString("Memo");
info.OutOfStockProject = (OutOfStockProject)rdr.GetInt32("OutOfStockProject");
info.OrderType = rdr.GetInt32("OrderType");
info.CouponId = rdr.GetInt32("CouponID");
info.DeliveryTime = rdr.GetString("DeliveryTime");
return(info);
}
public List <TipoDocumentacion> TraeIngresadosXFechaMovimiento(Int64 id_Beneficiario, Int16 codPrestacion, DateTime fechaIngreso)
{
List <TipoDocumentacion> result = null;
Database db = DatabaseFactory.CreateDatabase("ConveniosInt_V02");
/* Definimos el nombre de la base que definimos en el Machine.config que luego se explicará. */
DbCommand dbCommand = db.GetStoredProcCommand("TraeIngresadosXFechaMovimiento");
try
{
TipoDocumentacion oParam;
/* Se cargan los parámetros del store */
db.AddInParameter(dbCommand, "@id_Beneficiario", DbType.Int64, id_Beneficiario);
db.AddInParameter(dbCommand, "@codPrestacion", DbType.Int16, codPrestacion);
db.AddInParameter(dbCommand, "@fechaIngreso", DbType.String, fechaIngreso.ToShortDateString());
/* Se ejecuta el store */
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
result = new List <TipoDocumentacion>();
while (ds.Read())
{
/* Se llena el objeto con los datos del datareader */
this.Fill(out oParam, ds);
/* Se carga el objeto en la lista que se va a devolver */
result.Add(oParam);
}
ds.Close();
//}
/* Se recorre el datareader */
}
}
catch (Exception ex)
{
throw new Exception("Error en Envios.Datos " + System.Reflection.MethodBase.GetCurrentMethod(), ex);
}
//catch(sql)
finally
{
db = null;
dbCommand.Dispose();
}
/* Se retorna la lista convirtiendola en Array */
return(result);
}
public static List <TipoServicio> TraerTipoServicio(int CodConceptoLiq, short TipoConcepto)
{
string sql = "RelacionCodLiqXTipoConcXPrestITem_Trae";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
List <TipoServicio> unaListaTipoServicio = new List <TipoServicio>();
try
{
db.AddInParameter(dbCommand, "@CodConceptoLiq", DbType.Int32, CodConceptoLiq);
db.AddInParameter(dbCommand, "@TipoConcepto", DbType.Int16, TipoConcepto);
using (NullableDataReader dr = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (dr.Read())
{
unaListaTipoServicio.Add(new TipoServicio(dr["idItem"].ToString(),
dr["descripcionItem"].ToString(),
Convert.ToInt16(dr["pideFactura"]),
Convert.ToInt16(dr["pidePrestadorServicio"]),
Convert.ToInt16(dr["pideCBU"]),
Convert.ToInt16(dr["pideOtroMedioPago"]),
Convert.ToInt16(dr["pidePoliza"]),
Convert.ToInt16(dr["pideNroSocio"]),
Convert.ToInt16(dr["pideDetalleServicio"]),
Convert.ToInt16(dr["pideTarjeta"]),
Convert.ToInt16(dr["pideSucursal"]),
Convert.ToInt16(dr["pideTicket"]),
Convert.ToInt16(dr["pideTipoDocPresentado"])));
}
return(unaListaTipoServicio);
}
}
catch (Exception err)
{
log.Error(string.Format("{0}->{1}-> Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), err.Source, err.Message));
throw err;
}
finally
{
db = null;
dbCommand.Dispose();
}
}
