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 SaveDetails(Guid dimensionId)
{
string sql = "DimensionId = '" + dimensionId.ToString() + "' AND DimDetailId = '{0}'";
DataTable oTable = null;
if (dgvCombinationList.DataSource != null)
{
oTable = dgvCombinationList.DataSource as DataTable;
DeleteDetails(dimensionId);
foreach (DataRow row in oTable.Rows)
{
ProductDim_Details oDetail = ProductDim_Details.LoadWhere(string.Format(sql, row["DimDetailId"].ToString()));
if (oDetail == null)
{
oDetail = new ProductDim_Details();
oDetail.DimensionId = dimensionId;
}
oDetail.APPENDIX1 = row["Appendix1"].ToString();
oDetail.APPENDIX2 = row["Appendix2"].ToString();
oDetail.APPENDIX3 = row["Appendix3"].ToString();
oDetail.Save();
}
}
}
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);
}
}
}
}
