/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ExtendGame DataRowToModel(DataRow row)
{
Model.ExtendGame model = new Model.ExtendGame();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["gameID"] != null && row["gameID"].ToString() != "")
{
model.gameID = int.Parse(row["gameID"].ToString());
}
if (row["ChanelID"] != null && row["ChanelID"].ToString() != "")
{
model.ChanelID = int.Parse(row["ChanelID"].ToString());
}
if (row["ChanelName"] != null)
{
model.ChanelName = row["ChanelName"].ToString();
}
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = int.Parse(row["UserID"].ToString());
}
if (row["version"] != null)
{
model.version = row["version"].ToString();
}
if (row["Status"] != null)
{
model.Status = row["Status"].ToString();
}
if (row["UpdateType"] != null)
{
model.UpdateType = row["UpdateType"].ToString();
}
if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "")
{
model.UpdateDate = DateTime.Parse(row["UpdateDate"].ToString());
}
if (row["OnTime"] != null && row["OnTime"].ToString() != "")
{
model.OnTime = DateTime.Parse(row["OnTime"].ToString());
}
if (row["Bak1"] != null)
{
model.Bak1 = row["Bak1"].ToString();
}
if (row["Bak2"] != null)
{
model.Bak2 = row["Bak2"].ToString();
}
if (row["Bak3"] != null)
{
model.Bak3 = row["Bak3"].ToString();
}
if (row["Bak4"] != null)
{
model.Bak4 = row["Bak4"].ToString();
}
if (row["Bak5"] != null)
{
model.Bak5 = row["Bak5"].ToString();
}
if (row["gameName"] != null)
{
model.gameName = row["gameName"].ToString();
}
if (row["Verifycode"] != null)
{
model.Verifycode = row["Verifycode"].ToString();
}
}
return model;
}
protected void btnSave2_Click(object sender, EventArgs e)
{
int dbcount=0;
BLL.ExtendGame extgame = new BLL.ExtendGame();
Model.ExtendGame model = new Model.ExtendGame();
try
{
string str = this.hdValue.Value;
string[] strArr = str.Split(',');
StringBuilder sqlWehere = new StringBuilder();
sqlWehere.Append(" UserID='" + hduid.Value + "' and ChanelID='" + hdcid.Value + "' ");
if (strArr.Length > 1)
{
sqlWehere.Append(" and gameName not in (");
for (int i = 0; i < strArr.Length - 1; i++)
{
if (i == 0)
{
sqlWehere.Append("'" + strArr[i] + "'");
}
else
{
sqlWehere.Append(",'" + strArr[i] + "'");
}
}
sqlWehere.Append(") ");
}
extgame.Delete(sqlWehere.ToString());
if (this.hdValue.Value != "")//计算提交打包数量
{
dbcount = 0;
model.Status = "正在打包";
model.UpdateType = "N/A";
model.UserID = int.Parse(hduid.Value);
model.ChanelID = int.Parse(hdcid.Value);
model.ChanelName = hdcname.Value;
for (int i = 0; i < strArr.Length - 1; i++)
{
model.UpdateDate = DateTime.Now;
model.OnTime = DateTime.Now;
model.gameID = 0;
model.gameName = strArr[i].Trim();
if (!extgame.Exists(int.Parse(hduid.Value), int.Parse(hdcid.Value), model.gameName))
{
dbcount++;
}
}
}
string countwhere = "[Status] ='正在打包' and ChanelID ='" + hdcid.Value + "' "; //计算正在打包数量
if (extgame.GetCount(countwhere) + dbcount > 5)
{
Model.Log modLog = new Model.Log();
modLog.UserId = int.Parse(hdcid.Value);
modLog.UserName = hdcname.Value;
InsertLog(modLog);
string myScript = @"alertRedirectMsg('打包序列不能超过5个，请耐心等待!','error.gif','Channel.aspx');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "MyScript", myScript, true);
}
else
{
if (this.hdValue.Value != "")
{
model.Status = "正在打包";
model.UpdateType = "N/A";
model.UserID = int.Parse(hduid.Value);
model.ChanelID = int.Parse(hdcid.Value);
model.ChanelName = hdcname.Value;
for (int i = 0; i < strArr.Length - 1; i++)
{
model.UpdateDate = DateTime.Now;
model.OnTime = DateTime.Now;
model.gameID = 0;
model.gameName = strArr[i].Trim();
model.Verifycode = VerifycodeUtils.genVerifycode(6);
if (!extgame.Exists(int.Parse(hduid.Value), int.Parse(hdcid.Value), model.gameName))
{
extgame.Add(model);
}
}
}
Model.Log modLog = new Model.Log();
modLog.UserId = int.Parse(hdcid.Value);
modLog.UserName = hdcname.Value;
InsertLog(modLog);
string myScript = @"alertRedirectMsg('保存成功,系统正为您准备推广包，等待时间约为几分钟......','success.gif','Downloadgames.aspx?cooperateModelId= " + Request.Params["cooperateId"].ToString() + "');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "MyScript", myScript, true);
}
}
catch
{
string myScript = @"alertRedirectMsg('保存错误!','error.gif','Channel.aspx');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "MyScript", myScript, true);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ExtendGame GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,gameID,ChanelID,ChanelName,UserID,version,Status,UpdateType,UpdateDate,OnTime,Bak1,Bak2,Bak3,Bak4,Bak5,gameName,Verifycode from ExtendGame ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = ID;
Model.ExtendGame model = new Model.ExtendGame();
DataSet ds = DbHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
