/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ReportTempMain DataRowToModel(DataRow row)
{
Model.ReportTempMain model = new Model.ReportTempMain();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["Num"] != null)
{
model.Num = row["Num"].ToString();
}
}
return model;
}
/// <summary>
/// 数据集操作
/// </summary>
/// <param name="ds"></param>
private void DataSetOperator(DataSet ds, string filePath)
{
int k = 0;
if (ds.Tables[0].Rows.Count < 1)
{
JscriptMsg(350, 230, "错误提示", "<b>没有数据！</b>", "back", "Error");
return;
}
try
{
DateTime strSumDate;
string strChannelName;
string strGameName;
decimal strRegisterValue;
decimal strConsumptionValue;
decimal strIncome;
strNum = Guid.NewGuid().ToString();
ArrayList SQLStringList1 = new ArrayList();
ArrayList SQLStringList2 = new ArrayList();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
k++;
#region 统计日期格式转换
try
{
strSumDate = Convert.ToDateTime(ds.Tables[0].Rows[i][int_SumDate].ToString().Trim());
}
catch
{
SQLStringList2.Add("第" + k + "行统计日期错误");
break;
}
#endregion
#region 渠道名称格式转换
try
{
if (ds.Tables[0].Rows[i][int_ChannelName].ToString().Trim().Length > 0)
{
strChannelName = ds.Tables[0].Rows[i][int_ChannelName].ToString().Trim();
}
else
{
SQLStringList2.Add("第" + k + "行渠道名称不能为空");
break;
}
}
catch
{
SQLStringList2.Add("第" + k + "行渠道名称错误");
break;
}
#endregion
#region 游戏名称格式转换
try
{
if (ds.Tables[0].Rows[i][int_GameName].ToString().Trim().Length > 0)
{
strGameName = ds.Tables[0].Rows[i][int_GameName].ToString().Trim();
}
else
{
SQLStringList2.Add("第" + k + "行游戏名称不能为空");
break;
}
}
catch
{
SQLStringList2.Add("第" + k + "行游戏名称错误");
break;
}
#endregion
#region 注册值格式转换
try
{
strRegisterValue = decimal.Parse(ds.Tables[0].Rows[i][int_RegisterValue].ToString().Trim());
}
catch
{
SQLStringList2.Add("第" + k + "行注册值错误");
break;
}
#endregion
#region 消费值格式转换
try
{
strConsumptionValue = decimal.Parse(ds.Tables[0].Rows[i][int_ConsumptionValue].ToString().Trim());
}
catch
{
SQLStringList2.Add("第" + k + "行消费值错误");
break;
}
#endregion
#region 收入值格式转换
try
{
strIncome = decimal.Parse(ds.Tables[0].Rows[i][int_Income].ToString().Trim());
}
catch
{
SQLStringList2.Add("第" + k + "行收入值错误");
break;
}
#endregion
string sqlStr1 = "insert into ReportTemp([SumDate],[ChannelName],[GameName],[RegisterValue],[ConsumptionValue],[Bak1],[Bak4],[AddDate])";
sqlStr1 += "values ('" + strSumDate.ToString("yyyy-MM-dd") + "',";//SumDate 统计日期
sqlStr1 += "'" + strChannelName + "',";//ChannelName 渠道
sqlStr1 += "'" + strGameName + "',";//GameName 游戏名称
sqlStr1 += "'" + strRegisterValue + "',";//RegisterValue 注册值
sqlStr1 += "'" + strConsumptionValue + "',";//ConsumptionValue 消费值
sqlStr1 += "'" + ddlMenu.SelectedItem.Text + "',";//平台
//sqlStr1 += "'0',";//Income 收入
sqlStr1 += "'" + strNum + "',";//导入总单号
sqlStr1 += "'" + DateTime.Now + "')";//AddDate 添加时间
//sqlStr1 += "'" + hduserid.Value + "')";//UserID 用户ID
SQLStringList1.Add(sqlStr1);
}
if (SQLStringList2.Count == 0)
{
DbHelper.ExecuteSqlTran(SQLStringList1);
BLL.ReportTempMain bllMain = new BLL.ReportTempMain();
Model.ReportTempMain modMain = new Model.ReportTempMain();
modMain.Name = ddlMenu.SelectedItem.Text + string.Format("{0:yyyyMMddHHmmssffff}", DateTime.Now);
modMain.Num = strNum;
bllMain.Add(modMain);
SqlParameter[] parameters = {
new SqlParameter("@NumID", SqlDbType.NVarChar,50)};
parameters[0].Value = strNum;
DbHelper.RunProcedure("SP_Process_Report", parameters);
int num = Convert.ToInt32(DbHelper.GetSingle("select count(*) from ReportTemp where bak4='" + strNum + "' and ChannelID=0 "));
if (num > 0)
{
JscriptMsg(350, 230, "错误提示", "<b>验证失败有错误信息！</b>", "back", "Error");
}
else
{
SqlParameter[] parameters2 = {
new SqlParameter("@NumID", SqlDbType.NVarChar,50)};
parameters2[0].Value = strNum;
DbHelper.RunProcedure("SP_Insert_Report", parameters2);
}
}
else
{
string msg = "";
for (int i = 0; i < SQLStringList2.Count; i++)
{
msg += SQLStringList2[i].ToString();
}
JscriptMsg(350, 230, "错误提示", "<b>没有数据！" + msg + "</b>", "back", "Error");
}
}
catch (Exception ex)
{
JscriptMsg(350, 230, "错误提示", "<b>没有数据！" + ex.Message + "</b>", "back", "Error");
}
finally
{
JscriptMsg(350, 230, "上传成功", "上传成功" + k + "条", "back", "Success");
File.Delete(filePath);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ReportTempMain GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,Num from ReportTempMain ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = ID;
Model.ReportTempMain model = new Model.ReportTempMain();
DataSet ds = DbHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
