/// <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; } }