예제 #1
0
        internal void Create(ServiceProvision serviceProvision)
        {
            string sqlExpression = $"INSERT INTO [ServiceProvisions]([ClientId],[MasterId],[ServiceId],[DT],[Sale])" +
                                   $" Values ({ serviceProvision.ClientId},{serviceProvision.MasterId},{serviceProvision.ServiceId},'{serviceProvision.Dt.ToString("yyyy-MM-dd HH:mm:ss")}',{serviceProvision.Sale})";

            using (SqlConnection connection = DbConnector.GetConnection)
            {
                SqlCommand command = new SqlCommand(sqlExpression, connection);
                int        number  = command.ExecuteNonQuery();
            }
        }
예제 #2
0
 internal void Update(ServiceProvision serviceProvision)
 {
 }
 public EditScheduleItemWindow(ServiceProvision s)
 {
     InitializeComponent();
     _serviceProvision = s;
 }