/// <summary> /// 更新一条数据 /// </summary> public bool Update(eChartProject.Model.eChart.fundtrustee model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fundtrustee set "); strSql.Append("FundID=@FundID,"); strSql.Append("FundTrusteeNo=@FundTrusteeNo,"); strSql.Append("Title=@Title,"); strSql.Append("FirstName=@FirstName,"); strSql.Append("MiddleName=@MiddleName,"); strSql.Append("LastName=@LastName,"); strSql.Append("TrusteeTFN=@TrusteeTFN,"); strSql.Append("DOB=@DOB,"); strSql.Append("DateOfRetirement=@DateOfRetirement,"); strSql.Append("IsMember=@IsMember,"); strSql.Append("JoinDate=@JoinDate"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@FundID", MySqlDbType.Int32, 11), new MySqlParameter("@FundTrusteeNo", MySqlDbType.Int32, 11), new MySqlParameter("@Title", MySqlDbType.VarChar, 100), new MySqlParameter("@FirstName", MySqlDbType.VarChar, 100), new MySqlParameter("@MiddleName", MySqlDbType.VarChar, 100), new MySqlParameter("@LastName", MySqlDbType.VarChar, 100), new MySqlParameter("@TrusteeTFN", MySqlDbType.VarChar, 100), new MySqlParameter("@DOB", MySqlDbType.DateTime), new MySqlParameter("@DateOfRetirement", MySqlDbType.DateTime), new MySqlParameter("@IsMember", MySqlDbType.Int32, 1), new MySqlParameter("@JoinDate", MySqlDbType.DateTime), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.FundID; parameters[1].Value = model.FundTrusteeNo; parameters[2].Value = model.Title; parameters[3].Value = model.FirstName; parameters[4].Value = model.MiddleName; parameters[5].Value = model.LastName; parameters[6].Value = model.TrusteeTFN; parameters[7].Value = model.DOB; parameters[8].Value = model.DateOfRetirement; parameters[9].Value = model.IsMember; parameters[10].Value = model.JoinDate; parameters[11].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(eChartProject.Model.eChart.fundtrustee model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fundtrustee("); strSql.Append("FundID,FundTrusteeNo,Title,FirstName,MiddleName,LastName,TrusteeTFN,DOB,DateOfRetirement,IsMember,JoinDate)"); strSql.Append(" values ("); strSql.Append("@FundID,@FundTrusteeNo,@Title,@FirstName,@MiddleName,@LastName,@TrusteeTFN,@DOB,@DateOfRetirement,@IsMember,@JoinDate)"); MySqlParameter[] parameters = { new MySqlParameter("@FundID", MySqlDbType.Int32, 11), new MySqlParameter("@FundTrusteeNo", MySqlDbType.Int32, 11), new MySqlParameter("@Title", MySqlDbType.VarChar, 100), new MySqlParameter("@FirstName", MySqlDbType.VarChar, 100), new MySqlParameter("@MiddleName", MySqlDbType.VarChar, 100), new MySqlParameter("@LastName", MySqlDbType.VarChar, 100), new MySqlParameter("@TrusteeTFN", MySqlDbType.VarChar, 100), new MySqlParameter("@DOB", MySqlDbType.DateTime), new MySqlParameter("@DateOfRetirement", MySqlDbType.DateTime), new MySqlParameter("@IsMember", MySqlDbType.Int32, 1), new MySqlParameter("@JoinDate", MySqlDbType.DateTime) }; parameters[0].Value = model.FundID; parameters[1].Value = model.FundTrusteeNo; parameters[2].Value = model.Title; parameters[3].Value = model.FirstName; parameters[4].Value = model.MiddleName; parameters[5].Value = model.LastName; parameters[6].Value = model.TrusteeTFN; parameters[7].Value = model.DOB; parameters[8].Value = model.DateOfRetirement; parameters[9].Value = model.IsMember; parameters[10].Value = model.JoinDate; DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public eChartProject.Model.eChart.fundtrustee GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,FundID,FundTrusteeNo,Title,FirstName,MiddleName,LastName,TrusteeTFN,DOB,DateOfRetirement,IsMember,JoinDate from fundtrustee "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; eChartProject.Model.eChart.fundtrustee model = new eChartProject.Model.eChart.fundtrustee(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["FundID"] != null && ds.Tables[0].Rows[0]["FundID"].ToString() != "") { model.FundID = int.Parse(ds.Tables[0].Rows[0]["FundID"].ToString()); } if (ds.Tables[0].Rows[0]["FundTrusteeNo"] != null && ds.Tables[0].Rows[0]["FundTrusteeNo"].ToString() != "") { model.FundTrusteeNo = int.Parse(ds.Tables[0].Rows[0]["FundTrusteeNo"].ToString()); } if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "") { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["FirstName"] != null && ds.Tables[0].Rows[0]["FirstName"].ToString() != "") { model.FirstName = ds.Tables[0].Rows[0]["FirstName"].ToString(); } if (ds.Tables[0].Rows[0]["MiddleName"] != null && ds.Tables[0].Rows[0]["MiddleName"].ToString() != "") { model.MiddleName = ds.Tables[0].Rows[0]["MiddleName"].ToString(); } if (ds.Tables[0].Rows[0]["LastName"] != null && ds.Tables[0].Rows[0]["LastName"].ToString() != "") { model.LastName = ds.Tables[0].Rows[0]["LastName"].ToString(); } if (ds.Tables[0].Rows[0]["TrusteeTFN"] != null && ds.Tables[0].Rows[0]["TrusteeTFN"].ToString() != "") { model.TrusteeTFN = ds.Tables[0].Rows[0]["TrusteeTFN"].ToString(); } if (ds.Tables[0].Rows[0]["DOB"] != null && ds.Tables[0].Rows[0]["DOB"].ToString() != "") { model.DOB = DateTime.Parse(ds.Tables[0].Rows[0]["DOB"].ToString()); } if (ds.Tables[0].Rows[0]["DateOfRetirement"] != null && ds.Tables[0].Rows[0]["DateOfRetirement"].ToString() != "") { model.DateOfRetirement = DateTime.Parse(ds.Tables[0].Rows[0]["DateOfRetirement"].ToString()); } if (ds.Tables[0].Rows[0]["IsMember"] != null && ds.Tables[0].Rows[0]["IsMember"].ToString() != "") { model.IsMember = int.Parse(ds.Tables[0].Rows[0]["IsMember"].ToString()); } if (ds.Tables[0].Rows[0]["JoinDate"] != null && ds.Tables[0].Rows[0]["JoinDate"].ToString() != "") { model.JoinDate = DateTime.Parse(ds.Tables[0].Rows[0]["JoinDate"].ToString()); } return(model); } else { return(null); } }