public static void Main(string[] args)
{
var serverHanler = new ServerHandler();
long pk = serverHanler.InsertToMainServer();
serverHanler.SelectFromServer(pk);
var test = new DataToJson();
test.OutputJson();
}
public static string GetArtName(string deviceid)
{
DataTable tb = new DataTable();
string ReturnValue = string.Empty;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString()))
{
SqlCommand cmd = new SqlCommand();
conn.Open();
cmd.Connection = conn;
string str1 = string.Format(
@"select art.ArtName from Equ_DeviceInfoList device
left join Mes_ProcessArtList art on device.ProcessCode = art.ProcessCode
where device.DeviceCode='{0}'",
deviceid
);
cmd.CommandType = CommandType.Text;
cmd.CommandText = str1;
SqlDataAdapter Datapter = new SqlDataAdapter(cmd);
Datapter.Fill(tb);
ReturnValue = DataToJson.DataTableJson(tb);
return(ReturnValue);
}
}
