public override DataTable FindByColumn(object obj)
{
dt = SourceFile_MappingDetailColumnDto.Data();
dr = dt.NewRow();
dr["HID"] = "";
return(dao.FindByColumn(dt));
}
public bool Action(string DID, string No, string ColumnNo, string ColumnExcel, string ColumnName,
string ParentID, string Condition, string TotalRow, string StartPosition, string PositionLength,
string Desc, bool rowState, string UserLogin, PAction action)
{
dt = SourceFile_MappingDetailColumnDto.Data();
dr = dt.NewRow();
dr["DID"] = DID;
dr["No"] = No;
dr["ColumnNo"] = ColumnNo;
dr["ColumnExcel"] = ColumnExcel;
dr["ColumnName"] = ColumnName;
dr["ParentID"] = ParentID;
dr["Condition"] = Condition;
dr["TotalRow"] = TotalRow;
dr["PositionLength"] = PositionLength;
dr["StartPosition"] = StartPosition;
dr["Desc"] = Desc;
dr["ROW_STATE"] = rowState ? "1" : "0";
dr["CREATE_BY"] = UserLogin;
dr["UPDATE_BY"] = UserLogin;
dt.Rows.Add(dr);
switch (action)
{
case PAction.Add: isCan = Add(); break;
case PAction.Update: isCan = Update(); break;
case PAction.Delete: isCan = Delete(); break;
}
return(isCan);
}
public DataTable FindByColumn(String DID, string active)
{
dt = SourceFile_MappingDetailColumnDto.Data();
dr = dt.NewRow();
dr["DID"] = DID;
dr["ROW_STATE"] = active;
dt.Rows.Add(dr);
return(dao.FindByColumn(dt));
}
public void Update(DataTable detailEditDt, DataView dvDetail2)
{
SqlConnection conn = null;
SqlTransaction transaction = null;
try
{
conn = OpenConection();
transaction = conn.BeginTransaction();
ExcecuteNoneQuery("sp_SourceFile_MappingDetail_Update", conn, transaction, detailEditDt);
ExcecuteNoneQuery("sp_SourceFile_MappingDetailColumn_DeleteByDID", conn, transaction, detailEditDt);
if (dvDetail2 != null)
{
foreach (DataRowView rowView in dvDetail2)
{
DataRow mainDetailDr = detailEditDt.Rows[0];
DataTable detailColumnDt = SourceFile_MappingDetailColumnDto.Data();
DataRow detailColumnDr = detailColumnDt.NewRow();
DataRow row = rowView.Row;
string DID = (String)mainDetailDr["DID"];
detailColumnDr["DID"] = DID;
detailColumnDr["No"] = row["No"];
detailColumnDr["ColumnNo"] = row["ColumnNo"];
detailColumnDr["ColumnExcel"] = row["ColumnExcel"];
detailColumnDr["ColumnName"] = row["ColumnName"];
detailColumnDr["ParentID"] = row["ParentID"];
detailColumnDr["Condition"] = row["Condition"];
detailColumnDr["TotalRow"] = row["TotalRow"];
detailColumnDr["StartPosition"] = row["StartPosition"];
detailColumnDr["PositionLength"] = row["PositionLength"];
detailColumnDr["Desc"] = row["Desc"];
detailColumnDr["CREATE_BY"] = row["CREATE_BY"];
detailColumnDr["CREATE_DATE"] = row["CREATE_DATE"];
detailColumnDr["UPDATE_BY"] = mainDetailDr["UPDATE_BY"];
detailColumnDt.Rows.Add(detailColumnDr);
ExcecuteNoneQuery("sp_SourceFile_MappingDetailColumn_Insert", conn, transaction, detailColumnDt);
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
CloseConnection();
}
}
private void btnAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
btnSave.Enabled = true;
btnClose.Enabled = true;
btnAdd.Enabled = false;
gdView.Visible = false;
pageState = PAction.Add;
//Set data to edit datatable
DataRow detailEditDr = null;
if (detailEditDt.Rows.Count == 0)
{
detailEditDr = detailEditDt.NewRow();
detailEditDt.Rows.Add(detailEditDr);
}
detailEditDr = detailEditDt.Rows[0];
detailEditDr["HID"] = "1";
int maxNo = int.MinValue;
int maxDID = int.MinValue;
foreach (DataRow dr in dtDetail.Rows)
{
int no = dr.Field <int>("No");
maxNo = Math.Max(maxNo, no);
int did = dr.Field <int>("DID");
maxDID = Math.Max(maxDID, did);
}
detailEditDr["No"] = maxNo + 1;
detailEditDr["DID"] = maxDID + 1;
DataTable dt = SourceFile_MappingDetailColumnDto.Data();
DataView dv = dt.DefaultView;
gdDetail.DataSource = dv;
gdDetail.RefreshDataSource();
txtSourceFileRefName.Text = "";
txtKeyWord.Text = "";
txtStartColumn.Text = "";
txtStartRow.Text = "";
cbFileType.SelectedIndex = 0;
cbType.SelectedIndex = 0;
popDetail.Show();
}
public override DataTable FindByAll()
{
isCan = false;
DataTable dtObj = null;
try
{
DataTable dt = SourceFile_MappingDetailColumnDto.Data();
DataRow dr = dt.NewRow();
dr["ROW_STATE"] = "1";
dt.Rows.Add(dr);
OpenConection();
dtObj = ExcecuteToDataTable("sp_SourceFile_MappingDetailColumn_FindByAll", dt);
}
catch (Exception ex)
{ throw ex; }
finally
{ CloseConnection(); }
return(dtObj);
}
public void Add(DataTable detailEditDt, DataView dvDetail2)
{
SqlConnection conn = null;
SqlTransaction transaction = null;
try
{
conn = OpenConection();
transaction = conn.BeginTransaction();
string procName = "sp_SourceFile_MappingDetail_Insert";
parameterList = GetParameterList(procName, conn, transaction, detailEditDt);
command = new SqlCommand(procName, conn, transaction);
command.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter[] param in parameterList)
{
SqlParameter[] tempArr = new SqlParameter[param.Length];
param.CopyTo(tempArr, 0);
command.Parameters.Clear();
command.Parameters.AddRange(tempArr);
command.ExecuteNonQuery();
}
string DID = command.Parameters[0].Value.ToString();
ExcecuteNoneQuery("sp_SourceFile_MappingDetailColumn_DeleteByDID", conn, transaction, detailEditDt);
if (dvDetail2 != null)
{
foreach (DataRowView rowView in dvDetail2)
{
DataRow mainDetailDr = detailEditDt.Rows[0];
DataTable detailColumnDt = SourceFile_MappingDetailColumnDto.Data();
DataRow detailColumnDr = detailColumnDt.NewRow();
DataRow row = rowView.Row;
//string DID = (String)mainDetailDr["DID"];
detailColumnDr["DID"] = DID;
detailColumnDr["No"] = row["No"];
detailColumnDr["ColumnNo"] = row["ColumnNo"];
detailColumnDr["ColumnExcel"] = row["ColumnExcel"];
detailColumnDr["ColumnName"] = row["ColumnName"];
detailColumnDr["ParentID"] = row["ParentID"];
detailColumnDr["Condition"] = row["Condition"];
detailColumnDr["TotalRow"] = row["TotalRow"];
detailColumnDr["StartPosition"] = row["StartPosition"];
detailColumnDr["PositionLength"] = row["PositionLength"];
detailColumnDr["Desc"] = row["Desc"];
detailColumnDr["CREATE_BY"] = row["CREATE_BY"];
detailColumnDr["CREATE_DATE"] = row["CREATE_DATE"];
detailColumnDr["UPDATE_BY"] = mainDetailDr["UPDATE_BY"];
detailColumnDt.Rows.Add(detailColumnDr);
ExcecuteNoneQuery("sp_SourceFile_MappingDetailColumn_Insert", conn, transaction, detailColumnDt);
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
CloseConnection();
}
}
