public List <SellerOpreateLog> SelectBySellerID(SellerOpreateLog sellerOpreateLog) { string SQLServerConnectString = "Data Source=localhost;Initial Catalog=WebAPPDevDotNETFinnalTest;Integrated Security=True;Pooling=False"; SqlConnection SQLConnection = new SqlConnection(SQLServerConnectString); string SQLCommandText = "SELECT * FROM [dbo].[SellerOpreateLog] where SellerID=@SellerID ORDER BY ID DESC"; SqlCommand SQLCommand = new SqlCommand(SQLCommandText, SQLConnection); SQLCommand.Parameters.Add(new SqlParameter("@SellerID", sellerOpreateLog.SellerID)); DataSet dataSet = new DataSet(); SqlDataAdapter SQLDataAdapter = new SqlDataAdapter(SQLCommand); SQLConnection.Open(); SQLDataAdapter.Fill(dataSet); SQLConnection.Close(); List <SellerOpreateLog> SelectResult = new List <SellerOpreateLog>(); for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { SellerOpreateLog temp = new SellerOpreateLog(); temp.ID = Int32.Parse(dataSet.Tables[0].Rows[i]["ID"].ToString()); temp.SellerID = Int32.Parse(dataSet.Tables[0].Rows[i]["SellerID"].ToString()); temp.UserID = Int32.Parse(dataSet.Tables[0].Rows[i]["UserID"].ToString()); temp.Quantity = Int32.Parse(dataSet.Tables[0].Rows[i]["Quantity"].ToString()); temp.Object = Int32.Parse(dataSet.Tables[0].Rows[i]["Object"].ToString()); temp.Opreate = dataSet.Tables[0].Rows[i]["Opreate"].ToString(); temp.ModelID = Int32.Parse(dataSet.Tables[0].Rows[i]["ModelID"].ToString()); SelectResult.Add(temp); } return(SelectResult); }
public List <SellerOpreateLog> SelectBySellerID(int SellerID) { SellerOpreateLog sellerOpreateLog = new SellerOpreateLog(); sellerOpreateLog.SellerID = SellerID; DAL_SellerOpreateLog SellerOpreateLogDAL = new DAL_SellerOpreateLog(); return(SellerOpreateLogDAL.SelectBySellerID(sellerOpreateLog)); }
public void New(int ModelID, int SellerID, int UserID, int ObjectID, int Quantity, string Opreate) { SellerOpreateLog sellerOpreateLog = new SellerOpreateLog(); sellerOpreateLog.ModelID = ModelID; sellerOpreateLog.SellerID = SellerID; sellerOpreateLog.UserID = UserID; sellerOpreateLog.Object = ObjectID; sellerOpreateLog.Quantity = Quantity; sellerOpreateLog.Opreate = Opreate; DAL_SellerOpreateLog SellerOpreateLogDAL = new DAL_SellerOpreateLog(); SellerOpreateLogDAL.Insert(sellerOpreateLog); }
public void Insert(SellerOpreateLog sellerOpreateLog) { string SQLServerConnectString = "Data Source=localhost;Initial Catalog=WebAPPDevDotNETFinnalTest;Integrated Security=True;Pooling=False"; SqlConnection SQLConnection = new SqlConnection(SQLServerConnectString); string SQLCommandText = "INSERT INTO [dbo].[SellerOpreateLog] ([ModelID], [SellerID], [UserID], [Quantity], [Object], [Opreate]) VALUES (@ModelID, @SellerID, @UserID, @Quantity, @Object, @Opreate)"; SqlCommand SQLCommand = new SqlCommand(SQLCommandText, SQLConnection); SQLCommand.Parameters.Add(new SqlParameter("@ModelID", sellerOpreateLog.ModelID)); SQLCommand.Parameters.Add(new SqlParameter("@SellerID", sellerOpreateLog.SellerID)); SQLCommand.Parameters.Add(new SqlParameter("@UserID", sellerOpreateLog.UserID)); SQLCommand.Parameters.Add(new SqlParameter("@Quantity", sellerOpreateLog.Quantity)); SQLCommand.Parameters.Add(new SqlParameter("@Object", sellerOpreateLog.Object)); SQLCommand.Parameters.Add(new SqlParameter("@Opreate", sellerOpreateLog.Opreate)); SQLConnection.Open(); SQLCommand.ExecuteNonQuery(); SQLConnection.Close(); }