/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewPort.projecttable GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 project_id,project_name,project_state,project_type,project_area,project_unit,project_place,peoject_content,project_mileage,peoject_capacity,project_totalinvestment,project_startend,investmentin2014,investuntil2014,investmentin2015,totalinvestment,planaccounting,schedule,occupies from projecttable "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.NewPort.projecttable model = new Maticsoft.Model.NewPort.projecttable(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.NewPort.projecttable model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update projecttable set "); strSql.Append("project_id=@project_id,"); strSql.Append("project_name=@project_name,"); strSql.Append("project_state=@project_state,"); strSql.Append("project_type=@project_type,"); strSql.Append("project_area=@project_area,"); strSql.Append("project_unit=@project_unit,"); strSql.Append("project_place=@project_place,"); strSql.Append("peoject_content=@peoject_content,"); strSql.Append("project_mileage=@project_mileage,"); strSql.Append("peoject_capacity=@peoject_capacity,"); strSql.Append("project_totalinvestment=@project_totalinvestment,"); strSql.Append("project_startend=@project_startend,"); strSql.Append("investmentin2014=@investmentin2014,"); strSql.Append("investuntil2014=@investuntil2014,"); strSql.Append("investmentin2015=@investmentin2015,"); strSql.Append("totalinvestment=@totalinvestment,"); strSql.Append("planaccounting=@planaccounting,"); strSql.Append("schedule=@schedule,"); strSql.Append("occupies=@occupies"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@project_id", SqlDbType.Float, 8), new SqlParameter("@project_name", SqlDbType.NVarChar, 255), new SqlParameter("@project_state", SqlDbType.NVarChar, 255), new SqlParameter("@project_type", SqlDbType.NVarChar, 255), new SqlParameter("@project_area", SqlDbType.NVarChar, 255), new SqlParameter("@project_unit", SqlDbType.NVarChar, 255), new SqlParameter("@project_place", SqlDbType.NVarChar, 255), new SqlParameter("@peoject_content", SqlDbType.NVarChar, 255), new SqlParameter("@project_mileage", SqlDbType.Float, 8), new SqlParameter("@peoject_capacity", SqlDbType.NVarChar, 255), new SqlParameter("@project_totalinvestment", SqlDbType.Float, 8), new SqlParameter("@project_startend", SqlDbType.NVarChar, 255), new SqlParameter("@investmentin2014", SqlDbType.Float, 8), new SqlParameter("@investuntil2014", SqlDbType.Float, 8), new SqlParameter("@investmentin2015", SqlDbType.Float, 8), new SqlParameter("@totalinvestment", SqlDbType.Float, 8), new SqlParameter("@planaccounting", SqlDbType.Float, 8), new SqlParameter("@schedule", SqlDbType.NVarChar, 255), new SqlParameter("@occupies", SqlDbType.Float, 8) }; parameters[0].Value = model.project_id; parameters[1].Value = model.project_name; parameters[2].Value = model.project_state; parameters[3].Value = model.project_type; parameters[4].Value = model.project_area; parameters[5].Value = model.project_unit; parameters[6].Value = model.project_place; parameters[7].Value = model.peoject_content; parameters[8].Value = model.project_mileage; parameters[9].Value = model.peoject_capacity; parameters[10].Value = model.project_totalinvestment; parameters[11].Value = model.project_startend; parameters[12].Value = model.investmentin2014; parameters[13].Value = model.investuntil2014; parameters[14].Value = model.investmentin2015; parameters[15].Value = model.totalinvestment; parameters[16].Value = model.planaccounting; parameters[17].Value = model.schedule; parameters[18].Value = model.occupies; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.NewPort.projecttable model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into projecttable("); strSql.Append("project_id,project_name,project_state,project_type,project_area,project_unit,project_place,peoject_content,project_mileage,peoject_capacity,project_totalinvestment,project_startend,investmentin2014,investuntil2014,investmentin2015,totalinvestment,planaccounting,schedule,occupies)"); strSql.Append(" values ("); strSql.Append("@project_id,@project_name,@project_state,@project_type,@project_area,@project_unit,@project_place,@peoject_content,@project_mileage,@peoject_capacity,@project_totalinvestment,@project_startend,@investmentin2014,@investuntil2014,@investmentin2015,@totalinvestment,@planaccounting,@schedule,@occupies)"); SqlParameter[] parameters = { new SqlParameter("@project_id", SqlDbType.Float, 8), new SqlParameter("@project_name", SqlDbType.NVarChar, 255), new SqlParameter("@project_state", SqlDbType.NVarChar, 255), new SqlParameter("@project_type", SqlDbType.NVarChar, 255), new SqlParameter("@project_area", SqlDbType.NVarChar, 255), new SqlParameter("@project_unit", SqlDbType.NVarChar, 255), new SqlParameter("@project_place", SqlDbType.NVarChar, 255), new SqlParameter("@peoject_content", SqlDbType.NVarChar, 255), new SqlParameter("@project_mileage", SqlDbType.Float, 8), new SqlParameter("@peoject_capacity", SqlDbType.NVarChar, 255), new SqlParameter("@project_totalinvestment", SqlDbType.Float, 8), new SqlParameter("@project_startend", SqlDbType.NVarChar, 255), new SqlParameter("@investmentin2014", SqlDbType.Float, 8), new SqlParameter("@investuntil2014", SqlDbType.Float, 8), new SqlParameter("@investmentin2015", SqlDbType.Float, 8), new SqlParameter("@totalinvestment", SqlDbType.Float, 8), new SqlParameter("@planaccounting", SqlDbType.Float, 8), new SqlParameter("@schedule", SqlDbType.NVarChar, 255), new SqlParameter("@occupies", SqlDbType.Float, 8) }; parameters[0].Value = model.project_id; parameters[1].Value = model.project_name; parameters[2].Value = model.project_state; parameters[3].Value = model.project_type; parameters[4].Value = model.project_area; parameters[5].Value = model.project_unit; parameters[6].Value = model.project_place; parameters[7].Value = model.peoject_content; parameters[8].Value = model.project_mileage; parameters[9].Value = model.peoject_capacity; parameters[10].Value = model.project_totalinvestment; parameters[11].Value = model.project_startend; parameters[12].Value = model.investmentin2014; parameters[13].Value = model.investuntil2014; parameters[14].Value = model.investmentin2015; parameters[15].Value = model.totalinvestment; parameters[16].Value = model.planaccounting; parameters[17].Value = model.schedule; parameters[18].Value = model.occupies; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewPort.projecttable DataRowToModel(DataRow row) { Maticsoft.Model.NewPort.projecttable model = new Maticsoft.Model.NewPort.projecttable(); if (row != null) { if (row["project_id"] != null && row["project_id"].ToString() != "") { model.project_id = decimal.Parse(row["project_id"].ToString()); } if (row["project_name"] != null) { model.project_name = row["project_name"].ToString(); } if (row["project_state"] != null) { model.project_state = row["project_state"].ToString(); } if (row["project_type"] != null) { model.project_type = row["project_type"].ToString(); } if (row["project_area"] != null) { model.project_area = row["project_area"].ToString(); } if (row["project_unit"] != null) { model.project_unit = row["project_unit"].ToString(); } if (row["project_place"] != null) { model.project_place = row["project_place"].ToString(); } if (row["peoject_content"] != null) { model.peoject_content = row["peoject_content"].ToString(); } if (row["project_mileage"] != null && row["project_mileage"].ToString() != "") { model.project_mileage = decimal.Parse(row["project_mileage"].ToString()); } if (row["peoject_capacity"] != null) { model.peoject_capacity = row["peoject_capacity"].ToString(); } if (row["project_totalinvestment"] != null && row["project_totalinvestment"].ToString() != "") { model.project_totalinvestment = decimal.Parse(row["project_totalinvestment"].ToString()); } if (row["project_startend"] != null) { model.project_startend = row["project_startend"].ToString(); } if (row["investmentin2014"] != null && row["investmentin2014"].ToString() != "") { model.investmentin2014 = decimal.Parse(row["investmentin2014"].ToString()); } if (row["investuntil2014"] != null && row["investuntil2014"].ToString() != "") { model.investuntil2014 = decimal.Parse(row["investuntil2014"].ToString()); } if (row["investmentin2015"] != null && row["investmentin2015"].ToString() != "") { model.investmentin2015 = decimal.Parse(row["investmentin2015"].ToString()); } if (row["totalinvestment"] != null && row["totalinvestment"].ToString() != "") { model.totalinvestment = decimal.Parse(row["totalinvestment"].ToString()); } if (row["planaccounting"] != null && row["planaccounting"].ToString() != "") { model.planaccounting = decimal.Parse(row["planaccounting"].ToString()); } if (row["schedule"] != null) { model.schedule = row["schedule"].ToString(); } if (row["occupies"] != null && row["occupies"].ToString() != "") { model.occupies = decimal.Parse(row["occupies"].ToString()); } } return(model); }