/// <summary>
/// Manufacter_Get Method
/// </summary>
/// <param name="manuID">Manufacter Main ID</param>
/// <returns>ManufacterInfo get from Manufacter table.</returns>
internal ManufacterInfo Manufacter_Get(int manuID)
{
ManufacterInfo manufacterInfo = null;
string sqlCommand = "Manufacter_Get";
DbCommand dbCommand = dbr.GetStoredProcCommand(sqlCommand);
dbr.AddInParameter(dbCommand, "ManuID", DbType.Int32, manuID);
using (IDataReader dataReader = dbr.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
manufacterInfo = RecoverModel(dataReader);
}
}
return(manufacterInfo);
}
/// <summary>
/// Manufacter_Insert Method
/// </summary>
/// <param name="ManufacterInfo">Manufacter object</param>
/// <returns></returns>
internal int Manufacter_Insert(ManufacterInfo manufacterInfo)
{
string sqlCommand = "Manufacter_Insert";
DbCommand dbCommand = dbw.GetStoredProcCommand(sqlCommand);
dbw.AddOutParameter(dbCommand, "ManuID", DbType.Int32, 4);
dbw.AddInParameter(dbCommand, "Manufacturer", DbType.String, manufacterInfo.Manufacturer);
dbw.AddInParameter(dbCommand, "Address", DbType.String, manufacterInfo.Address);
dbw.AddInParameter(dbCommand, "Postalcode", DbType.String, manufacterInfo.Postalcode);
dbw.AddInParameter(dbCommand, "Phone", DbType.String, manufacterInfo.Phone);
dbw.AddInParameter(dbCommand, "ConsultPhone", DbType.String, manufacterInfo.ConsultPhone);
dbw.AddInParameter(dbCommand, "ServicePhone", DbType.String, manufacterInfo.ServicePhone);
dbw.AddInParameter(dbCommand, "Office", DbType.String, manufacterInfo.Office);
dbw.AddInParameter(dbCommand, "Fax", DbType.String, manufacterInfo.Fax);
dbw.AddInParameter(dbCommand, "RegAddress", DbType.String, manufacterInfo.RegAddress);
dbw.AddInParameter(dbCommand, "Site", DbType.String, manufacterInfo.Site);
dbw.AddInParameter(dbCommand, "Creator", DbType.String, manufacterInfo.Creator);
dbw.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, manufacterInfo.CreateTime);
dbw.ExecuteNonQuery(dbCommand);
return(int.Parse(dbw.GetParameterValue(dbCommand, "ManuID").ToString()));
}
/// <summary>
/// 从 IDataReader 中恢复Manufacter对象
/// </summary>
/// <param name="IDataReader"></param>
/// <returns></returns>
private ManufacterInfo RecoverModel(IDataReader dataReader)
{
ManufacterInfo manufacterInfo = new ManufacterInfo();
manufacterInfo.ManuID = int.Parse(dataReader["ManuID"].ToString());
manufacterInfo.Manufacturer = dataReader["Manufacturer"].ToString();
manufacterInfo.Address = dataReader["Address"].ToString();
manufacterInfo.Postalcode = dataReader["Postalcode"].ToString();
manufacterInfo.Phone = dataReader["Phone"].ToString();
manufacterInfo.ConsultPhone = dataReader["ConsultPhone"].ToString();
manufacterInfo.ServicePhone = dataReader["ServicePhone"].ToString();
manufacterInfo.Office = dataReader["Office"].ToString();
manufacterInfo.Fax = dataReader["Fax"].ToString();
manufacterInfo.RegAddress = dataReader["RegAddress"].ToString();
manufacterInfo.Site = dataReader["Site"].ToString();
manufacterInfo.Creator = dataReader["Creator"].ToString();
manufacterInfo.CreateTime = DateTime.Parse(dataReader["CreateTime"].ToString());
manufacterInfo.LastUpdate = dataReader["LastUpdate"].ToString();
manufacterInfo.LastUpdateTime = DateTime.Parse(dataReader["LastUpdateTime"].ToString());
return(manufacterInfo);
}
/// <summary>
/// Manufacter_Update Method
/// </summary>
/// <param name="ManufacterInfo">Manufacter object</param>
/// <returns>true:成功 false:失败</returns>
internal bool Manufacter_Update(ManufacterInfo manufacterInfo)
{
string sqlCommand = "Manufacter_Update";
DbCommand dbCommand = dbw.GetStoredProcCommand(sqlCommand);
dbw.AddInParameter(dbCommand, "ManuID", DbType.Int32, manufacterInfo.ManuID);
dbw.AddInParameter(dbCommand, "Manufacturer", DbType.String, manufacterInfo.Manufacturer);
dbw.AddInParameter(dbCommand, "Address", DbType.String, manufacterInfo.Address);
dbw.AddInParameter(dbCommand, "Postalcode", DbType.String, manufacterInfo.Postalcode);
dbw.AddInParameter(dbCommand, "Phone", DbType.String, manufacterInfo.Phone);
dbw.AddInParameter(dbCommand, "ConsultPhone", DbType.String, manufacterInfo.ConsultPhone);
dbw.AddInParameter(dbCommand, "ServicePhone", DbType.String, manufacterInfo.ServicePhone);
dbw.AddInParameter(dbCommand, "Office", DbType.String, manufacterInfo.Office);
dbw.AddInParameter(dbCommand, "Fax", DbType.String, manufacterInfo.Fax);
dbw.AddInParameter(dbCommand, "RegAddress", DbType.String, manufacterInfo.RegAddress);
dbw.AddInParameter(dbCommand, "Site", DbType.String, manufacterInfo.Site);
dbw.AddInParameter(dbCommand, "LastUpdate", DbType.String, manufacterInfo.LastUpdate);
dbw.AddInParameter(dbCommand, "LastUpdateTime", DbType.DateTime, manufacterInfo.LastUpdateTime);
dbw.ExecuteNonQuery(dbCommand);
return(true);
}
