/// <summary>
/// 获得数据列表
/// </summary>
public List <ParkInfoM> DataTableToList(DataTable dt)
{
List <ParkInfoM> modelList = new List <ParkInfoM>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
ParkInfoM model;
for (int n = 0; n < rowsCount; n++)
{
model = new ParkInfoM();
if (dt.Rows[n]["parkid"].ToString() != "")
{
model.parkid = int.Parse(dt.Rows[n]["parkid"].ToString());
}
model.parkName = dt.Rows[n]["parkName"].ToString();
if (dt.Rows[n]["parktypeid"].ToString() != "")
{
model.parktypeid = int.Parse(dt.Rows[n]["parktypeid"].ToString());
}
model.Chineseintroduced = dt.Rows[n]["Chineseintroduced"].ToString();
model.Englishintroduction = dt.Rows[n]["Englishintroduction"].ToString();
if (dt.Rows[n]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(dt.Rows[n]["CreateDate"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
string ParkTem = ConfigurationManager.AppSettings["ParkTemplate"].ToString(); //其他成功案例模版存放位置
public int StaticHtml(int id, string loginName)
{
try
{
string TempFileName = ParkTem.ToString();
string Tem = Compage.Reader(TempFileName); //读取模板内容
string TempSoure = Tem;
if (id == 0)
{
parkM = parkBLL.GetParkByLoginName(loginName);
}
else
{
parkM = parkBLL.GetModel(id);
}
TempSoure = TempSoure.Replace("$ParkID$", parkM.parkid.ToString().Trim());
string ids = "";
int scriptId = 0;
TempSoure = TempSoure.Replace("$typeName$", type(ref ids, ref scriptId, loginName));
TempSoure = TempSoure.Replace("$style$", types(ids));
TempSoure = TempSoure.Replace("$ChinaName$", content(ids, loginName));
TempSoure = TempSoure.Replace("$loginName$", loginName);
CompanyShow com = new CompanyShow();
TempSoure = TempSoure.Replace("$CompanyName$", com.GetCompanyNameByLoginName(loginName));
//TempSoure = TempSoure.Replace("$ProductScript$", script(scriptId));
TempSoure = TempSoure.Replace("$ParkScript$", scriptId.ToString());
if (string.IsNullOrEmpty(parkM.htmlurl))
{
parkM.htmlurl = "Park.htm";
}
string htmlFile = "Park.htm";//parkM.htmlurl;
string wenjian = ParkPath + loginName;
if (!Directory.Exists(wenjian))
{
Directory.CreateDirectory(wenjian);
}
string htmlpaths = wenjian + "/" + htmlFile;
Compage.Writer(htmlpaths, TempSoure);
return(1);
}
catch (Exception e)
{
return(0);
}
}
public ParkInfoM GetModel(int parktypeid, string loginName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 loginName,parkid,parkName,parktypeid,Chineseintroduced,Englishintroduction,CreateDate from parkInfoTab ");
strSql.Append(" where parktypeid=@parktypeid and loginName=@loginName");
SqlParameter[] parameters =
{
new SqlParameter("@parktypeid", SqlDbType.Int, 4),
new SqlParameter("@loginName", SqlDbType.VarChar, 50)
};
parameters[0].Value = parktypeid;
parameters[1].Value = loginName;
ParkInfoM model = new ParkInfoM();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["parkid"].ToString() != "")
{
model.parkid = int.Parse(ds.Tables[0].Rows[0]["parkid"].ToString());
}
model.loginName = ds.Tables[0].Rows[0]["loginName"].ToString();
model.parkName = ds.Tables[0].Rows[0]["parkName"].ToString();
if (ds.Tables[0].Rows[0]["parktypeid"].ToString() != "")
{
model.parktypeid = int.Parse(ds.Tables[0].Rows[0]["parktypeid"].ToString());
}
model.Chineseintroduced = ds.Tables[0].Rows[0]["Chineseintroduced"].ToString();
model.Englishintroduction = ds.Tables[0].Rows[0]["Englishintroduction"].ToString();
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ParkInfoM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update parkInfoTab set ");
strSql.Append("parkName=@parkName,");
strSql.Append("parktypeid=@parktypeid,");
strSql.Append("Chineseintroduced=@Chineseintroduced,");
strSql.Append("Englishintroduction=@Englishintroduction,");
strSql.Append("htmlurl=@htmlurl");
strSql.Append(" where parkid=@parkid");
SqlParameter[] parameters =
{
new SqlParameter("@parkid", SqlDbType.Int, 4),
new SqlParameter("@parkName", SqlDbType.VarChar, 50),
new SqlParameter("@parktypeid", SqlDbType.Int, 4),
new SqlParameter("@Chineseintroduced", SqlDbType.Text),
new SqlParameter("@Englishintroduction", SqlDbType.Text),
new SqlParameter("@htmlurl", SqlDbType.VarChar, 120)
};
parameters[0].Value = model.parkid;
parameters[1].Value = model.parkName;
parameters[2].Value = model.parktypeid;
parameters[3].Value = model.Chineseintroduced;
parameters[4].Value = model.Englishintroduction;
parameters[5].Value = model.htmlurl;
int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void bindModel(int id)
{
parkM = parkBll.GetModel(id, ViewState["name"].ToString());
if (parkM != null)
{
//titles = "修改园区信息";
//txtProductName.Text = parkM.productName.Trim();
//ddlName.SelectedValue = typeBll.GetList("parktypeid=" + parkM.parktypeid).Tables[0].Rows[0]["parktypeid"].ToString();
txtChina.Text = parkM.Chineseintroduced.ToString().Trim();
txtEnglish.Text = parkM.Englishintroduction.ToString().Trim();
DataSet ds = imgBLL.GetList("parkid=" + parkM.parkid);
if ((ds != null) && (ds.Tables[0].Rows.Count > 0))
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
str += dr["imgName"].ToString() + "%";
mingche += dr["imgexplain"].ToString() + "%";
}
DataList1.DataSource = ds;
DataList1.DataBind();
photo.Attributes.Add("style", "display:''");
}
else
{
photo.Attributes.Add("style", "display:none");
}
btnUpdate.Visible = true;
Button1.Visible = false;
}
else
{
//titles = "添加园区信息";
Button1.Visible = true;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ParkInfoM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into parkInfoTab(");
strSql.Append("parkName,parktypeid,Chineseintroduced,Englishintroduction,CreateDate,loginName,htmlurl)");
strSql.Append(" values (");
strSql.Append("@parkName,@parktypeid,@Chineseintroduced,@Englishintroduction,getdate(),@loginName,@htmlurl)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@parkName", SqlDbType.VarChar, 50),
new SqlParameter("@parktypeid", SqlDbType.Int, 4),
new SqlParameter("@Chineseintroduced", SqlDbType.Text),
new SqlParameter("@Englishintroduction", SqlDbType.Text),
new SqlParameter("@loginName", SqlDbType.VarChar, 50),
new SqlParameter("@htmlurl", SqlDbType.VarChar, 120)
};
parameters[0].Value = model.parkName;
parameters[1].Value = model.parktypeid;
parameters[2].Value = model.Chineseintroduced;
parameters[3].Value = model.Englishintroduction;
parameters[4].Value = model.loginName;
parameters[5].Value = model.htmlurl;
object obj = DBHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ParkInfoM model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ParkInfoM model)
{
return(dal.Add(model));
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
//if (parkBll.ExistsByParkTypeId(int.Parse(ddlName.SelectedValue.ToString())) <= 1)
//{
parkM = parkBll.GetModel(int.Parse(ViewState["parkid"].ToString()), ViewState["name"].ToString());
//parkM.productid = ;
if (string.IsNullOrEmpty(parkM.htmlurl))
{
parkM.htmlurl = "Park.htm";
//parkM.htmlurl = parkM.loginName + "/park" + parkM.loginName + ".htm";
}
parkM.Chineseintroduced = txtChina.Text.Trim();
parkM.Englishintroduction = txtEnglish.Text.Trim();
//parkM.parktypeid = int.Parse(ddlName.SelectedValue.ToString());
parkM.parkName = ViewState["name"].ToString();// ddlName.SelectedItem.Text.ToString();
//parkM.loginName = loginName;
bool flag = false;
if (parkBll.Update(parkM))
{
if (ViewState["update"].Equals("true"))
{
imgBLL.DeleteByParkId(parkM.parkid);
if (DataList1.Items.Count > 0)
{
foreach (DataListItem item in DataList1.Items)
{
CheckBox ck = (CheckBox)item.FindControl("chckimage");
HiddenField fid = (HiddenField)item.FindControl("HiddenField1");
HiddenField fid2 = (HiddenField)item.FindControl("HiddenField2");
imgM.parkId = parkM.parkid;
imgM.imgName = fid.Value.Trim();
imgM.imgexplain = fid2.Value.Trim();
if (imgBLL.Add(imgM) > 0)
{
flag = true;
}
}
}
else
{
flag = true;
}
}
else
{
flag = true;
}
}
if (flag)
{
StaticPark pro = new StaticPark();
int num = pro.StaticHtml(parkM.parkid, ViewState["name"].ToString());
//AreaIndexBLL areaBll = new AreaIndexBLL();
//areaBll.AreaHtml(loginName, 3);
if (num > 0)
{
flag = true;
}
}
if (!flag)
{
Response.Write("<script>alert('修改失败！');</script>");
//Response.Write("<script>alert('修改失败！');document.location='ParkManage.aspx'</script>");
}
else
{
Response.Write("<script>alert('修改成功！');location.href='ParkManage.aspx';</script>");
//Response.Redirect("ParkManage.aspx");
}
//}
//else
//{
// Response.Write("<script>alert('此类型己被您添加！请选择其它类型');</script>");
//}
}
private string content(string id, string loginName)
{
StringBuilder str = new StringBuilder();
string[] strId = id.Split(',');
for (int j = 0; j < strId.Length - 1; j++)
{
parkM = parkBLL.GetModel(int.Parse(strId[j]));
if (parkM != null)
{
str.Append("<div id=\"cy_con_" + strId[j] + "\">");
str.Append("<div class=\"envuroment-right1\">");
str.Append(parkM.Chineseintroduced.ToString() + "</div>");
str.Append("<div class=\"envuroment-right1\">");
str.Append(parkM.Englishintroduction.ToString() + "</div>");
str.Append("<div class=\"envuroment-right2\">");
ParkImgDAL imbll = new ParkImgDAL();
ParkImgM imM = new ParkImgM();
if (parkM.parkid > 0)
{
DataSet ds = imbll.GetList(" parkid=" + parkM.parkid);
if ((ds != null) && ds.Tables[0].Rows.Count > 0)
{
int count = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
count++;
DataRow dr = ds.Tables[0].Rows[i];
if (i == 0)
{
str.Append("<ul>");
str.Append("<li class='l'> <img src=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\">");
if (!string.IsNullOrEmpty(dr["imgexplain"].ToString()) && dr["imgexplain"].ToString().Length > 1)
{
str.Append("<p style=\"text-align:center\">" + dr["imgexplain"].ToString().Substring(1, dr["imgexplain"].ToString().Length - 1) + "</p>");
//str.Append("<p><br/></p>");
str.Append("</li>");
}
else
{
str.Append("<p><br/></p>");
}
if (ds.Tables[0].Rows.Count <= 1)
{
str.Append("</ul></div>");
}
}
else if (i == 1)
{
str.Append("<li class='r'> <img src=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\">");
if (!string.IsNullOrEmpty(dr["imgexplain"].ToString()) && dr["imgexplain"].ToString().Length > 1)
{
str.Append("<p style=\"text-align:center\">" + dr["imgexplain"].ToString().Substring(1, dr["imgexplain"].ToString().Length - 1) + "</p>");
//str.Append("<p><br/></p>");
str.Append("</li>");
}
else
{
str.Append("<p><br/></p>");
}
str.Append("</li></ul></div>");
break;
}
}
if (count > 1)
{
for (int k = count; k < ds.Tables[0].Rows.Count; k++)
{
DataRow dr = ds.Tables[0].Rows[k];
str.Append("<div class=\"envuroment-right" + k + "\"> <img src=\"http://dp.topfo.com/img/" + loginName + "/" + dr["imgName"].ToString() + "\">");
if (!string.IsNullOrEmpty(dr["imgexplain"].ToString()) && dr["imgexplain"].ToString().Length > 1)
{
str.Append("<p style=\"text-align:center\">" + dr["imgexplain"].ToString().Substring(1, dr["imgexplain"].ToString().Length - 1) + "</p>");
//str.Append("<p><br/></p>");
str.Append("</li>");
}
else
{
str.Append("<p><br/></p>");
}
str.Append("</div>");
}
}
}
else
{
str.Append("</div>");
}
}
str.Append("</div>");
}
else
{
str.Append("<div id=\"cy_con_" + strId[j] + "\">");
str.Append("暂无数据");
str.Append("</div>");
}
}
return(str.ToString());
}
