/// <summary>
/// 设置
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Set(DingDanLogsInfo _DingDanLogsInfo)
{
SqlParameter[] parm ={
new SqlParameter("D_SN",_DingDanLogsInfo.D_SN),
new SqlParameter("D_DingDanSN",_DingDanLogsInfo.D_DingDanSN),
new SqlParameter("D_DingDanShuoMing",_DingDanLogsInfo.D_DingDanShuoMing),
new SqlParameter("D_AddIP",_DingDanLogsInfo.D_AddIP),
new SqlParameter("D_AddDate",_DingDanLogsInfo.D_AddDate),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDanLogs_Set", parm);
return true;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Int32 Add(DingDanLogsInfo _DingDanLogsInfo)
{
SqlParameter[] parm ={
new SqlParameter("D_DingDanSN",_DingDanLogsInfo.D_DingDanSN),
new SqlParameter("D_DingDanShuoMing",_DingDanLogsInfo.D_DingDanShuoMing),
new SqlParameter("D_AddIP",_DingDanLogsInfo.D_AddIP),
new SqlParameter("D_AddDate",_DingDanLogsInfo.D_AddDate),
};
Int32 D_SN = Int32.Parse(SqlHelper.ExecuteScalar(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDanLogs_Add", parm).ToString());
return D_SN;
}
/// <summary>
/// 获取
/// </summary>
/// <param name="_D_SN">SN</param>
/// <returns></returns>
public static DingDanLogsInfo Get(Int32 _D_SN)
{
DingDanLogsInfo _DingDanLogsInfo = new DingDanLogsInfo();
SqlParameter[] parm = { new SqlParameter("D_SN", _D_SN), };
using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDanLogs_Get", parm))
{
if (_SDR.Read())
{
_DingDanLogsInfo.D_SN = Convert.ToInt32(_SDR["D_SN"]);
_DingDanLogsInfo.D_DingDanSN = Convert.ToInt32(_SDR["D_DingDanSN"]);
_DingDanLogsInfo.D_DingDanShuoMing = Convert.ToString(_SDR["D_DingDanShuoMing"]);
_DingDanLogsInfo.D_AddIP = Convert.ToString(_SDR["D_AddIP"]);
_DingDanLogsInfo.D_AddDate = Convert.ToDateTime(_SDR["D_AddDate"]);
}
_SDR.Close();
_SDR.Dispose();
}
return _DingDanLogsInfo;
}
/// <summary>
/// 设置
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Set(DingDanLogsInfo _DingDanLogsInfo)
{
return DingDanLogsData.Set(_DingDanLogsInfo);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Int32 Add(DingDanLogsInfo _DingDanLogsInfo)
{
return DingDanLogsData.Add(_DingDanLogsInfo);
}