/// <summary>
/// 获取
/// </summary>
/// <param name="_D_SN">SN</param>
/// <returns></returns>
public static DingDanInfo Get(Int32 _D_SN)
{
DingDanInfo _DingDanInfo = new DingDanInfo();
SqlParameter[] parm = { new SqlParameter("D_SN", _D_SN), };
using (SqlDataReader _SDR = SqlHelper.ExecuteReader(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDan_Get", parm))
{
if (_SDR.Read())
{
_DingDanInfo.D_SN = Convert.ToInt32(_SDR["D_SN"]);
_DingDanInfo.D_SuoShuBuMenSN = Convert.ToInt32(_SDR["D_SuoShuBuMenSN"]);
_DingDanInfo.D_SuoShuXiTongSN = Convert.ToInt32(_SDR["D_SuoShuXiTongSN"]);
_DingDanInfo.D_TiJiaoRenName = Convert.ToString(_SDR["D_TiJiaoRenName"]);
_DingDanInfo.D_TiJiaoRenSN = Convert.ToInt32(_SDR["D_TiJiaoRenSN"]);
_DingDanInfo.D_TiJiaoSuoShuBanJiSN = Convert.ToInt32(_SDR["D_TiJiaoSuoShuBanJiSN"]);
_DingDanInfo.D_TiJiaoRenKaoShiHao = Convert.ToString(_SDR["D_TiJiaoRenKaoShiHao"]);
_DingDanInfo.D_AddDate = Convert.ToDateTime(_SDR["D_AddDate"]);
_DingDanInfo.D_AddIP = Convert.ToString(_SDR["D_AddIP"]);
_DingDanInfo.D_LianXiRen = Convert.ToString(_SDR["D_LianXiRen"]);
_DingDanInfo.D_LianXiPhone = Convert.ToString(_SDR["D_LianXiPhone"]);
_DingDanInfo.D_LianXiMail = Convert.ToString(_SDR["D_LianXiMail"]);
_DingDanInfo.D_Style = Convert.ToInt32(_SDR["D_Style"]);
_DingDanInfo.D_JiaGe = Convert.ToDouble(_SDR["D_JiaGe"]);
_DingDanInfo.D_ZhuangTai = Convert.ToInt32(_SDR["D_ZhuangTai"]);
_DingDanInfo.D_ShiFouShanChu = Convert.ToBoolean(_SDR["D_ShiFouShanChu"]);
}
_SDR.Close();
_SDR.Dispose();
}
return _DingDanInfo;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(DingDanInfo _DingDanInfo)
{
SqlParameter[] parm ={
new SqlParameter("D_SuoShuBuMenSN",_DingDanInfo.D_SuoShuBuMenSN),
new SqlParameter("D_SuoShuXiTongSN",_DingDanInfo.D_SuoShuXiTongSN),
new SqlParameter("D_TiJiaoRenName",_DingDanInfo.D_TiJiaoRenName),
new SqlParameter("D_TiJiaoRenSN",_DingDanInfo.D_TiJiaoRenSN),
new SqlParameter("D_TiJiaoSuoShuBanJiSN",_DingDanInfo.D_TiJiaoSuoShuBanJiSN),
new SqlParameter("D_TiJiaoRenKaoShiHao",_DingDanInfo.D_TiJiaoRenKaoShiHao),
new SqlParameter("D_AddDate",_DingDanInfo.D_AddDate),
new SqlParameter("D_AddIP",_DingDanInfo.D_AddIP),
new SqlParameter("D_LianXiRen",_DingDanInfo.D_LianXiRen),
new SqlParameter("D_LianXiPhone",_DingDanInfo.D_LianXiPhone),
new SqlParameter("D_LianXiMail",_DingDanInfo.D_LianXiMail),
new SqlParameter("D_Style",_DingDanInfo.D_Style),
new SqlParameter("D_JiaGe",_DingDanInfo.D_JiaGe),
new SqlParameter("D_ZhuangTai",_DingDanInfo.D_ZhuangTai),
new SqlParameter("D_ShiFouShanChu",_DingDanInfo.D_ShiFouShanChu),
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString2, CommandType.StoredProcedure, "DingDan_Add", parm);
return true;
}
/// <summary>
/// 设置
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Set(DingDanInfo _DingDanInfo)
{
return DingDanData.Set(_DingDanInfo);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="_UserInfo">实体类</param>
/// <returns></returns>
public static Boolean Add(DingDanInfo _DingDanInfo)
{
return DingDanData.Add(_DingDanInfo);
}