private void exeUpdate(string zkEndTime, string zkEndTm_val, string zkKousu, string zkKousu_val, string taskNm)
{
OracleParameter[] param = new OracleParameter[] {
new OracleParameter(":" + zkEndTime, OracleDbType.Varchar2),
new OracleParameter(":" + zkKousu, OracleDbType.Varchar2),
new OracleParameter(":TASKNM", OracleDbType.Varchar2),
};
param[0].Value = zkEndTm_val;
param[1].Value = zkKousu_val;
param[2].Value = taskNm;
List <string> taskList = new List <string>();
taskList.Add(zkEndTime);
taskList.Add(zkKousu);
upCnt = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.updateTask(taskList), param);
if (upCnt > 0)
{
this.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll);
}
}
private void exeUpdate(string fieldNm, string fieldValue, string taskNm)
{
OracleParameter[] param = new OracleParameter[] {
new OracleParameter(":" + fieldNm, OracleDbType.Varchar2),
new OracleParameter(":TASKNM", OracleDbType.Varchar2),
};
param[0].Value = fieldValue;
param[1].Value = taskNm;
upCnt = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.upOneField(fieldNm), param);
if (upCnt > 0)
{
this.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll);
}
}