private void btnAddRow_Click(object sender, EventArgs e) { InspectionStandardDto inspection = new InspectionStandardDto(); List <InspectionStandardDto> inspectionList = grcInspectionStandard.DataSource as List <InspectionStandardDto>; int seqNO = 0; if (inspectionList == null || inspectionList.Count == 0) { inspection.SeqNO = 1; } else { foreach (InspectionStandardDto inp in inspectionList) { if (inp.SeqNO > seqNO) { seqNO = inp.SeqNO; } } } inspection.SeqNO = seqNO + 1; inspection.ProjectCode = projectCode; inspection.SubjectCode = subjectCode; dataHandler.AddRow(inspection); }
//保存 //查看图片 private void btnViewPic_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { ExecuteTeamAlterDto dto = grvArbitrationTeamAlter.GetRow(grvArbitrationTeamAlter.FocusedRowHandle) as ExecuteTeamAlterDto; DataSet ds = service.SearchAnswerDtl2(dto.ProjectCode, dto.SubjectCode, dto.ShopCode); List <InspectionStandardDto> inspectionStandardlist = new List <InspectionStandardDto>(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { InspectionStandardDto inspectionStandardDto = new InspectionStandardDto(); inspectionStandardDto.SubjectCode = Convert.ToString(ds.Tables[0].Rows[i]["SubjectCode"]); inspectionStandardDto.ProjectCode = Convert.ToString(ds.Tables[0].Rows[i]["ProjectCode"]); inspectionStandardDto.SeqNO = Convert.ToInt32(ds.Tables[0].Rows[i]["SeqNO"]); inspectionStandardDto.FileName = Convert.ToString(ds.Tables[0].Rows[i]["FileName"]); inspectionStandardDto.FileType = Convert.ToString(ds.Tables[0].Rows[i]["FileType"]); inspectionStandardDto.CheckOptionCode = Convert.ToString(ds.Tables[0].Rows[i]["CheckOptionCode"]) == "" ? "01" : Convert.ToString(ds.Tables[0].Rows[i]["CheckOptionCode"]); inspectionStandardlist.Add(inspectionStandardDto); } } if (inspectionStandardlist.Count > 0) { string[] filelist = new string[inspectionStandardlist.Count]; for (int i = 0; i < inspectionStandardlist.Count; i++) { filelist[i] = inspectionStandardlist[i].FileName; } AllPictureShow2 pic = new AllPictureShow2("", filelist, dto.ProjectCode + dto.ShopName, dto.SubjectCode, "", ""); pic.ShowDialog(); } }
private void SearchProject(string projectCode, string subjectCode) { grcInspectionStandard.DataSource = null; List <InspectionStandardDto> inspectionList = new List <InspectionStandardDto>(); //string sql = string.Format("EXEC up_XHX_InspectionStandard_R '{0}','{1}'", projectCode, subjectCode); //DataSet ds = CommonHandler.query(sql); DataSet ds = service.SearchInspectionStandard(projectCode, subjectCode); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { InspectionStandardDto inspection = new InspectionStandardDto(); inspection.ProjectCode = Convert.ToString(ds.Tables[0].Rows[i]["ProjectCode"]); inspection.SubjectCode = Convert.ToString(ds.Tables[0].Rows[i]["SubjectCode"]); inspection.SeqNO = Convert.ToInt32(ds.Tables[0].Rows[i]["SeqNO"]); inspection.InspectionStandardName = Convert.ToString(ds.Tables[0].Rows[i]["InspectionStandardName"]); inspectionList.Add(inspection); } grcInspectionStandard.DataSource = inspectionList; } }