/// <summary>
/// get table record
/// <summary>
/// <param name=shiptype>shiptype</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of salesshiptype</returns>
public modSalesShipType GetItem(string shiptype, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select ship_type,ad_flag,update_user,update_time from sales_ship_type where ship_type='{0}' order by ship_type", shiptype);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modSalesShipType model = new modSalesShipType();
model.ShipType = dalUtility.ConvertToString(rdr["ship_type"]);
model.AdFlag = dalUtility.ConvertToInt(rdr["ad_flag"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
emsg = null;
return(model);
}
else
{
emsg = "Error on read data";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get all salesshiptype
/// <summary>
/// <param name=shiptype>shiptype</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all salesshiptype</returns>
public BindingCollection <modSalesShipType> GetIList(string shiptype, out string emsg)
{
try
{
BindingCollection <modSalesShipType> modellist = new BindingCollection <modSalesShipType>();
//Execute a query to read the categories
string sql = string.Format("select ship_type,ad_flag,update_user,update_time from sales_ship_type where ship_type='{0}' order by ship_type", shiptype);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modSalesShipType model = new modSalesShipType();
model.ShipType = dalUtility.ConvertToString(rdr["ship_type"]);
model.AdFlag = dalUtility.ConvertToInt(rdr["ad_flag"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// update a salesshiptype
/// <summary>
/// <param name=shiptype>shiptype</param>
/// <param name=mod>model object of salesshiptype</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string shiptype, modSalesShipType mod, out string emsg)
{
try
{
string sql = string.Format("update sales_ship_type set ad_flag={0},update_user='******',update_time=getdate() where ship_type='{2}'", mod.AdFlag, mod.UpdateUser, shiptype);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// insert a salesshiptype
/// <summary>
/// <param name=mod>model object of salesshiptype</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modSalesShipType mod, out string emsg)
{
try
{
string sql = string.Format("insert into sales_ship_type(ship_type,ad_flag,update_user,update_time)values('{0}',{1},'{2}',getdate())", mod.ShipType, mod.AdFlag, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
