public ServiceNoteEdit(ServiceNote serviceNote, string roomName, bool canEdit) { Init(); Load += ServiceNoteEdit_Load; if (canEdit) { Text = "Edit service note"; } else { Text = "Detail service note"; btnSave.Text = "Close"; btnSaveAndExport.Enabled = false; } txtId.Text = serviceNote.Id; dateTimePickerDate.Text = serviceNote.Date; cmbRoom.SelectedIndex = cmbRoom.FindStringExact(roomName); cmbRoom.Enabled = false; txtContractID.Text = serviceNote.Conntractid; txtTotalMoney.Text = serviceNote.Total.ToString(); //Load service note detail here var searchInfo = new ServiceNoteDetail() { Servicenoteid = serviceNote.Id }; dgvServiceNoteDetail.DataSource = serviceNoteBLT.searchServiceNoteDetail(searchInfo); }
public DataTable searchServiceNoteDetail(ServiceNoteDetail rt) { return serviceNoteDAT.searchServiceNoteDetail(rt); }
public DataTable searchServiceNoteDetail(ServiceNoteDetail svcnd) { try { string[] names = new string[8]; object[] values = new object[8]; names[0] = "@p_ID"; values[0] = svcnd.Id; names[1] = "@p_SERVICENOTEID"; values[1] = svcnd.Servicenoteid; names[2] = "@p_SERVICEID"; values[2] = svcnd.Serviceid; names[3] = "@p_NUMBEROLD"; values[3] = svcnd.Numberold; names[4] = "@p_NUMBERNEW"; values[4] = svcnd.Numbernew; names[5] = "@p_NUMBERUSED"; values[5] = svcnd.NumberUsed; names[6] = "@p_TOTAL"; values[6] = svcnd.Total; names[7] = "@p_TOP"; values[7] = 0; return this.ExcuteStoreProcedure("SERVICENOTEDETAIL_Search", names, values); } catch (System.Exception ex) { Console.WriteLine("Message = {1}", ex.Message); } return null; }