public M_MySubscription GetMySubscriptionById(int id) { string sql = "select * from ZL_MySubscription where id=@id"; SqlParameter[] cmdParam = new SqlParameter[] { new SqlParameter("@id", SqlDbType.Int) }; cmdParam[0].Value = id; M_MySubscription mysub = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, cmdParam)) { if (reader.Read()) { mysub = new M_MySubscription(); mysub.Id = DataConverter.CLng(reader["id"]); mysub.Reference_ID = DataConverter.CLng(reader["reference_ID"]); mysub.Order_Time = DataConverter.CDate(reader["order_Time"]); mysub.Period = DataConverter.CLng(reader["period"]); mysub.Start_Date = DataConverter.CDate(reader["start_Date"]); mysub.Order_Type = DataConverter.CLng(reader["order_Type"]); mysub.User_Name = reader["user_Name"].ToString(); mysub.Tel = reader["tel"].ToString(); mysub.Email = reader["email"].ToString(); } reader.Close(); reader.Dispose(); } return(mysub); }
public int AddSubscription(M_MySubscription mysub) { int num = 0; string sql = "insert into ZL_MySubscription(Reference_ID,Order_Time,Period,Start_Date,Order_Type,User_Name,Tel,Email) values(" + mysub.Reference_ID + ",'" + mysub.Order_Time + "'," + mysub.Period + ",'" + mysub.Start_Date + "'," + mysub.Order_Type + ",'" + mysub.User_Name + "','" + mysub.Tel + "','" + mysub.Email + "')"; num = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql, null)); return(num); }
/// <summary> /// 查询方法根据内容id和用户名 /// </summary> /// <param name="id"></param> /// <param name="name"></param> /// <returns></returns> public DataTable GetMySubscriptionName(string name) { string sql = "select * from ZL_MySubscription where User_Name=@User_Name and Order_Type=4 "; M_MySubscription mysub = new M_MySubscription(); SqlParameter[] sp = new SqlParameter[1] { new SqlParameter("User_Name", SqlDbType.NVarChar) }; sp[0].Value = name; return(SqlHelper.ExecuteTable(CommandType.Text, sql, sp)); }
public bool UpdateOrderTyleName(M_MySubscription sub) { string sql = "update ZL_MySubscription set Order_Type=@Order_Type where Reference_ID=@Reference_ID and User_Name=@User_Name "; SqlParameter[] sp = new SqlParameter[3] { new SqlParameter("@Order_Type", SqlDbType.Int), new SqlParameter("@Reference_ID", SqlDbType.Int), new SqlParameter("@User_Name", SqlDbType.NVarChar) }; sp[0].Value = sub.Order_Type; sp[1].Value = sub.Reference_ID; sp[2].Value = sub.User_Name; return(SqlHelper.ExecuteSql(sql, sp)); }
public void UpdSubscription(M_MySubscription subscription) { string sql = "update ZL_MySubscription set Reference_ID=@Reference_ID,Period=@Period,Start_Date=@Start_Date,Order_Type=@Order_Type,User_Name=@User_Name,Tel=@Tel,Email=@Email where id=@id"; SqlParameter[] sp = new SqlParameter[8] { new SqlParameter("@Reference_ID", SqlDbType.Int), new SqlParameter("@Period", SqlDbType.Int), new SqlParameter("@Start_Date ", SqlDbType.DateTime), new SqlParameter("@Order_Type", SqlDbType.BigInt), new SqlParameter("@User_Name", SqlDbType.NVarChar), new SqlParameter("@Tel", SqlDbType.NVarChar), new SqlParameter("@Email", SqlDbType.NVarChar), new SqlParameter("@id", SqlDbType.BigInt), }; sp[0].Value = subscription.Reference_ID; sp[1].Value = subscription.Period; sp[2].Value = subscription.Start_Date; sp[3].Value = subscription.Order_Type; sp[4].Value = subscription.User_Name; sp[5].Value = subscription.Tel; sp[6].Value = subscription.Email; sp[7].Value = subscription.Id; SqlHelper.ExecuteSql(sql, sp); }
public int insert(M_MySubscription model) { return(Sql.insert(strTableName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model))); }
/// <summary> /// 根据ID更新 /// </summary> public bool UpdateByID(M_MySubscription model) { return(Sql.UpdateByIDs(strTableName, PK, model.Id.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model))); }