/// <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);
}
}
