/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
mvMessage.CheckRequired(txtBudget, "Ngân sách kỳ: là Danh mục bắt bắt buộc nhập");
if (!mvMessage.IsValid) return;
//Get and Insert Data
BD_BudgetScheduleData data = new BD_BudgetScheduleData();
ITransaction tran = factory.GetInsertObject(data);
data.Budget = txtBudget.Text.Trim();
data.BuildingId = Func.ParseString(Session["__BUILDINGID__"]);
data.YearMonth = drpYear.SelectedValue;
data.ModifiedBy = Page.User.Identity.Name;
data.CreatedBy = Page.User.Identity.Name;
data.Created = DateTime.Now.ToString("yyyyMMddHHmmss");
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
data.DelFlag = "0";
Execute(tran);
if (!HasError)
{
OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addSuccess, Page.User.Identity.Name);
mvMessage.SetCompleteMessage(addSuccess);
DbHelper.FillList(drpBudget, "Select * from BD_BudgetSchedule Where DelFlag = 0 and YearMonth = '" + drpYear.SelectedValue + "' and BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "'", "Budget", "id");
DbHelper.FillListSearch(drpBudgetExport, "Select * from BD_BudgetSchedule Where DelFlag = 0 and YearMonth = '" + drpYear.SelectedValue + "' and BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "'", "Budget", "id");
//// Them vao de xuat ngan sach
string yearmonth = drpYear.SelectedValue;
string building = Func.ParseString(Session["__BUILDINGID__"]);
DataTable dtTable = new DataTable();
dtTable.Columns.Add("BuggetScheduleId", Type.GetType("System.String"));
dtTable.Columns.Add("PaymentType", Type.GetType("System.String"));
dtTable.Columns.Add("PaymentId", Type.GetType("System.String"));
dtTable.Columns.Add("colNo", Type.GetType("System.String"));
dtTable.Columns.Add("delFlag", Type.GetType("System.String"));
dtTable.Columns.Add("ParentId", Type.GetType("System.Int32"));
dtTable.Columns.Add("ItemLevel", Type.GetType("System.String"));
string buildingId = Func.ParseString(Session["__BUILDINGID__"]);
string sqlTmp = "Select Name,id,ParentId,ItemLevel from BD_PaymentType Where delflag = '0' and BuildingId = '" + buildingId + "' ";
sqlTmp += "Union ";
sqlTmp += "Select Name,id,ParentId,ItemLevel from Mst_PaymentType";
DataTable dt = DbHelper.GetDataTable("Select * from (" + sqlTmp + ") A order by id");
foreach (DataRow dr in dt.Rows)
{
if (dr["ParentId"].ToString() == "")
{
int j = 1;
string Name = dr["Name"].ToString();
string id = dr["Id"].ToString();
string itemLevel = dr["ItemLevel"].ToString();
dtTable.Rows.Add(data.id, Name, id, j, "0", Func.ParseInt(dr["ParentId"]), itemLevel);
GetChildItems(data.id, id, dt, dtTable, j);
}
}
using (SqlBulkCopy copy = new SqlBulkCopy(Gnt.Configuration.ApplicationConfiguration.ConnectionString))
{
copy.DestinationTableName = "BD_BudgetScheduleDetail";
copy.BatchSize = 3000;
copy.BulkCopyTimeout = 99999;
copy.ColumnMappings.Add(0, "BuggetScheduleId");
copy.ColumnMappings.Add(1, "PaymentType");
copy.ColumnMappings.Add(2, "PaymentId");
copy.ColumnMappings.Add(3, "colNo");
copy.ColumnMappings.Add(4, "DelFlag");
copy.ColumnMappings.Add(5, "ParentId");
copy.ColumnMappings.Add(6, "ItemLevel");
copy.WriteToServer(dtTable);
}
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionInsertId, addUnSuccess, Page.User.Identity.Name);
mvMessage.AddError(addUnSuccess);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
mvMessage.CheckRequired(txtBudget, "Ngân sách kỳ: là Danh mục bắt bắt buộc nhập");
if (!mvMessage.IsValid) return;
//Get and Insert Data
BD_BudgetScheduleData data = new BD_BudgetScheduleData();
ITransaction tran = factory.GetLoadObject(data, drpBudget.SelectedValue);
Execute(tran);
if (!HasError)
{
//Get Data
data = (BD_BudgetScheduleData)tran.Result;
data.Budget = txtBudget.Text.Trim();
data.ModifiedBy = Page.User.Identity.Name;
data.Modified = DateTime.Now.ToString("yyyyMMddHHmmss");
tran = factory.GetUpdateObject(data);
Execute(tran);
if (!HasError)
{
OperationLogger.WriteInfo(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateSuccess, Page.User.Identity.Name);
mvMessage.SetCompleteMessage(updateSuccess);
DbHelper.FillList(drpBudget, "Select * from BD_BudgetSchedule Where YearMonth = '" + drpYear.SelectedValue + "' and BuildingId = '" + Func.ParseString(Session["__BUILDINGID__"]) + "'", "Budget", "id");
}
else
{
OperationLogger.WriteError(Constants.LogOperationAlbumId, Constants.LogActionUpdateId, updateUnSuccess, Page.User.Identity.Name);
mvMessage.AddError(updateUnSuccess);
}
}
}
