protected void btCopy_Click(object sender, EventArgs e)
{
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "MainActivity"))
{
Response.Redirect("MainActivity.aspx?ckmode=7&Cr=0");
}
string strSql = " Select MainActivityID, StudyYear, MainActivityName, Detail, aTarget, aTarget2, Sort From MainActivity Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Sort ";
DataView dvMainActivity = Conn.Select(strSql);
Int32 x = 0;
if (dvMainActivity.Count != 0)
{
for (int i = 0; i < dvMainActivity.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
x += Conn.AddNew("MainActivity", "MainActivityID, StudyYear, MainActivityName, Detail, aTarget, aTarget2, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate",
NewID, ddlSearchYear.SelectedValue, dvMainActivity[i]["MainActivityName"].ToString(), dvMainActivity[i]["Detail"].ToString(), dvMainActivity[i]["aTarget"].ToString(), dvMainActivity[i]["aTarget2"].ToString(), dvMainActivity[i]["Sort"].ToString(), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
}
Response.Redirect("MainActivity.aspx?ckmode=1&Cr=" + x);
}
else
{
Response.Redirect("MainActivity.aspx?ckmode=6&Cr=0");
}
}
protected void btCopy_Click(object sender, EventArgs e)
{
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "StrategicPlan"))
{
Response.Redirect("StrategicPlan.aspx?ckmode=7&Cr=0");
}
string strSql = " Select StrategicPlanID, StudyYear, StrategicPlanName, Detail, Sort, DeptCode From StrategicPlan Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Sort ";
DataView dvStrategicPlan = Conn.Select(strSql);
Int32 x = 0;
if (dvStrategicPlan.Count != 0)
{
for (int i = 0; i < dvStrategicPlan.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
x += Conn.AddNew("StrategicPlan", "StrategicPlanID, StudyYear, StrategicPlanName, Detail, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate, DeptCode",
NewID, ddlSearchYear.SelectedValue, dvStrategicPlan[i]["StrategicPlanName"].ToString(), dvStrategicPlan[i]["Detail"].ToString(), dvStrategicPlan[i]["Sort"].ToString(), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now, dvStrategicPlan[i]["DeptCode"].ToString());
}
Response.Redirect("StrategicPlan.aspx?ckmode=1&Cr=" + x);
}
else
{
Response.Redirect("StrategicPlan.aspx?ckmode=6&Cr=0");
}
}
protected void btCopy_Click(object sender, EventArgs e)
{
BTC btc = new BTC();
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "CostsCenter"))
{
btc.Msg_Head(Img1, MsgHead, true, "7", 0);
return;
}
Connection Conn = new Connection();
string strSql = " Select CostsCode, StudyYear, CostsName, CostsDetail, Sort From CostsCenter Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Sort ";
DataView dvCostsCenter = Conn.Select(strSql);
if (dvCostsCenter.Count != 0)
{
for (int i = 0; i < dvCostsCenter.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
Int32 x = Conn.AddNew("CostsCenter", "CostsCode, StudyYear, CostsName, CostsDetail, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlSearchYear.SelectedValue, dvCostsCenter[i]["CostsName"].ToString(), dvCostsCenter[i]["CostsDetail"].ToString(), dvCostsCenter[i]["Sort"].ToString(), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
}
btc.Msg_Head(Img1, MsgHead, true, "1", 1);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "CostsCenter", ddlSearchYear.SelectedValue);
DataBind();
}
else
{
btc.Msg_Head(Img1, MsgHead, true, "6", 0);
}
}
protected void btCopy_Click(object sender, EventArgs e)
{
StringBuilder strbSql = new StringBuilder();
int result = 0;
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "Strategies"))
{
btc.Msg_Head(Img1, MsgHead, true, "7", 0);
return;
}
string strSql = " Select StrategiesCode, StudyYear, StrategiesName, Sort From Strategies Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Sort ";
DataView dvStrategies = Conn.Select(strSql);
if (dvStrategies.Count != 0)
{
for (int i = 0; i < dvStrategies.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
Int32 x = Conn.AddNew("Strategies", "StrategiesCode, StudyYear, StrategiesName, Sort, Df, DelFlag, SchoolID, CreateUser, CreateDate, UpdateUser, UpdateDate",
NewID, ddlSearchYear.SelectedValue, dvStrategies[i]["StrategiesName"].ToString(), dvStrategies[i]["Sort"].ToString(), 0, 0, CurrentUser.SchoolID, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
strSql = "Select * From StrategiesIndicators Where StrategiesCode = '" + dvStrategies[i]["StrategiesCode"].ToString() + "'";
DataView dvStrategiesIndicators = Conn.Select(strSql);
if (dvStrategiesIndicators.Count != 0)
{
for (int j = 0; j < dvStrategiesIndicators.Count; j++)
{
strbSql.AppendFormat("INSERT INTO StrategiesIndicators (StrategiesCode, RecNum, IndicatorsName) VALUES ('{0}',{1},'{2}');",
NewID, Convert.ToDecimal(dvStrategiesIndicators[j]["RecNum"]), dvStrategiesIndicators[j]["IndicatorsName"].ToString());
}
}
strSql = "Select * From CorporateStrategy Where DelFlag = 0 And StrategiesCode = '" + dvStrategies[i]["StrategiesCode"].ToString() + "'";
DataView dvCorporateStrategy = Conn.Select(strSql);
if (dvCorporateStrategy.Count != 0)
{
for (int j = 0; j < dvCorporateStrategy.Count; j++)
{
strbSql.AppendFormat("INSERT INTO CorporateStrategy (CorporateStrategyID, StudyYear, CorporateStrategyName, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate, StrategiesCode)VALUES('{0}',{1},'{2}',{3},{4},'{5}','{6}','{7}','{8}','{9}');",
Guid.NewGuid().ToString(), Convert.ToInt32(ddlSearchYear.SelectedValue), dvCorporateStrategy[j]["CorporateStrategyName"].ToString(), Convert.ToDecimal(dvCorporateStrategy[j]["Sort"]), 0, CurrentUser.ID, DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-gb")) + " 00:00:00.000", CurrentUser.ID, DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-gb")) + " 00:00:00.000", NewID);
}
}
}
result = Conn.Execute(strbSql.ToString());
btc.Msg_Head(Img1, MsgHead, true, "1", 1);
btc.CopyEnable(lblCopy, ddlOldYear, btCopy, "Strategies", ddlSearchYear.SelectedValue);
DataBind();
}
else
{
btc.Msg_Head(Img1, MsgHead, true, "6", 0);
}
}
protected void btCopy_Click(object sender, EventArgs e)
{
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "IndicatorSMS"))
{
Response.Redirect("IndicatorSMS.aspx?ckmode=7&Cr=0");
}
string strSql = " Select IndicatorSMSCode, StudyYear, IndicatorSMSName, Sort From IndicatorSMS Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Sort ";
DataView dvIndicatorSMS = Conn.Select(strSql);
Int32 x = 0;
if (dvIndicatorSMS.Count != 0)
{
for (int i = 0; i < dvIndicatorSMS.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
x += Conn.AddNew("IndicatorSMS", "IndicatorSMSCode, StudyYear, IndicatorSMSName, Sort, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlSearchYear.SelectedValue, dvIndicatorSMS[i]["IndicatorSMSName"].ToString(), dvIndicatorSMS[i]["Sort"].ToString(), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
}
Response.Redirect("IndicatorSMS.aspx?ckmode=1&Cr=" + x);
}
else
{
Response.Redirect("IndicatorSMS.aspx?ckmode=6&Cr=0");
}
}
protected void btCopy_Click(object sender, EventArgs e)
{
if (btc.CkDataDuplicate(ddlSearchYear.SelectedValue, "FactorRate"))
{
Response.Redirect("FactorRate.aspx?ckmode=7&Cr=0");
}
string strSql = " Select FactorRateID, StudyYear, Detail, Criterion, Translation, TMin, TMax From FactorRate Where DelFlag = 0 And StudyYear = '" + ddlOldYear.SelectedValue + "' Order By Criterion ";
DataView dvFactor = Conn.Select(strSql);
Int32 x = 0;
if (dvFactor.Count != 0)
{
for (int i = 0; i < dvFactor.Count; i++)
{
string NewID = Guid.NewGuid().ToString();
x += Conn.AddNew("FactorRate", "FactorRateID, StudyYear, Detail, Criterion, Translation, TMin, TMax, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlSearchYear.SelectedValue, dvFactor[i]["Detail"].ToString(), dvFactor[i]["Criterion"].ToString(), dvFactor[i]["Translation"].ToString(), dvFactor[i]["TMin"].ToString(), dvFactor[i]["TMax"].ToString(), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
}
Response.Redirect("FactorRate.aspx?ckmode=1&Cr=" + x);
}
else
{
Response.Redirect("FactorRate.aspx?ckmode=6&Cr=0");
}
}
