private void InitialFormWithType() { string sql = "DimensionId = '" + this.CombinId.ToString() + "'"; ProductDim_DetailsCollection detailList = ProductDim_Details.LoadCollection(sql); foreach (ProductDim_Details detail in detailList) { if (detail.APPENDIX1.Length > 0 && detail.APPENDIX2.Length == 0 && detail.APPENDIX3.Length == 0) { this.FormType = FormLayoutType.Appendix1; } else if (detail.APPENDIX1.Length == 0 && detail.APPENDIX2.Length > 0 && detail.APPENDIX3.Length == 0) { this.FormType = FormLayoutType.Appendix2; } else if (detail.APPENDIX1.Length == 0 && detail.APPENDIX2.Length == 0 && detail.APPENDIX3.Length > 0) { this.FormType = FormLayoutType.Appendix3; } else { this.FormType = FormLayoutType.All; } } }
private void cboCombinationNum_SelectedIndexChanged(object sender, EventArgs e) { dgAppendixList.DataSource = null; DataTable dt = this.dgAppendixList.DataSource as DataTable; if (dt == null) { this.FillDataGridView(); dt = this.dgAppendixList.DataSource as DataTable; } if (DAL.Common.Utility.IsGUID(cboCombinationNum.SelectedValue.ToString())) { string sql = "DimensionId = '" + cboCombinationNum.SelectedValue.ToString() + "'"; ProductDim_DetailsCollection detailList = ProductDim_Details.LoadCollection(sql); foreach (ProductDim_Details detail in detailList) { DataRow row = dt.NewRow(); row["RowNum"] = dt.Rows.Count + 1; row["APPENDIX1"] = (detail.APPENDIX1); row["APPENDIX2"] = (detail.APPENDIX2); row["APPENDIX3"] = (detail.APPENDIX3); row["APPENDIX1Id"] = (GetAppendix1Id(detail.APPENDIX1)); row["APPENDIX2Id"] = (GetAppendix2Id(detail.APPENDIX2)); row["APPENDIX3Id"] = (GetAppendix3Id(detail.APPENDIX3)); dt.Rows.Add(row); } } this.dgAppendixList.DataSource = dt; }
private void DeleteDetails(Guid dimensionId) { string sql = "DimensionId = '" + dimensionId.ToString() + "'"; ProductDim_DetailsCollection detailList = ProductDim_Details.LoadCollection(sql); foreach (ProductDim_Details detail in detailList) { detail.Delete(); } }
private void CombinA2(ref ListView oList, string a1) { if (DAL.Common.Utility.IsGUID(cboAppendix2.SelectedValue.ToString())) { string sql = "DimensionId = '" + cboAppendix2.SelectedValue.ToString() + "'"; ProductDim_DetailsCollection detailList = ProductDim_Details.LoadCollection(sql); foreach (ProductDim_Details detail in detailList) { if (!string.IsNullOrEmpty(detail.APPENDIX2)) { CombinA3(ref oList, a1, detail.APPENDIX2); } } } }