/// <summary> /// 得到一个对象实体 /// </summary> public Haikan.SchoolProjectsCore.MDB.Model.Eenterprises DataRowToModel(DataRow row) { Haikan.SchoolProjectsCore.MDB.Model.Eenterprises model = new Haikan.SchoolProjectsCore.MDB.Model.Eenterprises(); if (row != null) { if (row["EnterpriseID"] != null && row["EnterpriseID"].ToString() != "") { model.EnterpriseID = int.Parse(row["EnterpriseID"].ToString()); } if (row["EnterpriseName"] != null) { model.EnterpriseName = row["EnterpriseName"].ToString(); } if (row["Contact"] != null) { model.Contact = row["Contact"].ToString(); } if (row["EInformation"] != null) { model.EInformation = row["EInformation"].ToString(); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } if (row["Audit"] != null) { model.Audit = row["Audit"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Haikan.SchoolProjectsCore.MDB.Model.Eenterprises model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Eenterprises("); strSql.Append("EnterpriseName,Contact,EInformation,Note,Audit)"); strSql.Append(" values ("); strSql.Append("@EnterpriseName,@Contact,@EInformation,@Note,@Audit)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 255), new SqlParameter("@Contact", SqlDbType.VarChar, 255), new SqlParameter("@EInformation", SqlDbType.VarChar, 255), new SqlParameter("@Note", SqlDbType.VarChar, 255), new SqlParameter("@Audit", SqlDbType.VarChar, 255) }; parameters[0].Value = model.EnterpriseName; parameters[1].Value = model.Contact; parameters[2].Value = model.EInformation; parameters[3].Value = model.Note; parameters[4].Value = model.Audit; object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Haikan.SchoolProjectsCore.MDB.Model.Eenterprises model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Eenterprises set "); strSql.Append("EnterpriseName=@EnterpriseName,"); strSql.Append("Contact=@Contact,"); strSql.Append("EInformation=@EInformation,"); strSql.Append("Note=@Note,"); strSql.Append("Audit=@Audit"); strSql.Append(" where EnterpriseID=@EnterpriseID"); SqlParameter[] parameters = { new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 255), new SqlParameter("@Contact", SqlDbType.VarChar, 255), new SqlParameter("@EInformation", SqlDbType.VarChar, 255), new SqlParameter("@Note", SqlDbType.VarChar, 255), new SqlParameter("@Audit", SqlDbType.VarChar, 255), new SqlParameter("@EnterpriseID", SqlDbType.Int, 4) }; parameters[0].Value = model.EnterpriseName; parameters[1].Value = model.Contact; parameters[2].Value = model.EInformation; parameters[3].Value = model.Note; parameters[4].Value = model.Audit; parameters[5].Value = model.EnterpriseID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Haikan.SchoolProjectsCore.MDB.Model.Eenterprises GetModel(int EnterpriseID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 EnterpriseID,EnterpriseName,Contact,EInformation,Note,Audit from Eenterprises "); strSql.Append(" where EnterpriseID=@EnterpriseID"); SqlParameter[] parameters = { new SqlParameter("@EnterpriseID", SqlDbType.Int, 4) }; parameters[0].Value = EnterpriseID; Haikan.SchoolProjectsCore.MDB.Model.Eenterprises model = new Haikan.SchoolProjectsCore.MDB.Model.Eenterprises(); DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }