public bool insertData(DataRow r, ref string msg)
{
var sqlobj = new clsDataBase();
try
{
if (!sqlobj.SetbolConnection(this.conMiraiDBStr, ref msg))
{
return(false);
}
var insertStr = "";
insertStr += " INSERT INTO [dbo].[Mirai_手動登録] ";
insertStr += " ( ";
insertStr += " [グループ] ";
insertStr += " ,[有効] ";
insertStr += " ,[予約日時] ";
insertStr += " ,[予約Lat世界度] ";
insertStr += " ,[予約Lon世界度] ";
insertStr += " ,[No] ";
insertStr += " ,[案内Lat世界度] ";
insertStr += " ,[案内Lon世界度] ";
insertStr += " ,[案内先到着日時] ";
insertStr += " ,[予約住所] ";
insertStr += " ,[案内住所] ";
insertStr += " ,[案内名称] ";
insertStr += " ) VALUES ( ";
insertStr += " ' 4 '"; //[グループ] ";
insertStr += " , ' 1 '"; //[有効] ";
var YoyakuDateTime = (DateTime)r["YoyakuDateTime"];
var AnnaiDateTime = (DateTime)r["AnnaiYoyakudateTime"];
insertStr += " , '" + YoyakuDateTime + "'";//[予約日時] ";
var KokLat = ((int)r["KokLatitude"]) / 36000.0;
var KokLng = ((int)r["KokLongitude"]) / 36000.0;
var AnnaiLat = ((int)r["AnnaiLatitude"]) / 36000.0;
var AnnaiLng = ((int)r["AnnaiLongitude"]) / 36000.0;
var KokLatW = 0.0;
var KokLngW = 0.0;
var AnnaiLatW = 0.0;
var AnnaiLngW = 0.0;
if (!vb_dll.cls緯度経度変換.bol緯度経度変換_日本to世界(KokLat, KokLng, ref KokLatW, ref KokLngW))
{
//messageLog("緯度経度変換に失敗しました。:lat=" + KokLat + ", lng=" + KokLng);
return(false);
}
if (!vb_dll.cls緯度経度変換.bol緯度経度変換_日本to世界(AnnaiLat, AnnaiLng, ref AnnaiLatW, ref AnnaiLngW))
{
//messageLog("緯度経度変換に失敗しました。:lat=" + KokLat + ", lng=" + KokLng);
return(false);
}
KokLatW = Math.Round(KokLatW, 6);
KokLngW = Math.Round(KokLngW, 6);
AnnaiLatW = Math.Round(AnnaiLatW, 6);
AnnaiLngW = Math.Round(AnnaiLngW, 6);
insertStr += " , '" + KokLatW + "'"; //[予約Lat世界度] ";
insertStr += " , '" + KokLngW + "'"; //[案内住所] ";
insertStr += " , " + r["cd_key"];
insertStr += " , '" + AnnaiLatW + "'";
insertStr += " , '" + AnnaiLngW + "'";
insertStr += " , '" + AnnaiDateTime + "'";
insertStr += " , '" + r["KokAddress"] + "'";
insertStr += " , '" + r["AnnaiAddress"] + "'";
insertStr += " , '" + r["AnnaiBuil"] + "'";
insertStr += " ) ";
var inserres = sqlobj.GetshoExecuteNonQuery(insertStr, ref msg);
if (sqlobj.prpbolError == false)//error
{
msg = "sqlobj.prpbolError == false";
return(false);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
sqlobj.SetEndConnection();
}
}
public bool getData(ref string msg, string from, string to)
{
var sqlobjMIRAI = new clsDataBase();
try
{
if (!sqlobjMIRAI.SetbolConnection(this.conTsubameCTI, ref msg))
{
msg = "アップロードに失敗しました";
return(false);
}
// from = "2017-09-13 06:40:00";
// to = "2017-09-13 06:41:00";
var sqlStr = "select y.cd_key,YoyakuDateTime,KokLatitude,KokLongitude,AnnaiLatitude,AnnaiLongitude,AnnaiYoyakudateTime,a.AnnaiAddress,a.AnnaiBuil,y.KokAddress"
+ " from tempAnnai a inner join yoyaku y on a.cd_key=y.AnnaiCd_key where AnnaiLatitude is not null and AnnaiLongitude is not null and YoyakuDateTime between '" + from + "' and '" + to + "'";
var tbl = sqlobjMIRAI.GetdtTableSelectData(sqlStr, ref msg);
if (tbl == null)
{
msg = "予約データがありません";
return(false);
}
if (!sqlobjMIRAI.prpbolError)
{
msg = "アップロードに失敗しました";
return(false);
}
if (tbl.Rows.Count == 0)
{
msg = "予約データがありません";
return(false);
}
var errcount = 0;
for (int i = 0; i < tbl.Rows.Count; i++)
{
var msgimport = "";
if (!insertData(tbl.Rows[i], ref msgimport))
{
msg = "アップロードに失敗しました";
errcount++;
continue;
}
}
msg = "アップロードしました";
return(true);
}
catch (Exception)
{
msg = "アップロードに失敗しました";
return(false);
}
finally
{
sqlobjMIRAI.SetEndConnection();
}
}