void GetJCQuizList()
{
string strSiteID = string.Empty;
string strTitle = string.Empty;
string strTheme = string.Empty;
string strSiteCode = string.Empty;
List <JC_Quiz> jcmodel = new List <JC_Quiz>();
JC_QuizDAL dal = new JC_QuizDAL();
DataSet jclistds = dal.GetJCQuizDataList("");
foreach (DataRow row in jclistds.Tables[0].Rows)
{
JC_Quiz model = DataConvert.DataRowToModel <JC_Quiz>(row);
jcmodel.Add(model);
}
//读取模板内容
// string text = System.IO.File.ReadAllText(Server.MapPath("Themes/" + strTheme + "/NewHome.html"));
string text = System.IO.File.ReadAllText(Server.MapPath("Themes/Quiz/QuizList.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["title"] = "2014巴西世界杯比赛日程表一览";
context.TempData["siteid"] = Session["siteid"];
context.TempData["jcmodel"] = jcmodel;
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
/// <summary>
/// 添加竞猜信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddJCQuiz(JC_Quiz model)
{
string sql = @"INSERT INTO [JC_Quiz]
([ID],[SiteCode],[QuizType],[StartTime],[Name],[HomeTeam],[HomeTeamImg],[VisitingTeam],[VisitingTeamImg],[MatchDesc],[RightScore],[AddTime],[State])
VALUES
(@ID,@SiteCode,@QuizType,@StartTime,@Name,@HomeTeam,@HomeTeamImg,@VisitingTeam,@VisitingTeamImg,@MatchDesc,@RightScore,@AddTime,@State)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode),
new System.Data.SqlClient.SqlParameter("@QuizType", model.QuizType),
new System.Data.SqlClient.SqlParameter("@StartTime", model.StartTime),
new System.Data.SqlClient.SqlParameter("@Name", model.Name),
new System.Data.SqlClient.SqlParameter("@HomeTeam", model.HomeTeam),
new System.Data.SqlClient.SqlParameter("@HomeTeamImg", model.HomeTeamImg),
new System.Data.SqlClient.SqlParameter("@VisitingTeam", model.VisitingTeam),
new System.Data.SqlClient.SqlParameter("@VisitingTeamImg", model.VisitingTeamImg),
new System.Data.SqlClient.SqlParameter("@MatchDesc", model.MatchDesc),
new System.Data.SqlClient.SqlParameter("@RightScore", model.RightScore),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now),
new System.Data.SqlClient.SqlParameter("@State", (model.State == 1?1:0)),
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
public void ShowActivityInfo(string strID)
{
JC_QuizDAL dal = new JC_QuizDAL();
DataSet ds = dal.GetJCQuizDetail(strID);
JC_Quiz model = DataConvert.DataRowToModel <JC_Quiz>(ds.Tables[0].Rows[0]);
this.txtName.Text = model.Name;
this.hd_content.Value = model.MatchDesc;
starttime.Text = model.StartTime.ToString();
img0.Src = "../../" + model.HomeTeamImg;
img1.Src = "../../" + model.VisitingTeamImg;
hometeam.Text = model.HomeTeam;
VisitingTeam.Text = model.VisitingTeam;
RightScore.Text = model.RightScore;
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
starttime.ReadOnly = true;
txtName.ReadOnly = true;
}
else
{
starttime.Attributes.Add("onclick", "WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})");
}
}
/// <summary>
/// 竞猜信息修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpDateJCQuiz(JC_Quiz model)
{
string safeslq = "";
safeslq = "UPDATE JC_Quiz SET ";
if (model.SiteCode != null && model.SiteCode != "")
{
safeslq += "SiteCode='" + model.SiteCode + "',";
}
if (model.QuizType != null && model.QuizType != "")
{
safeslq += "QuizType='" + model.QuizType + "',";
}
if (model.StartTime != null && model.StartTime.ToString() != "")
{
safeslq += "StartTime='" + model.StartTime + "',";
}
if (model.Name != null && model.Name != "")
{
safeslq += "Name='" + model.Name + "',";
}
if (model.HomeTeam != null && model.HomeTeam != "")
{
safeslq += "HomeTeam='" + model.HomeTeam + "',";
}
if (model.HomeTeamImg != null && model.HomeTeamImg != "")
{
safeslq += "HomeTeamImg='" + model.HomeTeamImg + "',";
}
if (model.VisitingTeam != null && model.VisitingTeam != "")
{
safeslq += "VisitingTeam='" + model.VisitingTeam + "',";
}
if (model.VisitingTeamImg != null && model.VisitingTeamImg != "")
{
safeslq += "VisitingTeamImg='" + model.VisitingTeamImg + "',";
}
if (model.MatchDesc != null && model.MatchDesc != "")
{
safeslq += "MatchDesc='" + model.MatchDesc + "',";
}
safeslq += "RightScore='" + model.RightScore + "',";
if (model.State.ToString() != null && model.State.ToString() != "")
{
safeslq += "State=" + (model.State == 1 ? 1 : 0);
}
safeslq += " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
void GetDetailList()
{
DataSet ds = dalQuiz.GetJCQuizDetail(strQuizID);
JC_Quiz model = new JC_Quiz();
string comptim = string.Empty;
if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
model = DataConvert.DataRowToModel <JC_Quiz>(ds.Tables[0].Rows[0]);
}
if (model.StartTime < DateTime.Now || model.StartTime == DateTime.Now)
{
comptim = model.StartTime.ToString();
}
else
{
comptim = "";
}
List <JC_Quiz> jcmodelList = new List <JC_Quiz>();
DateTime smalldtm = dalQuiz.GetStartDateTime();
string dtm = string.Empty; string nextdaytime = string.Empty;
if (smalldtm.ToString() != null && smalldtm.ToString() != "")
{
DateTime bigdtm = dalQuiz.GetBigStartTime(smalldtm);
if (DateTime.Now > bigdtm)
{
dtm = bigdtm.AddDays(1).ToString("yyyy-MM-dd");
nextdaytime = bigdtm.AddDays(2).ToString("yyyy-MM-dd");
}
else
{
dtm = smalldtm.ToString("yyyy-MM-dd");
nextdaytime = smalldtm.AddDays(1).ToString("yyyy-MM-dd");
}
}
DataSet jclistds = dalQuiz.GetJCQuizDataList(" StartTime>='" + dtm + "' AND StartTime<'" + nextdaytime + "' ");
foreach (DataRow row in jclistds.Tables[0].Rows)
{
JC_Quiz jcmodel = DataConvert.DataRowToModel <JC_Quiz>(row);
jcmodelList.Add(jcmodel);
}
//读取模板内容
string text = string.Empty;
if (model.QuizType == "0")
{
text = System.IO.File.ReadAllText(Server.MapPath("Themes/Quiz/QuizWinFailed.html"));
}
else
{
text = System.IO.File.ReadAllText(Server.MapPath("Themes/Quiz/QuizDetail.html"));
}
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
QRCode qr = new QRCode();
context.TempData["title"] = "竞猜详细信息";
context.TempData["qDetail"] = model;
context.TempData["comptim"] = comptim;
context.TempData["jcmodel"] = jcmodelList;
context.TempData["openid"] = strOpenID;
context.TempData["QuizID"] = strQuizID;
context.TempData["sitecode"] = strSiteCode;
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"])
{
Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>");
Response.End();
}
//上传主队图像
string strIconFileName0 = string.Empty; //图像路径
string strIconSaveFileName0 = string.Empty; //网址路径
try
{
if (this.file0.PostedFile.FileName == "")
{
strIconSaveFileName0 = "";
}
else
{
if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/Images"))
{
System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/Images");
}
if (!System.IO.Directory.Exists(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString())))
{
System.IO.Directory.CreateDirectory(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString()));
}
string orignalName = this.file0.PostedFile.FileName; //获取客户机上传文件的文件名
string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名
if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png")
{
MessageBox.Show(this, "文件格式有误！");
return;
}//检查文件格式
string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file0.PostedFile.ContentLength, extendName);//对文件进行重命名
strIconFileName0 = String.Format(@"{0}Images/{1}/{2}", Server.MapPath("~"), Session["strSiteCode"].ToString(), newName);
strIconSaveFileName0 = String.Format(@"Images/{0}/{1}", Session["strSiteCode"].ToString(), newName);
file0.PostedFile.SaveAs(strIconFileName0);
}
}
catch (Exception ex)
{
MessageBox.Show(this, "上传发生错误！原因是：" + ex.ToString());
}
//上传客队图像
string strIconFileName1 = string.Empty; //图像路径
string strIconSaveFileName1 = string.Empty; //网址路径
try
{
if (this.file1.PostedFile.FileName == "")
{
strIconSaveFileName1 = "";
}
else
{
if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/Images"))
{
System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/Images");
}
if (!System.IO.Directory.Exists(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString())))
{
System.IO.Directory.CreateDirectory(String.Format(@"{0}/Images/{1}", Server.MapPath("~"), Session["strSiteCode"].ToString()));
}
string orignalName = this.file1.PostedFile.FileName; //获取客户机上传文件的文件名
string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名
if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png")
{
MessageBox.Show(this, "文件格式有误！");
return;
}//检查文件格式
string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file1.PostedFile.ContentLength, extendName);//对文件进行重命名
strIconFileName1 = String.Format(@"{0}Images/{1}/{2}", Server.MapPath("~"), Session["strSiteCode"].ToString(), newName);
strIconSaveFileName1 = String.Format(@"Images/{0}/{1}", Session["strSiteCode"].ToString(), newName);
file1.PostedFile.SaveAs(strIconFileName1);
}
}
catch (Exception ex)
{
MessageBox.Show(this, "上传发生错误！原因是：" + ex.ToString());
}
if (txtName.Text.Trim() != null && txtName.Text.Trim() != "")
{
JC_Quiz model = new JC_Quiz();
JC_QuizDAL dal = new JC_QuizDAL();
model.SiteCode = Session["strSiteCode"].ToString();
model.Name = txtName.Text;
model.HomeTeam = hometeam.Text;
model.HomeTeamImg = strIconSaveFileName0;
model.VisitingTeam = VisitingTeam.Text;
model.VisitingTeamImg = strIconSaveFileName1;
model.StartTime = Convert.ToDateTime(starttime.Text);
model.MatchDesc = hd_content.Value;
model.ID = Guid.NewGuid().ToString("N").ToUpper();
model.State = 0;
model.QuizType = "0";
if (dal.AddJCQuiz(model))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "请输入信息名称后再操作！");
}
}
