public bool UpdateCheck(Maticsoft.Model.NewPort.Table_project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Table_project set ");
strSql.Append("project_check=@project_check");
strSql.Append(" where project_id=@project_id ");
SqlParameter[] parameters =
{
new SqlParameter("@project_check", SqlDbType.Char, 10),
new SqlParameter("@project_id", SqlDbType.Char, 8)
};
parameters[0].Value = model.project_check;
parameters[1].Value = model.project_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string str = "";
if (radioyes.Checked == true || radiono.Checked == true)
{
if (radioyes.Checked)
{
str = "审核通过";
}
if (radiono.Checked)
{
str = "审核未通过";
}
Maticsoft.Model.NewPort.Table_project model = new Maticsoft.Model.NewPort.Table_project();
model.project_id = strid;
model.project_check = str;
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
bll.UpdateCheck(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "Plan_Check.aspx");
}
else
{
Response.Write("<script>alert('请先进行审核！');</script>");
}
}
private void ShowInfo(string strid)
{
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
Maticsoft.Model.NewPort.Table_project model = bll.GetModel(strid);
this.lbl_number.Text = model.project_id.ToString();
this.lbl_type.Text = model.project_type.ToString();
this.lbl_name.Text = model.project_name.ToString();
this.lbl_owner.Text = model.project_owner.ToString();
this.lbl_address.Text = model.project_positon.ToString();
this.lbl_apc.Text = model.project_designCapacity.ToString();
this.lbl_dis.Text = model.project_coveredArea.ToString();
this.lbl_money.Text = model.project_totalInvestment.ToString();
this.lbl_startyear.Text = string.Format("{0:d}", model.project_constrStartTime);
this.lbl_overyear.Text = string.Format("{0:d}", model.project_constrEndTime);
this.TextContent.Text = model.project_constrContent.ToString();
/*
* string radiobuttonvalue = model.project_check.ToString();
* if (radiobuttonvalue == "审核通过")
* {
* this.radiono.Checked = false;
* this.radioyes.Checked = true;
* }
* if (radiobuttonvalue == "审核未通过")
* {
* this.radiono.Checked = true;
* this.radioyes.Checked = false;
* }
* else
* {
* this.radioyes.Checked = false;
* this.radiono.Checked = false;
* }
* Label1.Text = radiobuttonvalue;*/
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
Maticsoft.Model.NewPort.Table_project model = new Maticsoft.Model.NewPort.Table_project();
model.project_id = lbl_number.Text;
model.project_name = this.txtName.Text;
model.project_owner = this.txtOwner.Text;
model.project_positon = this.txtAddress.Text;
model.project_designCapacity = decimal.Parse(this.txtCapacity.Text.Trim());
model.project_coveredArea = decimal.Parse(this.txtCoast.Text);
model.project_totalInvestment = decimal.Parse(this.txtTotal.Text);
model.project_check = "待审核";
model.project_constrStartTime = Convert.ToDateTime(this.input1.Value);
model.project_constrEndTime = Convert.ToDateTime(this.input2.Value);
model.project_constrContent = this.txtA2.Value;
model.project_writer = strid;
model.project_state = "新开工";
model.project_type = DDL_PlayType.SelectedValue.Trim();
model.project_year = DDL_Year.SelectedValue.Trim();
model.project_class = DropDownList_PlanType.SelectedValue.Trim();
model.project_area = txtArea.Text;
model.project_scale = decimal.Parse(txtCoast.Text);
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "planSearch.aspx");
}
catch (Exception e2) {
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "填写错误，请重新确认后再提交！", "addnewplan.aspx");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.NewPort.Table_project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Table_project(");
strSql.Append("project_id,project_responUnit,project_name,project_owner,project_positon,project_type,project_constrContent,project_scale,project_designCapacity,project_designCapacityUnit,project_designCapacityRemarks,project_totalInvestment,project_constrStartTime,project_constrEndTime,project_coveredArea,project_state,project_stateChangedTime)");
strSql.Append(" values (");
strSql.Append("@project_id,@project_responUnit,@project_name,@project_owner,@project_positon,@project_type,@project_constrContent,@project_scale,@project_designCapacity,@project_designCapacityUnit,@project_designCapacityRemarks,@project_totalInvestment,@project_constrStartTime,@project_constrEndTime,@project_coveredArea,@project_state,@project_stateChangedTime)");
SqlParameter[] parameters =
{
new SqlParameter("@project_id", SqlDbType.Char, 8),
new SqlParameter("@project_responUnit", SqlDbType.NVarChar, 20),
new SqlParameter("@project_name", SqlDbType.NVarChar, 30),
new SqlParameter("@project_owner", SqlDbType.NVarChar, 30),
new SqlParameter("@project_positon", SqlDbType.NVarChar, 30),
new SqlParameter("@project_type", SqlDbType.NVarChar, 10),
new SqlParameter("@project_constrContent", SqlDbType.NText),
new SqlParameter("@project_scale", SqlDbType.Float, 8),
new SqlParameter("@project_designCapacity", SqlDbType.Float, 8),
new SqlParameter("@project_designCapacityUnit", SqlDbType.NChar, 10),
new SqlParameter("@project_designCapacityRemarks", SqlDbType.NVarChar, 50),
new SqlParameter("@project_totalInvestment", SqlDbType.Float, 8),
new SqlParameter("@project_constrStartTime", SqlDbType.DateTime),
new SqlParameter("@project_constrEndTime", SqlDbType.DateTime),
new SqlParameter("@project_coveredArea", SqlDbType.Float, 8),
new SqlParameter("@project_state", SqlDbType.NVarChar, 10),
new SqlParameter("@project_stateChangedTime", SqlDbType.DateTime)
};
parameters[0].Value = model.project_id;
parameters[1].Value = model.project_responUnit;
parameters[2].Value = model.project_name;
parameters[3].Value = model.project_owner;
parameters[4].Value = model.project_positon;
parameters[5].Value = model.project_type;
parameters[6].Value = model.project_constrContent;
parameters[7].Value = model.project_scale;
parameters[8].Value = model.project_designCapacity;
parameters[9].Value = model.project_designCapacityUnit;
parameters[10].Value = model.project_designCapacityRemarks;
parameters[11].Value = model.project_totalInvestment;
parameters[12].Value = model.project_constrStartTime;
parameters[13].Value = model.project_constrEndTime;
parameters[14].Value = model.project_coveredArea;
parameters[15].Value = model.project_state;
parameters[16].Value = model.project_stateChangedTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateData1(Maticsoft.Model.NewPort.Table_project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Table_project set ");
strSql.Append("project_name=@project_name,");
strSql.Append("project_owner=@project_owner,");
strSql.Append("project_positon=@project_positon,");
strSql.Append("project_designCapacity=@project_designCapacity,");
strSql.Append("project_coveredArea=@project_coveredArea,");
strSql.Append("project_totalInvestment=@project_totalInvestment,");
strSql.Append("project_constrStartTime=@project_constrStartTime,");
strSql.Append("project_constrEndTime=@project_constrEndTime,");
strSql.Append("project_constrContent=@project_constrContent,");
strSql.Append("project_state=@project_state");
strSql.Append(" where project_id=@project_id ");
SqlParameter[] parameters =
{
new SqlParameter("@project_name", SqlDbType.NVarChar, 30),
new SqlParameter("@project_owner", SqlDbType.NVarChar, 30),
new SqlParameter("@project_positon", SqlDbType.NVarChar, 30),
new SqlParameter("@project_designCapacity", SqlDbType.Float, 8),
new SqlParameter("@project_coveredArea", SqlDbType.Float, 8),
new SqlParameter("@project_totalInvestment", SqlDbType.Float, 8),
new SqlParameter("@project_constrStartTime", SqlDbType.DateTime),
new SqlParameter("@project_constrEndTime", SqlDbType.DateTime),
new SqlParameter("@project_constrContent", SqlDbType.NText),
new SqlParameter("@project_state", SqlDbType.NVarChar, 10),
new SqlParameter("@project_id", SqlDbType.Char, 8)
};
parameters[0].Value = model.project_name;
parameters[1].Value = model.project_owner;
parameters[2].Value = model.project_positon;
parameters[3].Value = model.project_designCapacity;
parameters[4].Value = model.project_coveredArea;
parameters[5].Value = model.project_totalInvestment;
parameters[6].Value = model.project_constrStartTime;
parameters[7].Value = model.project_constrEndTime;
parameters[8].Value = model.project_constrContent;
parameters[9].Value = model.project_state;
parameters[10].Value = model.project_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(string estrid)
{
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
Maticsoft.Model.NewPort.Table_project model = bll.GetModel(sfid);
this.lbl_enumber.Text = model.project_id.ToString();
this.lbl_PlanType.Text = model.project_type.ToString();
this.lbl_ename.Text = model.project_name.ToString();
this.lbl_eowner.Text = model.project_owner.ToString();
this.lbl_eaddress.Text = model.project_positon.ToString();
this.lbl_emoney.Text = model.project_totalInvestment.ToString();
}
private void mShowInfo(string strid)
{
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
Maticsoft.Model.NewPort.Table_project model = bll.GetModel(strid);
this.lbl_mnumber.Text = model.project_id.ToString();
this.lbl_mtype.Text = model.project_type.ToString();
this.lbl_mname.Text = model.project_name.ToString();
this.lbl_mowner.Text = model.project_owner.ToString();
this.lbl_maddress.Text = model.project_positon.ToString();
this.lbl_mapc.Text = model.project_designCapacity.ToString();
this.lbl_mdis.Text = model.project_coveredArea.ToString();
this.lbl_mmoney.Text = model.project_totalInvestment.ToString();
this.lbl_mstartyear.Text = model.project_constrStartTime.ToString();
this.lbl_moveryear.Text = model.project_constrEndTime.ToString();
}
private void eShowInfo(string estrid)
{
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
Maticsoft.Model.NewPort.Table_project model = bll.GetModel(estrid);
this.lbl_enumber.Text = model.project_id.ToString();
this.input1.Value = string.Format("{0:d}", model.project_constrStartTime);
this.input2.Value = string.Format("{0:d}", model.project_constrEndTime);
this.lbl_ename.Text = model.project_name.ToString();
this.lbl_eowner.Text = model.project_owner.ToString();
this.lbl_eaddress.Text = model.project_positon.ToString();
this.lbl_eapc.Text = model.project_designCapacity.ToString();
this.lbl_edis.Text = model.project_coveredArea.ToString();
this.lbl_emoney.Text = model.project_totalInvestment.ToString();
this.eTextContent.Text = model.project_constrContent.ToString();
this.DDLState.SelectedValue = model.project_state.ToString();
}
protected void btneSubmit_Click(object sender, EventArgs e)
{
Maticsoft.Model.NewPort.Table_project model = new Maticsoft.Model.NewPort.Table_project();
model.project_name = this.lbl_ename.Text;
model.project_owner = this.lbl_eowner.Text;
model.project_positon = this.lbl_eaddress.Text;
model.project_designCapacity = decimal.Parse(this.lbl_eapc.Text);
model.project_coveredArea = decimal.Parse(this.lbl_edis.Text);
model.project_totalInvestment = decimal.Parse(this.lbl_emoney.Text);
model.project_constrContent = this.eTextContent.Text;
model.project_constrStartTime = Convert.ToDateTime(this.input1.Value);
model.project_constrEndTime = Convert.ToDateTime(this.input2.Value);
model.project_state = this.DDLState.SelectedValue;
model.project_id = estrid;
UpdateData1(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "Plan_Management.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.NewPort.Table_project GetModel(string project_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 project_id,project_responUnit,project_name,project_owner,project_positon,project_type,project_constrContent,project_scale,project_designCapacity,project_designCapacityUnit,project_designCapacityRemarks,project_totalInvestment,project_constrStartTime,project_constrEndTime,project_coveredArea,project_state,project_stateChangedTime from Table_project ");
strSql.Append(" where project_id=@project_id ");
SqlParameter[] parameters =
{
new SqlParameter("@project_id", SqlDbType.Char, 8)
};
parameters[0].Value = project_id;
Maticsoft.Model.NewPort.Table_project model = new Maticsoft.Model.NewPort.Table_project();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
Maticsoft.Model.NewPort.Table_project model = bll.GetModel(DropDownList1.SelectedValue.ToString().Trim());
this.lblName.Text = model.project_name.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.NewPort.Table_project DataRowToModel(DataRow row)
{
Maticsoft.Model.NewPort.Table_project model = new Maticsoft.Model.NewPort.Table_project();
if (row != null)
{
if (row["project_id"] != null)
{
model.project_id = row["project_id"].ToString();
}
if (row["project_responUnit"] != null)
{
model.project_id = row["project_responUnit"].ToString();
}
if (row["project_name"] != null)
{
model.project_name = row["project_name"].ToString();
}
if (row["project_owner"] != null)
{
model.project_owner = row["project_owner"].ToString();
}
if (row["project_positon"] != null)
{
model.project_positon = row["project_positon"].ToString();
}
if (row["project_type"] != null)
{
model.project_type = row["project_type"].ToString();
}
if (row["project_constrContent"] != null)
{
model.project_constrContent = row["project_constrContent"].ToString();
}
if (row["project_scale"] != null && row["project_scale"].ToString() != "")
{
model.project_scale = decimal.Parse(row["project_scale"].ToString());
}
if (row["project_designCapacity"] != null && row["project_designCapacity"].ToString() != "")
{
model.project_designCapacity = decimal.Parse(row["project_designCapacity"].ToString());
}
if (row["project_designCapacityUnit"] != null)
{
model.project_designCapacityUnit = row["project_designCapacityUnit"].ToString();
}
if (row["project_designCapacityRemarks"] != null)
{
model.project_designCapacityRemarks = row["project_designCapacityRemarks"].ToString();
}
if (row["project_totalInvestment"] != null && row["project_totalInvestment"].ToString() != "")
{
model.project_totalInvestment = decimal.Parse(row["project_totalInvestment"].ToString());
}
if (row["project_constrStartTime"] != null && row["project_constrStartTime"].ToString() != "")
{
model.project_constrStartTime = DateTime.Parse(row["project_constrStartTime"].ToString());
}
if (row["project_constrEndTime"] != null && row["project_constrEndTime"].ToString() != "")
{
model.project_constrEndTime = DateTime.Parse(row["project_constrEndTime"].ToString());
}
if (row["project_coveredArea"] != null && row["project_coveredArea"].ToString() != "")
{
model.project_coveredArea = decimal.Parse(row["project_coveredArea"].ToString());
}
if (row["project_state"] != null)
{
model.project_state = row["project_state"].ToString();
}
if (row["project_stateChangedTime"] != null && row["project_stateChangedTime"].ToString() != "")
{
model.project_stateChangedTime = DateTime.Parse(row["project_stateChangedTime"].ToString());
}
}
return(model);
}
