/// <summary> /// 更新一条数据 /// </summary> public void UpdateM_AppSubscribeInfo(M_AppSubscribeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_M_AppSubscribeInfo set "); strSql.Append("m_UserInfoID=@m_UserInfoID,"); strSql.Append("lease_id=@lease_id,"); strSql.Append("status=@status,"); strSql.Append("start_date=@start_date,"); strSql.Append("end_date=@end_date,"); strSql.Append("version_no=@version_no"); strSql.Append(" where m_AppSubscribeInfoID=@m_AppSubscribeInfoID "); SqlParameter[] parameters = { new SqlParameter("@m_AppSubscribeInfoID", SqlDbType.Int, 4), new SqlParameter("@m_UserInfoID", SqlDbType.Int, 4), new SqlParameter("@lease_id", SqlDbType.VarChar, 50), new SqlParameter("@status", SqlDbType.VarChar, 50), new SqlParameter("@start_date", SqlDbType.DateTime), new SqlParameter("@end_date", SqlDbType.DateTime), new SqlParameter("@version_no", SqlDbType.Int, 4) }; parameters[0].Value = model.m_AppSubscribeInfoID; parameters[1].Value = model.m_UserInfoID; parameters[2].Value = model.lease_id; parameters[3].Value = model.status; parameters[4].Value = model.start_date; parameters[5].Value = model.end_date; parameters[6].Value = model.version_no; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public M_AppSubscribeInfo GetM_AppSubscribeInfoModel(int m_AppSubscribeInfoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 m_AppSubscribeInfoID,m_UserInfoID,lease_id,status,start_date,end_date,version_no from tb_M_AppSubscribeInfo "); strSql.Append(" where m_AppSubscribeInfoID=@m_AppSubscribeInfoID "); SqlParameter[] parameters = { new SqlParameter("@m_AppSubscribeInfoID", SqlDbType.Int, 4) }; parameters[0].Value = m_AppSubscribeInfoID; M_AppSubscribeInfo model = new M_AppSubscribeInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["m_AppSubscribeInfoID"].ToString() != "") { model.m_AppSubscribeInfoID = int.Parse(ds.Tables[0].Rows[0]["m_AppSubscribeInfoID"].ToString()); } if (ds.Tables[0].Rows[0]["m_UserInfoID"].ToString() != "") { model.m_UserInfoID = int.Parse(ds.Tables[0].Rows[0]["m_UserInfoID"].ToString()); } model.lease_id = ds.Tables[0].Rows[0]["lease_id"].ToString(); model.status = ds.Tables[0].Rows[0]["status"].ToString(); if (ds.Tables[0].Rows[0]["start_date"].ToString() != "") { model.start_date = DateTime.Parse(ds.Tables[0].Rows[0]["start_date"].ToString()); } if (ds.Tables[0].Rows[0]["end_date"].ToString() != "") { model.end_date = DateTime.Parse(ds.Tables[0].Rows[0]["end_date"].ToString()); } if (ds.Tables[0].Rows[0]["version_no"].ToString() != "") { model.version_no = int.Parse(ds.Tables[0].Rows[0]["version_no"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int AddM_AppSubscribeInfo(M_AppSubscribeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_M_AppSubscribeInfo("); strSql.Append("m_UserInfoID,lease_id,status,start_date,end_date,version_no)"); strSql.Append(" values ("); strSql.Append("@m_UserInfoID,@lease_id,@status,@start_date,@end_date,@version_no)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@m_UserInfoID", SqlDbType.Int, 4), new SqlParameter("@lease_id", SqlDbType.VarChar, 50), new SqlParameter("@status", SqlDbType.VarChar, 50), new SqlParameter("@start_date", SqlDbType.DateTime), new SqlParameter("@end_date", SqlDbType.DateTime), new SqlParameter("@version_no", SqlDbType.Int, 4) }; parameters[0].Value = model.m_UserInfoID; parameters[1].Value = model.lease_id; parameters[2].Value = model.status; parameters[3].Value = model.start_date; parameters[4].Value = model.end_date; parameters[5].Value = model.version_no; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(-1); } else { return(Convert.ToInt32(obj)); } }