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"); } }