public ActionResult Index()
{
//每日应用汇总
JMP.BLL.jmp_appcount bll = new JMP.BLL.jmp_appcount();
JMP.MDL.jmp_appcount model = new JMP.MDL.jmp_appcount();
JMP.MDL.jmp_user sm_model = new JMP.MDL.jmp_user();
//开发者每日结算详情
JMP.BLL.CoSettlementDeveloperAppDetails cobll = new JMP.BLL.CoSettlementDeveloperAppDetails();
JMP.MDL.CoSettlementDeveloperAppDetails comodel_yesterday = new JMP.MDL.CoSettlementDeveloperAppDetails();
JMP.MDL.CoSettlementDeveloperAppDetails comodel_month = new JMP.MDL.CoSettlementDeveloperAppDetails();
JMP.MDL.CoSettlementDeveloperAppDetails comodel_preceding_month = new JMP.MDL.CoSettlementDeveloperAppDetails();
int u_id = UserInfo.UserId;
JMP.BLL.jmp_user sm_bll = new JMP.BLL.jmp_user();
sm_model = sm_bll.GetModel(u_id);
ViewBag.FrozenMoney = sm_model.FrozenMoney.ToString("f0");
//今天
string u_time = DateTime.Now.ToString("yyyy-MM-dd");
//昨天
string u_time_yesterday = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
//本月
string u_time_month = DateTime.Now.ToString("yyyy-MM");
//上月
string u_time_preceding_month = DateTime.Now.AddMonths(-1).ToString("yyyy-MM");
//根据日期查询交易金额和笔数（今天）
model = bll.DataAppcountAdy(u_time, u_id, 0);
//根据不同日期统计查询(昨天)
comodel_yesterday = cobll.GetModelKFZ_total(u_id, u_time_yesterday, 0);
//根据不同日期统计查询(本月)
comodel_month = cobll.GetModelKFZ_total(u_id, u_time_month, 1);
//根据不同日期统计查询(上月)
comodel_preceding_month = cobll.GetModelKFZ_total(u_id, u_time_preceding_month, 1);
//流水及收入金额
ViewBag.comodel_yesterday = comodel_yesterday;
ViewBag.comodel_month = comodel_month;
ViewBag.comodel_preceding_month = comodel_preceding_month;
ViewBag.AppCount = model;
return(View());
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.CoSettlementDeveloperAppDetails model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CoSettlementDeveloperAppDetails(");
strSql.Append("TotalAmount,OriginServiceFee,ServiceFee,ServiceFeeRatio,IsSpecialApproval,SpecialApprovalServiceFee,SpecialApprovalFeeRatio,PortFee,PortFeeRatio,DefaultPortFeeRatio,SettlementDay,CreatedOn,ChannelId,ChannelName,ChannelCostFee,ChannelCostRatio,ChannelRefundAmount,DeveloperId,DeveloperName,AppId,AppName,PayModeId,PayModeName,OrderCount");
strSql.Append(") values (");
strSql.Append("@TotalAmount,@OriginServiceFee,@ServiceFee,@ServiceFeeRatio,@IsSpecialApproval,@SpecialApprovalServiceFee,@SpecialApprovalFeeRatio,@PortFee,@PortFeeRatio,@DefaultPortFeeRatio,@SettlementDay,@CreatedOn,@ChannelId,@ChannelName,@ChannelCostFee,@ChannelCostRatio,@ChannelRefundAmount,@DeveloperId,@DeveloperName,@AppId,@AppName,@PayModeId,@PayModeName,@OrderCount");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TotalAmount", SqlDbType.Decimal, 9),
new SqlParameter("@OriginServiceFee", SqlDbType.Decimal, 9),
new SqlParameter("@ServiceFee", SqlDbType.Decimal, 9),
new SqlParameter("@ServiceFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@IsSpecialApproval", SqlDbType.Bit, 1),
new SqlParameter("@SpecialApprovalServiceFee", SqlDbType.Decimal, 9),
new SqlParameter("@SpecialApprovalFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@PortFee", SqlDbType.Decimal, 9),
new SqlParameter("@PortFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@DefaultPortFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@SettlementDay", SqlDbType.Date, 3),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@ChannelId", SqlDbType.Int, 4),
new SqlParameter("@ChannelName", SqlDbType.NVarChar, 255),
new SqlParameter("@ChannelCostFee", SqlDbType.Decimal, 9),
new SqlParameter("@ChannelCostRatio", SqlDbType.Decimal, 9),
new SqlParameter("@ChannelRefundAmount", SqlDbType.Decimal, 9),
new SqlParameter("@DeveloperId", SqlDbType.Int, 4),
new SqlParameter("@DeveloperName", SqlDbType.NVarChar, 500),
new SqlParameter("@AppId", SqlDbType.Int, 4),
new SqlParameter("@AppName", SqlDbType.NVarChar, 500),
new SqlParameter("@PayModeId", SqlDbType.Int, 4),
new SqlParameter("@PayModeName", SqlDbType.NVarChar, 255),
new SqlParameter("@OrderCount", SqlDbType.Int, 4)
};
parameters[0].Value = model.TotalAmount;
parameters[1].Value = model.OriginServiceFee;
parameters[2].Value = model.ServiceFee;
parameters[3].Value = model.ServiceFeeRatio;
parameters[4].Value = model.IsSpecialApproval;
parameters[5].Value = model.SpecialApprovalServiceFee;
parameters[6].Value = model.SpecialApprovalFeeRatio;
parameters[7].Value = model.PortFee;
parameters[8].Value = model.PortFeeRatio;
parameters[9].Value = model.DefaultPortFeeRatio;
parameters[10].Value = model.SettlementDay;
parameters[11].Value = model.CreatedOn;
parameters[12].Value = model.ChannelId;
parameters[13].Value = model.ChannelName;
parameters[14].Value = model.ChannelCostFee;
parameters[15].Value = model.ChannelCostRatio;
parameters[16].Value = model.ChannelRefundAmount;
parameters[17].Value = model.DeveloperId;
parameters[18].Value = model.DeveloperName;
parameters[19].Value = model.AppId;
parameters[20].Value = model.AppName;
parameters[21].Value = model.PayModeId;
parameters[22].Value = model.PayModeName;
parameters[23].Value = model.OrderCount;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.CoSettlementDeveloperAppDetails GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, TotalAmount, OriginServiceFee, ServiceFee, ServiceFeeRatio, IsSpecialApproval, SpecialApprovalServiceFee, SpecialApprovalFeeRatio, PortFee, PortFeeRatio, DefaultPortFeeRatio, SettlementDay, CreatedOn, ChannelId, ChannelName, ChannelCostFee, ChannelCostRatio, ChannelRefundAmount, DeveloperId, DeveloperName, AppId, AppName, PayModeId, PayModeName, OrderCount ");
strSql.Append(" from CoSettlementDeveloperAppDetails ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
JMP.MDL.CoSettlementDeveloperAppDetails model = new JMP.MDL.CoSettlementDeveloperAppDetails();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["TotalAmount"].ToString() != "")
{
model.TotalAmount = decimal.Parse(ds.Tables[0].Rows[0]["TotalAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["OriginServiceFee"].ToString() != "")
{
model.OriginServiceFee = decimal.Parse(ds.Tables[0].Rows[0]["OriginServiceFee"].ToString());
}
if (ds.Tables[0].Rows[0]["ServiceFee"].ToString() != "")
{
model.ServiceFee = decimal.Parse(ds.Tables[0].Rows[0]["ServiceFee"].ToString());
}
if (ds.Tables[0].Rows[0]["ServiceFeeRatio"].ToString() != "")
{
model.ServiceFeeRatio = decimal.Parse(ds.Tables[0].Rows[0]["ServiceFeeRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["IsSpecialApproval"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsSpecialApproval"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSpecialApproval"].ToString().ToLower() == "true"))
{
model.IsSpecialApproval = true;
}
else
{
model.IsSpecialApproval = false;
}
}
if (ds.Tables[0].Rows[0]["SpecialApprovalServiceFee"].ToString() != "")
{
model.SpecialApprovalServiceFee = decimal.Parse(ds.Tables[0].Rows[0]["SpecialApprovalServiceFee"].ToString());
}
if (ds.Tables[0].Rows[0]["SpecialApprovalFeeRatio"].ToString() != "")
{
model.SpecialApprovalFeeRatio = decimal.Parse(ds.Tables[0].Rows[0]["SpecialApprovalFeeRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["PortFee"].ToString() != "")
{
model.PortFee = decimal.Parse(ds.Tables[0].Rows[0]["PortFee"].ToString());
}
if (ds.Tables[0].Rows[0]["PortFeeRatio"].ToString() != "")
{
model.PortFeeRatio = decimal.Parse(ds.Tables[0].Rows[0]["PortFeeRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["DefaultPortFeeRatio"].ToString() != "")
{
model.DefaultPortFeeRatio = decimal.Parse(ds.Tables[0].Rows[0]["DefaultPortFeeRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["SettlementDay"].ToString() != "")
{
model.SettlementDay = DateTime.Parse(ds.Tables[0].Rows[0]["SettlementDay"].ToString());
}
if (ds.Tables[0].Rows[0]["CreatedOn"].ToString() != "")
{
model.CreatedOn = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedOn"].ToString());
}
if (ds.Tables[0].Rows[0]["ChannelId"].ToString() != "")
{
model.ChannelId = int.Parse(ds.Tables[0].Rows[0]["ChannelId"].ToString());
}
model.ChannelName = ds.Tables[0].Rows[0]["ChannelName"].ToString();
if (ds.Tables[0].Rows[0]["ChannelCostFee"].ToString() != "")
{
model.ChannelCostFee = decimal.Parse(ds.Tables[0].Rows[0]["ChannelCostFee"].ToString());
}
if (ds.Tables[0].Rows[0]["ChannelCostRatio"].ToString() != "")
{
model.ChannelCostRatio = decimal.Parse(ds.Tables[0].Rows[0]["ChannelCostRatio"].ToString());
}
if (ds.Tables[0].Rows[0]["ChannelRefundAmount"].ToString() != "")
{
model.ChannelRefundAmount = decimal.Parse(ds.Tables[0].Rows[0]["ChannelRefundAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["DeveloperId"].ToString() != "")
{
model.DeveloperId = int.Parse(ds.Tables[0].Rows[0]["DeveloperId"].ToString());
}
model.DeveloperName = ds.Tables[0].Rows[0]["DeveloperName"].ToString();
if (ds.Tables[0].Rows[0]["AppId"].ToString() != "")
{
model.AppId = int.Parse(ds.Tables[0].Rows[0]["AppId"].ToString());
}
model.AppName = ds.Tables[0].Rows[0]["AppName"].ToString();
if (ds.Tables[0].Rows[0]["PayModeId"].ToString() != "")
{
model.PayModeId = int.Parse(ds.Tables[0].Rows[0]["PayModeId"].ToString());
}
model.PayModeName = ds.Tables[0].Rows[0]["PayModeName"].ToString();
if (ds.Tables[0].Rows[0]["OrderCount"].ToString() != "")
{
model.OrderCount = int.Parse(ds.Tables[0].Rows[0]["OrderCount"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.CoSettlementDeveloperAppDetails model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CoSettlementDeveloperAppDetails set ");
strSql.Append(" TotalAmount = @TotalAmount , ");
strSql.Append(" OriginServiceFee = @OriginServiceFee , ");
strSql.Append(" ServiceFee = @ServiceFee , ");
strSql.Append(" ServiceFeeRatio = @ServiceFeeRatio , ");
strSql.Append(" IsSpecialApproval = @IsSpecialApproval , ");
strSql.Append(" SpecialApprovalServiceFee = @SpecialApprovalServiceFee , ");
strSql.Append(" SpecialApprovalFeeRatio = @SpecialApprovalFeeRatio , ");
strSql.Append(" PortFee = @PortFee , ");
strSql.Append(" PortFeeRatio = @PortFeeRatio , ");
strSql.Append(" DefaultPortFeeRatio = @DefaultPortFeeRatio , ");
strSql.Append(" SettlementDay = @SettlementDay , ");
strSql.Append(" CreatedOn = @CreatedOn , ");
strSql.Append(" ChannelId = @ChannelId , ");
strSql.Append(" ChannelName = @ChannelName , ");
strSql.Append(" ChannelCostFee = @ChannelCostFee , ");
strSql.Append(" ChannelCostRatio = @ChannelCostRatio , ");
strSql.Append(" ChannelRefundAmount = @ChannelRefundAmount , ");
strSql.Append(" DeveloperId = @DeveloperId , ");
strSql.Append(" DeveloperName = @DeveloperName , ");
strSql.Append(" AppId = @AppId , ");
strSql.Append(" AppName = @AppName , ");
strSql.Append(" PayModeId = @PayModeId , ");
strSql.Append(" PayModeName = @PayModeName , ");
strSql.Append(" OrderCount = @OrderCount ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@TotalAmount", SqlDbType.Decimal, 9),
new SqlParameter("@OriginServiceFee", SqlDbType.Decimal, 9),
new SqlParameter("@ServiceFee", SqlDbType.Decimal, 9),
new SqlParameter("@ServiceFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@IsSpecialApproval", SqlDbType.Bit, 1),
new SqlParameter("@SpecialApprovalServiceFee", SqlDbType.Decimal, 9),
new SqlParameter("@SpecialApprovalFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@PortFee", SqlDbType.Decimal, 9),
new SqlParameter("@PortFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@DefaultPortFeeRatio", SqlDbType.Decimal, 5),
new SqlParameter("@SettlementDay", SqlDbType.Date, 3),
new SqlParameter("@CreatedOn", SqlDbType.DateTime),
new SqlParameter("@ChannelId", SqlDbType.Int, 4),
new SqlParameter("@ChannelName", SqlDbType.NVarChar, 255),
new SqlParameter("@ChannelCostFee", SqlDbType.Decimal, 9),
new SqlParameter("@ChannelCostRatio", SqlDbType.Decimal, 9),
new SqlParameter("@ChannelRefundAmount", SqlDbType.Decimal, 9),
new SqlParameter("@DeveloperId", SqlDbType.Int, 4),
new SqlParameter("@DeveloperName", SqlDbType.NVarChar, 500),
new SqlParameter("@AppId", SqlDbType.Int, 4),
new SqlParameter("@AppName", SqlDbType.NVarChar, 500),
new SqlParameter("@PayModeId", SqlDbType.Int, 4),
new SqlParameter("@PayModeName", SqlDbType.NVarChar, 255),
new SqlParameter("@OrderCount", SqlDbType.Int, 4)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.TotalAmount;
parameters[2].Value = model.OriginServiceFee;
parameters[3].Value = model.ServiceFee;
parameters[4].Value = model.ServiceFeeRatio;
parameters[5].Value = model.IsSpecialApproval;
parameters[6].Value = model.SpecialApprovalServiceFee;
parameters[7].Value = model.SpecialApprovalFeeRatio;
parameters[8].Value = model.PortFee;
parameters[9].Value = model.PortFeeRatio;
parameters[10].Value = model.DefaultPortFeeRatio;
parameters[11].Value = model.SettlementDay;
parameters[12].Value = model.CreatedOn;
parameters[13].Value = model.ChannelId;
parameters[14].Value = model.ChannelName;
parameters[15].Value = model.ChannelCostFee;
parameters[16].Value = model.ChannelCostRatio;
parameters[17].Value = model.ChannelRefundAmount;
parameters[18].Value = model.DeveloperId;
parameters[19].Value = model.DeveloperName;
parameters[20].Value = model.AppId;
parameters[21].Value = model.AppName;
parameters[22].Value = model.PayModeId;
parameters[23].Value = model.PayModeName;
parameters[24].Value = model.OrderCount;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Default()
{
#region 获取用户实名认证状态信息
JMP.BLL.jmp_user sm_bll = new JMP.BLL.jmp_user();
JMP.MDL.jmp_user sm_model = new JMP.MDL.jmp_user();
int u_ids = UserInfo.Uid;
//查询登录信息
sm_model = sm_bll.GetModel(u_ids);
ViewBag.auditstate = sm_model.u_auditstate;
ViewBag.linkEmail = sm_model.u_email;
#endregion
int r_id = UserInfo.UserRid;
string menuStr = GetMenStr(u_ids, r_id);
ViewBag.UserName = UserInfo.UserNo;
ViewBag.MsgCount = sm_bll.GetUserMsgCount(u_ids);
ViewBag.MenuTopStr = menuStr;
ViewBag.QQ = ConfigurationManager.AppSettings["linkqq"];
ViewBag.Tel = ConfigurationManager.AppSettings["linkphone"];
//每日应用汇总
JMP.BLL.jmp_appcount bllapp = new JMP.BLL.jmp_appcount();
JMP.MDL.jmp_appcount modelapp = new JMP.MDL.jmp_appcount();
//开发者每日结算详情
JMP.BLL.CoSettlementDeveloperAppDetails cobll = new JMP.BLL.CoSettlementDeveloperAppDetails();
JMP.MDL.CoSettlementDeveloperAppDetails comodel_yesterday = new JMP.MDL.CoSettlementDeveloperAppDetails();
JMP.MDL.CoSettlementDeveloperAppDetails comodel_month = new JMP.MDL.CoSettlementDeveloperAppDetails();
JMP.MDL.CoSettlementDeveloperAppDetails comodel_preceding_month = new JMP.MDL.CoSettlementDeveloperAppDetails();
int u_id = UserInfo.UserId;
//今天
string u_time = DateTime.Now.ToString("yyyy-MM-dd");
//昨天
string u_time_yesterday = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
//本月
string u_time_month = DateTime.Now.ToString("yyyy-MM");
//上月
string u_time_preceding_month = DateTime.Now.AddMonths(-1).ToString("yyyy-MM");
//根据日期查询交易金额和笔数（今天）
modelapp = bllapp.DataAppcountAdy(u_time, u_id, 0);
//根据不同日期统计查询(昨天)
comodel_yesterday = cobll.GetModelKFZ_total(u_id, u_time_yesterday, 0);
//根据不同日期统计查询(本月)
comodel_month = cobll.GetModelKFZ_total(u_id, u_time_month, 1);
//根据不同日期统计查询(上月)
comodel_preceding_month = cobll.GetModelKFZ_total(u_id, u_time_preceding_month, 1);
//流水及收入金额
ViewBag.comodel_yesterday = comodel_yesterday;
ViewBag.comodel_month = comodel_month;
ViewBag.comodel_preceding_month = comodel_preceding_month;
ViewBag.AppCount = modelapp;
return(View());
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <JMP.MDL.CoSettlementDeveloperAppDetails> DataTableToList(DataTable dt)
{
List <JMP.MDL.CoSettlementDeveloperAppDetails> modelList = new List <JMP.MDL.CoSettlementDeveloperAppDetails>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
JMP.MDL.CoSettlementDeveloperAppDetails model;
for (int n = 0; n < rowsCount; n++)
{
model = new JMP.MDL.CoSettlementDeveloperAppDetails();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["TotalAmount"].ToString() != "")
{
model.TotalAmount = decimal.Parse(dt.Rows[n]["TotalAmount"].ToString());
}
if (dt.Rows[n]["OriginServiceFee"].ToString() != "")
{
model.OriginServiceFee = decimal.Parse(dt.Rows[n]["OriginServiceFee"].ToString());
}
if (dt.Rows[n]["ServiceFee"].ToString() != "")
{
model.ServiceFee = decimal.Parse(dt.Rows[n]["ServiceFee"].ToString());
}
if (dt.Rows[n]["ServiceFeeRatio"].ToString() != "")
{
model.ServiceFeeRatio = decimal.Parse(dt.Rows[n]["ServiceFeeRatio"].ToString());
}
if (dt.Rows[n]["IsSpecialApproval"].ToString() != "")
{
if ((dt.Rows[n]["IsSpecialApproval"].ToString() == "1") || (dt.Rows[n]["IsSpecialApproval"].ToString().ToLower() == "true"))
{
model.IsSpecialApproval = true;
}
else
{
model.IsSpecialApproval = false;
}
}
if (dt.Rows[n]["SpecialApprovalServiceFee"].ToString() != "")
{
model.SpecialApprovalServiceFee = decimal.Parse(dt.Rows[n]["SpecialApprovalServiceFee"].ToString());
}
if (dt.Rows[n]["SpecialApprovalFeeRatio"].ToString() != "")
{
model.SpecialApprovalFeeRatio = decimal.Parse(dt.Rows[n]["SpecialApprovalFeeRatio"].ToString());
}
if (dt.Rows[n]["PortFee"].ToString() != "")
{
model.PortFee = decimal.Parse(dt.Rows[n]["PortFee"].ToString());
}
if (dt.Rows[n]["PortFeeRatio"].ToString() != "")
{
model.PortFeeRatio = decimal.Parse(dt.Rows[n]["PortFeeRatio"].ToString());
}
if (dt.Rows[n]["DefaultPortFeeRatio"].ToString() != "")
{
model.DefaultPortFeeRatio = decimal.Parse(dt.Rows[n]["DefaultPortFeeRatio"].ToString());
}
if (dt.Rows[n]["SettlementDay"].ToString() != "")
{
model.SettlementDay = DateTime.Parse(dt.Rows[n]["SettlementDay"].ToString());
}
if (dt.Rows[n]["CreatedOn"].ToString() != "")
{
model.CreatedOn = DateTime.Parse(dt.Rows[n]["CreatedOn"].ToString());
}
if (dt.Rows[n]["ChannelId"].ToString() != "")
{
model.ChannelId = int.Parse(dt.Rows[n]["ChannelId"].ToString());
}
model.ChannelName = dt.Rows[n]["ChannelName"].ToString();
if (dt.Rows[n]["ChannelCostFee"].ToString() != "")
{
model.ChannelCostFee = decimal.Parse(dt.Rows[n]["ChannelCostFee"].ToString());
}
if (dt.Rows[n]["ChannelCostRatio"].ToString() != "")
{
model.ChannelCostRatio = decimal.Parse(dt.Rows[n]["ChannelCostRatio"].ToString());
}
if (dt.Rows[n]["ChannelRefundAmount"].ToString() != "")
{
model.ChannelRefundAmount = decimal.Parse(dt.Rows[n]["ChannelRefundAmount"].ToString());
}
if (dt.Rows[n]["DeveloperId"].ToString() != "")
{
model.DeveloperId = int.Parse(dt.Rows[n]["DeveloperId"].ToString());
}
model.DeveloperName = dt.Rows[n]["DeveloperName"].ToString();
if (dt.Rows[n]["AppId"].ToString() != "")
{
model.AppId = int.Parse(dt.Rows[n]["AppId"].ToString());
}
model.AppName = dt.Rows[n]["AppName"].ToString();
if (dt.Rows[n]["PayModeId"].ToString() != "")
{
model.PayModeId = int.Parse(dt.Rows[n]["PayModeId"].ToString());
}
model.PayModeName = dt.Rows[n]["PayModeName"].ToString();
if (dt.Rows[n]["OrderCount"].ToString() != "")
{
model.OrderCount = int.Parse(dt.Rows[n]["OrderCount"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.CoSettlementDeveloperAppDetails model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.CoSettlementDeveloperAppDetails model)
{
return(dal.Add(model));
}