/// <summary>
/// 根据表,获取一个OleDbParameter数组
/// </summary>
/// <returns>OleDbParameter[]</returns>
public static OleDbParameter[] GetOleDbParameter(shuadan_phone shuadan_phoneExample)
{
List <OleDbParameter> list_param = new List <OleDbParameter>();
if (!string.IsNullOrEmpty(shuadan_phoneExample.sdpcode))
{
list_param.Add(new OleDbParameter("@sdpcode", shuadan_phoneExample.sdpcode));
}
else
{
list_param.Add(new OleDbParameter("@sdpcode", DBNull.Value));
}
if (!string.IsNullOrEmpty(shuadan_phoneExample.sdpstate))
{
list_param.Add(new OleDbParameter("@sdpstate", shuadan_phoneExample.sdpstate));
}
else
{
list_param.Add(new OleDbParameter("@sdpstate", DBNull.Value));
}
OleDbParameter[] param = new OleDbParameter[list_param.Count];
int index = 0;
foreach (OleDbParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
/// <summary>
/// 从一个SqlDataReader里读数据
/// </summary>
/// <param name="Reader">SqlDataReader</param>
/// <returns>shuadan_phoneExample</returns>
public static shuadan_phone GetByReader(SqlDataReader Reader)
{
shuadan_phone shuadan_phoneExample = new shuadan_phone();
shuadan_phoneExample.sdpcode = Reader["sdpcode"] == DBNull.Value ? null : Reader["sdpcode"].ToString();
shuadan_phoneExample.sdpdate = Reader["sdpdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["sdpdate"]);
shuadan_phoneExample.sdpid = Reader["sdpid"] == DBNull.Value ? 0 : (int)Reader["sdpid"];
shuadan_phoneExample.sdpstate = Reader["sdpstate"] == DBNull.Value ? null : Reader["sdpstate"].ToString();
return(shuadan_phoneExample);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <shuadan_phone> SearchAll()
{
DBHelper.sqlstr = "select * from shuadan_phone ";
List <shuadan_phone> list = new List <shuadan_phone>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
shuadan_phone Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 根据sdpid,查询一条数据
/// </summary>
/// <param name="sdpid"></param>
/// <returns></returns>
public shuadan_phone SearchBysdpid(int sdpid)
{
DBHelper.sqlstr = "select * from shuadan_phone where sdpid = @sdpid";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@sdpid", sdpid)
};
SqlDataReader reader = DBHelper.ExecuteReader(param);
shuadan_phone Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
/// <summary>
/// 根据表,获取一个SqlParameter数组
/// </summary>
/// <returns>SqlParameter[]</returns>
public static SqlParameter[] GetSqlParameter(shuadan_phone shuadan_phoneExample)
{
List <SqlParameter> list_param = new List <SqlParameter>();
if (!string.IsNullOrEmpty(shuadan_phoneExample.sdpcode))
{
list_param.Add(new SqlParameter("@sdpcode", shuadan_phoneExample.sdpcode));
}
else
{
list_param.Add(new SqlParameter("@sdpcode", DBNull.Value));
}
if (shuadan_phoneExample.sdpdate != new DateTime() && shuadan_phoneExample.sdpdate != null)
{
list_param.Add(new SqlParameter("@sdpdate", shuadan_phoneExample.sdpdate.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new SqlParameter("@sdpdate", DBNull.Value));
}
if (!string.IsNullOrEmpty(shuadan_phoneExample.sdpstate))
{
list_param.Add(new SqlParameter("@sdpstate", shuadan_phoneExample.sdpstate));
}
else
{
list_param.Add(new SqlParameter("@sdpstate", DBNull.Value));
}
SqlParameter[] param = new SqlParameter[list_param.Count];
int index = 0;
foreach (SqlParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="shuadan_phone">shuadan_phone表实例</param>
/// <returns>int</returns>
public int Update(shuadan_phone shuadan_phoneExample)
{
DBHelper.sqlstr = "update shuadan_phone set sdpcode=@sdpcode,sdpdate='" + shuadan_phoneExample.sdpdate.ToString() + "',sdpstate=@sdpstate where sdpid=" + shuadan_phoneExample.sdpid;
return(DBHelper.ExecuteNonQuery(GetSqlParameter(shuadan_phoneExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="shuadan_phone">shuadan_phone表实例</param>
/// <returns>int</returns>
public int Insert(shuadan_phone shuadan_phoneExample)
{
DBHelper.sqlstr = "insert into shuadan_phone (sdpcode,sdpdate,sdpstate)values(@sdpcode,'" + shuadan_phoneExample.sdpdate.ToString() + "',@sdpstate)";
return(DBHelper.ExecuteNonQuery(GetSqlParameter(shuadan_phoneExample)));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="shuadan_phone">shuadan_phone表实例</param>
/// <returns>int</returns>
public static int Update(shuadan_phone shuadan_phoneExample)
{
return(Service.Update(shuadan_phoneExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="shuadan_phone">shuadan_phone表实例</param>
/// <returns>int</returns>
public static int Insert(shuadan_phone shuadan_phoneExample)
{
return(Service.Insert(shuadan_phoneExample));
}
