private void AllDone()
{
//Camera到NeedleMark的坐标点进行赋值
DataSetting.Default.CameraLaserMark = new PointD(Machine.Instance.Robot.PosX, Machine.Instance.Robot.PosY);
//计算Laser到点胶阀的距离并赋值
Machine.Instance.Robot.CalibPrm.HeightCamera = new PointD(
(DataSetting.Default.LaserMark.X - DataSetting.Default.CameraLaserMark.X),
(DataSetting.Default.LaserMark.Y - DataSetting.Default.CameraLaserMark.Y));
//保存
if (DataSetting.Default.DoneStepCount <= 5)
{
DataSetting.Default.DoneStepCount = 5;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 5;
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
StepStateMgr.Instance.FindBy(4).IsDone = true;
StepStateMgr.Instance.FindBy(4).IsChecked();
this.DialogResult = DialogResult.OK;
this.Close();
}
private void BindSelectionDataSetting()
{
if (comboDataSelect.SelectedValue == null)
{
return;
}
var text = comboDataSelect.SelectedValue.ToString();
if (text == _null_text)
{
return;
}
DataSetting datasetting = null;
DataConfig.Instance().FindDataSetting(text, out datasetting);
var infoList = new List <DataValue>();
foreach (var datavalue in datasetting._child_list)
{
var temp = new DataValue();
temp._text = datavalue._text;
temp._name = datavalue._name;
temp._value = datavalue._value;
infoList.Add(temp);
}
_select_text = datasetting._text;
_select_name = datasetting._name;
_select_object = datasetting._isobject;
gridData.ItemsSource = infoList;
}
public void DoDone()
{
//抬起到SafeZ
Machine.Instance.Robot.MoveSafeZ();
//保存
if (DataSetting.Default.DoneStepCount <= 8)
{
DataSetting.Default.DoneStepCount = 8;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 8;
DataSetting.Default.PrimeZDistance = this.nudZDistance.Value;
Machine.Instance.Robot.CalibPrm.PrimeZ = Convert.ToDouble(this.nudZDistance.Value);
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
//是否需要？
Machine.Instance.UpdateLocations();
StepStateMgr.Instance.FindBy(7).IsDone = true;
StepStateMgr.Instance.FindBy(7).IsChecked();
this.DialogResult = DialogResult.OK;
this.Close();
//参数修改记录
//CompareObj.CompareProperty(Machine.Instance.Robot.CalibPrm, Machine.Instance.Robot.CalibPrmBackUp);
}
public void DoDone()
{
if (this.valveNo == 1)
{
if (DataSetting.Default.DoneStepCount <= 10)
{
DataSetting.Default.DoneStepCount = 10;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 10;
DataSetting.Save();
Machine.Instance.Robot.SaveCalibPrm();
StepStateMgr.Instance.FindBy(9).IsDone = true;
StepStateMgr.Instance.FindBy(9).IsChecked();
}
else
{
if (DataSetting.Default.DoneStepCount <= 14)
{
DataSetting.Default.DoneStepCount = 14;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 14;
DataSetting.Save();
Machine.Instance.Robot.SaveCalibPrm();
StepStateMgr.Instance.FindBy(13).IsDone = true;
StepStateMgr.Instance.FindBy(13).IsChecked();
}
this.DialogResult = DialogResult.OK;
this.Close();
}
protected void FindDataSetting(ref Dictionary <string, DataSetting> dic, string name, out DataSetting datasetting)
{
var ok = dic.TryGetValue(name, out datasetting);
if (!ok)
{
datasetting = new DataSetting();
datasetting._name = name;
dic.Add(name, datasetting);
}
}
private static DataSetting getDefaultDataSetting()
{
DataSetting ds = new DataSetting()
{
Name = "test",
DataConnectionString = "Server=127.0.0.1;port=3306;Database=mapleleaf;Uid=root;Pwd=root;charset=utf8;SslMode=none;",
DataSouceType = Core.Data.DataSouceType.MySQL
};
return(ds);
}
public void FindDataSetting(string name, out DataSetting datasetting)
{
var ok = _data_list.TryGetValue(name, out datasetting);
if (!ok)
{
datasetting = new DataSetting();
datasetting._name = name;
_data_list.Add(name, datasetting);
}
}
public void DoDone()
{
DataSetting.Default.DoneStepCount = 15;
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 15;
DataSetting.Save();
Machine.Instance.Robot.SaveCalibPrm();
StepStateMgr.Instance.FindBy(14).IsDone = true;
StepStateMgr.Instance.FindBy(14).IsChecked();
this.Close();
}
private void SaveData()
{
if (this.vavelNo == 1)
{
//保存Camera到NeedleMark的坐标点进行赋值
DataSetting.Default.CameraNeedle1Mark = new PointD(Machine.Instance.Robot.PosX, Machine.Instance.Robot.PosY);
//计算Needle到点胶阀的距离并赋值
//Machine.Instance.Robot.CalibPrm.NeedleCamera1 = new PointD(
// (DataSetting.Default.Needle1Mark.X - DataSetting.Default.CameraNeedle1Mark.X),
// (DataSetting.Default.Needle1Mark.Y - DataSetting.Default.CameraNeedle1Mark.Y));
//计算Needle到点胶阀的距离，转换为系统坐标
Machine.Instance.Robot.CalibPrm.NeedleCamera1 = (DataSetting.Default.Needle1Mark.ToSystem() - DataSetting.Default.CameraNeedle1Mark.ToSystem()).ToPoint();
//保存
if (DataSetting.Default.DoneStepCount <= 4)
{
DataSetting.Default.DoneStepCount = 4;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 4;
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
StepStateMgr.Instance.FindBy(3).IsDone = true;
StepStateMgr.Instance.FindBy(3).IsChecked();
}
else if (this.vavelNo == 2)
{
//保存Camera到NeedleMark的坐标点进行赋值
DataSetting.Default.CameraNeedle1Mark = new PointD(Machine.Instance.Robot.PosX, Machine.Instance.Robot.PosY);
//计算Needle到点胶阀的距离并赋值
Machine.Instance.Robot.CalibPrm.NeedleCamera2 = new PointD(
(DataSetting.Default.Needle2Mark.X - DataSetting.Default.CameraNeedle1Mark.X),
(DataSetting.Default.Needle2Mark.Y - DataSetting.Default.CameraNeedle1Mark.Y));
//保存
if (DataSetting.Default.DoneStepCount <= 12)
{
DataSetting.Default.DoneStepCount = 12;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 12;
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
StepStateMgr.Instance.FindBy(11).IsDone = true;
StepStateMgr.Instance.FindBy(11).IsChecked();
}
}
public void GetSettingTest()
{
DataSetting.UpdateOrAddReadConfig(readConfig);
DataSetting setting = DataSetting.GetSetting(Sites.APW);
Assert.Equal("Test", setting.EnvironmetName);
Assert.Equal(Sites.APW, setting.Site);
Assert.True(setting.EnableShowApiSwagger);
Assert.NotNull(setting.Version);
Assert.Equal("20191228", setting.Version.Version1);
Assert.Equal("2.0.0.1", setting.Version.Version2);
}
private void Button_Click_Add_Agent(object sender, RoutedEventArgs e)
{
if (_select_text == "" || _select_name == "")
{
return;
}
var datalist = (List <DataValue>)gridData.ItemsSource;
bool isvalid = false;
foreach (var datavalue in datalist)
{
if (datavalue._value != "0")
{
isvalid = true;
break;
}
}
if (!isvalid)
{
return;
}
var addsetting = new DataSetting();
addsetting._text = _select_text;
addsetting._name = _select_name;
addsetting._isobject = _select_object;
foreach (var datavalue in datalist)
{
if (datavalue._value != "0")
{
addsetting.AddDataValue(datavalue._text, datavalue._name, datavalue._value);
}
}
_agent_array.Add(addsetting);
// 绑定数据
BindTotalAgentList();
// 格式化数据
FormatTotalAgent();
// 重新绑定
BindSelectionDataSetting();
}
public void UpdateDataSetting(TextAsset targetXml)
{
List <ImageSize> list = ReadARTrackXml(targetXml.text);
List <DataSetting> dTarget = new List <DataSetting>(
(from DataSetting dt in TrackAssets where dt.xmlName == targetXml.name select dt));
if (dTarget.Count == 0)//不存在DataSet
{
DataSetting tData = new DataSetting();
tData.targetObjects = new List <TrackTarget>();
tData.xmlName = targetXml.name;
//增加ImageTarget
foreach (ImageSize imageSize in list)
{
TrackTarget tTarget = new TrackTarget();
tTarget.id = imageSize.id;
tTarget.width = imageSize.size.x;
tTarget.height = imageSize.size.y;
tTarget.localScale = new Vector3(1.0f, 1.0f, imageSize.size.y / imageSize.size.x);
tTarget.ManagerComponent = AssetDatabase.LoadAssetAtPath <MonoScript>("Assets/Vuforia/Scripts/DefaultTrackableEventHandler.cs").name;
tData.targetObjects.Add(tTarget);
}
TrackAssets.Add(tData);
}
else//存在DataSet
{
DataSetting dataSetting = dTarget[0];
foreach (ImageSize imageSize in list)
{
List <TrackTarget> selectionList = new List <TrackTarget>(
from TrackTarget t in dataSetting.targetObjects
where t.id == imageSize.id select t);
if (selectionList.Count == 0)
{
int dataSettingIndex = TrackAssets.IndexOf(dataSetting);
TrackTarget newTrack = new TrackTarget();
newTrack.id = imageSize.id;
newTrack.width = imageSize.size.x;
newTrack.height = imageSize.size.y;
TrackAssets[dataSettingIndex].targetObjects.Add(newTrack);
}
}
}
}
private void btnDone_Click(object sender, EventArgs e)
{
Machine.Instance.Robot.MoveSafeZ();
if (DataSetting.Default.DoneStepCount <= 11)
{
DataSetting.Default.DoneStepCount = 11;
}
Machine.Instance.Robot.CalibPrm.SavedItem = 11;
StepStateMgr.Instance.FindBy(10).IsDone = true;
StepStateMgr.Instance.FindBy(10).IsChecked();
DataSetting.Save();
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.SaveCalibPrm();
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// Store a setting
/// </summary>
/// <param name="key">Key.</param>
/// <param name="value">Value.</param>
public static void Set(string key, string value)
{
using (var ctx = new OTAContext())
{
var item = ctx.Settings.Where(x => x.DataKey == key).SingleOrDefault();
if (item != null)
{
item.DataValue = value;
}
else
{
ctx.Settings.Add(item = new DataSetting()
{
DataKey = key,
DataValue = value
});
}
ctx.SaveChanges();
}
}
public void DoDone()
{
Machine.Instance.Robot.CalibPrm.HeightSensorCenter = DataSetting.Default.HeightSensorCenter;
if (this.valvelNo == 1)
{
//保存
if (DataSetting.Default.DoneStepCount <= 6)
{
DataSetting.Default.DoneStepCount = 6;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 6;
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
StepStateMgr.Instance.FindBy(5).IsDone = true;
StepStateMgr.Instance.FindBy(5).IsChecked();
}
else if (this.valvelNo == 2)
{
//保存
if (DataSetting.Default.DoneStepCount <= 13)
{
DataSetting.Default.DoneStepCount = 13;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 13;
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
StepStateMgr.Instance.FindBy(12).IsDone = true;
StepStateMgr.Instance.FindBy(12).IsChecked();
}
this.DialogResult = DialogResult.OK;
this.Close();
//参数修改记录
//CompareObj.CompareProperty(Machine.Instance.Robot.CalibPrm, Machine.Instance.Robot.CalibPrmBackUp);
}
private void btnDone_Click(object sender, EventArgs e)
{
Machine.Instance.Robot.DefaultPrm.MinZ = Machine.Instance.Robot.PosZ;
Machine.Instance.Robot.MoveSafeZ();
Machine.Instance.Robot.SaveDefaultPrm();
if (DataSetting.Default.DoneStepCount <= 1)
{
DataSetting.Default.DoneStepCount = 1;
}
DataSetting.Save();
StepStateMgr.Instance.FindBy(0).IsDone = true;
StepStateMgr.Instance.FindBy(0).IsChecked();
//Machine.Instance.Robot.AxisZ.SetLimit(200, Machine.Instance.Robot.DefaultPrm.MinZ);
this.DialogResult = DialogResult.OK;
this.Close();
string msg = string.Format("MinZ oldValue: {0} -> newValue: {1}", this.minZ, Machine.Instance.Robot.DefaultPrm.MinZ);
Logger.DEFAULT.Info(LogCategory.SETTING, this.GetType().Name, msg);
}
public void DoDone()
{
if (this.flag == 4)
{
if (!this.err)
{
if (DataSetting.Default.DoneStepCount <= 3)
{
DataSetting.Default.DoneStepCount = 3;
}
DataSetting.Save();
//to do accept calibration result
Machine.Instance.Robot.CalibBy9dPrm = this.calibBy9dPrm;
Machine.Instance.Robot.SaveCalibBy9dPrm();
this.DialogResult = DialogResult.OK;
StepStateMgr.Instance.FindBy(2).IsDone = true;
StepStateMgr.Instance.FindBy(2).IsChecked();
this.Close();
}
}
}
public void DoDone()
{
//抬起到SafeZ
Machine.Instance.Robot.MoveSafeZ();
//保存
if (DataSetting.Default.DoneStepCount <= 9)
{
DataSetting.Default.DoneStepCount = 9;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 9;
DataSetting.Default.ScaleZDistance = this.nudZDistance.Value;
Machine.Instance.Robot.CalibPrm.ScaleIntervalHeight = Convert.ToDouble(this.nudZDistance.Value);
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
Machine.Instance.UpdateLocations();
StepStateMgr.Instance.FindBy(8).IsDone = true;
StepStateMgr.Instance.FindBy(8).IsChecked();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
//参数修改记录
//CompareObj.CompareProperty(Machine.Instance.Robot.CalibPrm, Machine.Instance.Robot.CalibPrmBackUp);
}
public void CreateDataSetting(TextAsset targetXml)
{
List <ImageSize> list = ReadARTrackXml(targetXml.text);
DataSetting tData = new DataSetting();
tData.targetObjects = new List <TrackTarget>();
tData.xmlName = targetXml.name;
//增加ImageTarget
foreach (ImageSize imageSize in list)
{
TrackTarget tTarget = new TrackTarget();
tTarget.id = imageSize.id;
tTarget.width = imageSize.size.x;
tTarget.height = imageSize.size.y;
tTarget.localScale = new Vector3(1.0f, 1.0f, imageSize.size.x / imageSize.size.y);
tTarget.ManagerComponent = AssetDatabase.LoadAssetAtPath <MonoScript>("Assets/Vuforia/Scripts/DefaultTrackableEventHandler.cs").name;
tData.targetObjects.Add(tTarget);
}
if (TrackAssets == null)
{
TrackAssets = new List <DataSetting>();
}
TrackAssets.Add(tData);
}
public void DoDone()
{
//对设置文件进行保存
if (DataSetting.Default.DoneStepCount <= 2)
{
DataSetting.Default.DoneStepCount = 2;
}
Machine.Instance.Robot.CalibPrm.SavedTime = DateTime.Now;
Machine.Instance.Robot.CalibPrm.SavedItem = 2;
Machine.Instance.Robot.SaveCalibPrm();
DataSetting.Save();
StepStateMgr.Instance.FindBy(1).IsDone = true;
StepStateMgr.Instance.FindBy(1).IsChecked();
if (Machine.Instance.Setting.MachineSelect == MachineSelection.RTV)
{
new TeachMeasureHeightAndMarkZ().ShowDialog();
}
this.DialogResult = DialogResult.OK;
this.Close();
//参数修改记录
//CompareObj.CompareProperty(Machine.Instance.Robot.CalibPrm, Machine.Instance.Robot.CalibPrmBackUp);
}
protected void Page_Load(object sender, EventArgs e)
{
DataSetting objSetting = new DataSetting();
style = objSetting.getValue("Domain");
if (style != null)
{
style = style.ToUpper();
}
if (style != null && style != "")
{
style += " - ";
}
if (Context.Items["strTitle"] != null)
{
style += Context.Items["strTitle"].ToString();
}
else
{
style += "QUẢN TRỊ HỆ THỐNG";
}
}
public void LoadDataConfig(string xmlfile)
{
_data_list.Clear();
try
{
XDocument document = XDocument.Load(xmlfile);
XElement root = document.Root;
Dictionary <string, DataSetting> classlist = new Dictionary <string, DataSetting>();
IEnumerable <XElement> enumerable = root.Elements();
foreach (XElement item in enumerable)
{
var classname = item.Attribute("Class").Value;
var dataname = item.Attribute("Name").Value;
var datatext = item.Attribute("Agent").Value;
if (datatext != "" && classname != "Player")
{
DataSetting datastting = null;
FindDataSetting(ref classlist, classname, out datastting);
datastting._text = datatext;
datastting.AddDataValue(datatext, dataname, "0");
}
}
//
foreach (XElement item in enumerable)
{
var classname = item.Attribute("Class").Value;
var dataname = item.Attribute("Name").Value;
var datatext = item.Attribute("Agent").Value;
if (datatext != "" && classname == "Player")
{
DataSetting datastting = new DataSetting();
datastting._name = dataname;
datastting._text = datatext;
{
DataSetting childstting = null;
var containclass = item.Attribute("ContainClass").Value;
if (containclass != "")
{
datastting._isobject = true;
FindDataSetting(ref classlist, containclass, out childstting);
datastting._child_list = childstting._child_list;
}
else
{
datastting._isobject = false;
datastting.AddDataValue(datatext, dataname, "0");
}
}
_data_list.Add(datatext, datastting);
}
}
}
catch (Exception ex)
{
}
}
private void SaveHouse()
{
Model.HouseModel model = new Model.HouseModel();
BLL.HouseBLL bll = new BLL.HouseBLL();
BLL.UserBLL ubll = new BLL.UserBLL();
model.HouseId = ReStr("HouseId");
if (model.HouseId != "")
{
model = bll.GetHouseModel(model.HouseId);
model.CreateTime = DateTime.Now;
}
else
{
model.CreateUser = ubll.CurrentUserId(); //如果是新增, 则给CreateUser赋值
}
model.HouseTitle = ReStr("HouseTitle", "");
model.HouseAddress = ReStr("HouseAddress", "");
model.Hshi = ReInt("Hshi", 0);
model.Hting = ReInt("Hting", 0);
model.Hchu = ReInt("Hchu", 0);
model.Hwei = ReInt("Hwei", 0);
model.Hyangtai = ReInt("Hyangtai", 0);
model.HouseModelId = ReInt("HouseModelId", 0);
model.DecorationId = ReInt("DecorationId", 0);
model.PropertyTypeId = ReInt("PropertyTypeId", 0);
model.HouseClassId = ReInt("HouseClassId", 0);
model.Floor = ReInt("Floor", 0);
model.FloorALL = ReInt("FloorALL", 0);
model.HouseTypeId = ReInt("HouseTypeId", 0);
model.Rent = ReDecimal("Rent");
model.Price = ReDecimal("Price");
model.IsAgency = ReBool("IsAgency");
model.Device = ReStr("Device");
model.Memo = ReStr("Memo", "");
model.CreateTime = DateTime.Now;
model.PingFang = ReDecimal("PingFang");
model.ChaoXiangId = ReInt("ChaoXiangId", 0);
model.HouseImgId = ReStr("HouseImgId", "");
model.ContactName = ReStr("ContactName");
model.ContactTell = ReStr("ContactTell");
model.ContactPhone = ReStr("ContactPhone");
model.ContactEmail = ReStr("ContactEmail");
model.ContactQQ = ReStr("ContactQQ");
model.CommunityTitle = ReStr("CommunityTitle", "");
model.CommunityId = ReInt("CommunityId", 0);
model.TownId = ReDecimal("TownId", 0);
model.HouseLat = ReDecimal("HouseLat");
model.HouseLng = ReDecimal("HouseLng");
model.RecommendLv = ReInt("RecommendLv", 0);
DataTable dt = DataSetting.CXmlToDatatTable(ReStr("HouseAllImgHtmlStr"));
#region 事务开启
TransactionOptions transactionOption = new TransactionOptions();
transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOption))
{
#endregion
bll.SaveHouse(model);
bll.DeleteHouseByHouseId(model.HouseId);
if (dt != null)
{
//有图片上传
Model.HouseVsImgModel HvI = new Model.HouseVsImgModel();
foreach (DataRow dr in dt.Rows)
{
HvI.HouseId = model.HouseId;
HvI.ImgId = dr["ImgId"].ToString();
HvI.Memo = "UE";
HvI.VsType = "房源图片";
bll.AddHouseVsImg(HvI);
}
}
//推广开始
if (model.RecommendLv > 0)
{
}
#region 事务关闭
transactionScope.Complete();
}
#endregion
ReDict2.Add("HouseId", model.HouseId);
ReTrue();
}
public List <DashboardResult> GetDashboardResults(DataSetting setting)
{
List <DashboardResult> res = new List <DashboardResult>();
using (SqlConnection conn = new SqlConnection(Cs.GetConnection()))
{
conn.Open();
using (SqlCommand comm = new SqlCommand(@"
IF OBJECT_ID('tempdb..#Dashboard') IS NOT NULL DROP TABLE #Dashboard ;
IF OBJECT_ID('tempdb..#NPI') IS NOT NULL DROP TABLE #NPI ;
IF OBJECT_ID('tempdb..#ClaimNumbers') IS NOT NULL DROP TABLE #ClaimNumbers;
IF OBJECT_ID('tempdb..#HCFA') IS NOT NULL DROP TABLE #HCFA;
IF OBJECT_ID('tempdb..#EDI') IS NOT NULL DROP TABLE #EDI;
IF OBJECT_ID('tempdb..#DPT') IS NOT NULL DROP TABLE #DPT;
IF OBJECT_ID('tempdb..#EBT') IS NOT NULL DROP TABLE #EBT;
IF OBJECT_ID('tempdb..#temp') IS NOT NULL DROP TABLE #temp
IF OBJECT_ID('tempdb..#t2') IS NOT NULL DROP TABLE #t2
IF OBJECT_ID('tempdb..#claims') IS NOT NULL DROP TABLE #claims
SELECT DISTINCT IDENTITY(int, 1,1) AS Id, NPI INTO #NPI from [dbo].[tblHCFALog];
DECLARE @MaxRow INT;
DECLARE @NextRow INT;
DECLARE @ClaimNum INT;
DECLARE @MaxID INT;
DECLARE @NPI INT;
DECLARE @NPICount INT;
DECLARE @ERA INT;
DECLARE @ProcessDate Smalldatetime;
SET @ProcessDate = cast((getdate() - 90 ) AS Smalldatetime);
set @NPICount = (SELECT max(id) from #NPI );
SET @NextRow = 1;
WHILE (@NextRow < (@NPICount + 1))
BEGIN
IF OBJECT_ID('tempdb..#Dashboard') IS NOT NULL DROP TABLE #Dashboard ;
--IF OBJECT_ID('tempdb..#NPI') IS NOT NULL DROP TABLE #NPI ;
IF OBJECT_ID('tempdb..#ClaimNumbers') IS NOT NULL DROP TABLE #ClaimNumbers;
IF OBJECT_ID('tempdb..#HCFA') IS NOT NULL DROP TABLE #HCFA;
IF OBJECT_ID('tempdb..#EDI') IS NOT NULL DROP TABLE #EDI;
IF OBJECT_ID('tempdb..#DPT') IS NOT NULL DROP TABLE #DPT;
IF OBJECT_ID('tempdb..#EBT') IS NOT NULL DROP TABLE #EBT;
SET @NPI = (SELECT NPI from #NPI WHERE ID = @NextRow);
SELECT IDENTITY(int, 1,1) AS Id,[ClaimNumber] ,[PatientFullName] , [ProviderFullName], [CarrierName], [DateFiled]
,isnull((cast([ChargeAmount1] as float) * [DaysOrUnits1]) , 0 )
+ isnull((cast([ChargeAmount2] as float) * [DaysOrUnits2]) , 0 )
+ isnull((cast([ChargeAmount3] as float) * [DaysOrUnits3]) , 0 )
+ isnull((cast([ChargeAmount4] as float) * [DaysOrUnits4]) , 0 )
+ isnull((cast([ChargeAmount5] as float) * [DaysOrUnits5]) , 0 )
+ isnull((cast([ChargeAmount6] as float) * [DaysOrUnits6]) , 0 ) AS Billed
, NULL As Insurance
, NULL AS Adjustments
, NULL AS PatientPay
,NULL As Balance
,[NPI]
,[TaxIDNumber]
,cast(NULL AS varchar(255)) AS Note
INTO #Dashboard
FROM [dbo].[tblHCFALog]
where cast([DateFiled] As Smalldatetime ) > @ProcessDate
-- now let's figure out the status of each claim by looping through #Dashboard
Alter table #Dashboard add ClaimStatus varchar(255);
Alter table #Dashboard add ClaimStatusDate varchar(255);
Update #Dashboard SET ClaimStatus = 'Initial Scrubbing';
DELETE FROM #Dashboard WHERE id NOT IN (SELECT MAX(id) FROM #Dashboard GROUP BY ClaimNumber);
select [claim_id],[accnt],[phys_id],[payer],[errors]
INTO #HCFA
FROM [FMBStatusMaster].[dbo].[hcfa]
where phys_id = @NPI AND (accnt IN ( select DISTINCT ClaimNumber from #Dashboard));
DELETE FROM #HCFA WHERE [claim_id] NOT IN (SELECT MAX([claim_id]) FROM #HCFA GROUP BY accnt);
MERGE #Dashboard AS Target
USING #HCFA AS S
ON Target.ClaimNumber = S.accnt AND Target.NPI = S.phys_id
WHEN MATCHED AND (Target.ClaimNumber = S.accnt) AND (Target.NPI = S.phys_id)
THEN UPDATE SET
Target.ClaimStatus = S.errors
,Target.CarrierName = S.payer
;
IF OBJECT_ID('tempdb..#HCFA') IS NOT NULL DROP TABLE #HCFA;
select [claim_id],[pat_accnt],[practice_id],[payer],[payer_response],[payer_process_dt] ,[timestamp]
INTO #EDI
FROM [FMBStatusMaster].[dbo].[edi]
where [practice_id] = @NPI AND ([pat_accnt] IN ( select DISTINCT ClaimNumber from #Dashboard));
DELETE FROM #EDI WHERE timestamp NOT IN (SELECT MAX(timestamp) FROM #EDI GROUP BY [pat_accnt]);
MERGE #Dashboard AS Target
USING #EDI AS S
ON Target.ClaimNumber = S.[pat_accnt] AND Target.NPI = S.[practice_id]
WHEN MATCHED
THEN UPDATE SET
Target.ClaimStatus = S.[payer_response]
,Target.CarrierName = S.payer
,Target.ClaimStatusDate = S.[payer_process_dt]
;
IF OBJECT_ID('tempdb..#EDI') IS NOT NULL DROP TABLE #EDI;
------------
select [Payer_Claim_Number],[Patient_Account_Number],[Billing_Provider_ID],[Payer_Name],[Message_Text],[Date_Received] ,[timestamp]
INTO #DPT
FROM [FMBStatusMaster].[dbo].[dpt]
where [Billing_Provider_ID] = @NPI AND ([Patient_Account_Number] IN ( select DISTINCT ClaimNumber from #Dashboard));
DELETE FROM #DPT WHERE timestamp NOT IN (SELECT MAX(timestamp) FROM #DPT GROUP BY [Patient_Account_Number]);
MERGE #Dashboard AS Target
USING #DPT AS S
ON Target.ClaimNumber = S.[Patient_Account_Number] AND Target.NPI = S.[Billing_Provider_ID]
WHEN MATCHED
THEN UPDATE SET
Target.ClaimStatus = S.[Message_Text]
,Target.CarrierName = S.[Payer_Name]
,Target.ClaimStatusDate = S.[Date_Received]
;
IF OBJECT_ID('tempdb..#DPT') IS NOT NULL DROP TABLE #DPT;
---------------------------
select [Patient_Control_Number],[Provider_Billing_ID],[Message_Initiator],[Message],[Date_Received] ,ID
INTO #EBT
FROM [FMBStatusMaster].[dbo].[EBT]
where [Provider_Billing_ID] = @NPI AND ([Patient_Control_Number] IN ( select DISTINCT ClaimNumber from #Dashboard));
DELETE FROM #EBT WHERE id NOT IN (SELECT MAX(id) FROM #EBT GROUP BY [Patient_Control_Number]);
MERGE #Dashboard AS Target
USING #EBT AS S
ON Target.ClaimNumber = S.[Patient_Control_Number] AND Target.NPI = S.[Provider_Billing_ID]
WHEN MATCHED
THEN UPDATE SET
Target.ClaimStatus = S.[Message]
,Target.CarrierName = S.[Message_Initiator]
,Target.ClaimStatusDate = S.[Date_Received]
;
IF OBJECT_ID('tempdb..#EBT') IS NOT NULL DROP TABLE #EBT;
SET @NextRow = @NextRow + 1;
END
SELECT IDENTITY(int, 1,1) AS Id
,[ClaimNumber]
,[PatientFullName]
,[ChargeAmount1],[DaysOrUnits1]
,[ChargeAmount2],[DaysOrUnits2]
,[ChargeAmount3],[DaysOrUnits3]
,[ChargeAmount4],[DaysOrUnits4]
,[ChargeAmount5],[DaysOrUnits5]
,[ChargeAmount6],[DaysOrUnits6]
into #temp
FROM [dbo].[tblHCFALog]
where ClaimNumber IN (SELECT ClaimNumber from #DashBoard);
Set @MaxRow = (select max(ID) from #temp);
Set @NextRow = 1;
while (@NextRow < @MaxRow + 1)
Begin
set @ClaimNum = (select claimnumber from #temp where ID = @NextRow);
set @MaxID = (select max(id) from #temp where claimnumber = @ClaimNum);
delete from #temp where claimnumber = @ClaimNum AND ID <> @MaxID
set @NextRow = @NextRow + 1
END
alter table #temp add Charges AS (isnull([ChargeAmount1],0)
+ isnull([ChargeAmount2],0)
+ isnull([ChargeAmount4],0)
+ isnull([ChargeAmount5],0)
+ isnull([ChargeAmount6],0)
);
alter table #temp add
ManagedCare float
, PatientCheck float
, PatientCreditCard float
, PatientCash float
, PrimaryIns float
, Balance float
;
DECLARE @Amount float;
DECLARE @ManagedCare float;
DECLARE @PatientCheck float;
DECLARE @PatientCreditCard float;
DECLARE @PatientCash float;
DECLARE @PrimaryIns float;
DECLARE @Balance float;
Set @MaxRow = (select max(ID) from #temp);
Set @NextRow = 1;
while (@NextRow < @MaxRow + 1 )
Begin
set @ClaimNum = (select Claimnumber from #temp where ID = @NextRow);
set @Amount = (select isnull(sum(amount),0) from [dbo].[tblTransactions] where claimnumber = @ClaimNum AND TransactionType = 1)
set @ManagedCare = (select isnull(sum(amount),0) from [dbo].[tblTransactions] where claimnumber = @ClaimNum AND TransactionType = 3)
set @PatientCheck = (select isnull(sum(amount),0) from [dbo].[tblTransactions] where claimnumber = @ClaimNum AND TransactionType = 5)
set @PatientCreditCard = (select isnull(sum(amount),0) from [dbo].[tblTransactions] where claimnumber = @ClaimNum AND TransactionType = 6)
set @PatientCash = (select isnull(sum(amount),0) from [dbo].[tblTransactions] where claimnumber = @ClaimNum AND TransactionType = 7)
set @PrimaryIns = (select isnull(sum(amount),0) from [dbo].[tblTransactions] where claimnumber = @ClaimNum AND TransactionType = 9)
set @Balance = (
@Amount
- @ManagedCare
- @PatientCheck
- @PatientCreditCard
- @PatientCash
- @PrimaryIns);
update #temp set
ManagedCare = @ManagedCare
, PatientCheck = @PatientCheck
, PatientCreditCard = @PatientCreditCard
, PatientCash = @PatientCash
, PrimaryIns = @PrimaryIns
, Balance = @Balance
where ID = @NextRow
;
UPDATE #DashBoard
SET Billed = (SELECT Charges from #temp where ClaimNumber = @ClaimNum)
,Insurance = (SELECT PrimaryIns from #temp where ClaimNumber = @ClaimNum)
,Adjustments = (SELECT ManagedCare from #temp where ClaimNumber = @ClaimNum)
,PatientPay = (SELECT (PatientCheck + PatientCreditCard + PatientCash) from #temp where ClaimNumber = @ClaimNum)
,Balance = (SELECT Balance from #temp where ClaimNumber = @ClaimNum)
WHERE ClaimNumber = @ClaimNum;
update #DashBoard set Note = case when (SELECT count(account) FROM [FMBStatusMaster].dbo.checkdata WHERE npi in (select NPI from #NPI) AND account = @ClaimNum) = 1 then 'ERA' ELSE '' END
WHERE ClaimNumber = @ClaimNum;
set @NextRow = @NextRow + 1;
end
SELECT * INTO #filter FROM #Dashboard
WHERE ClaimNumber LIKE '%'+@Criteria+'%'
OR PatientFullName LIKE '%'+@Criteria+'%'
OR ProviderFullName LIKE '%'+@Criteria+'%'
OR CarrierName LIKE '%'+@Criteria+'%'
OR DateFiled LIKE '%'+@Criteria+'%'
OR ClaimStatus LIKE '%'+@Criteria+'%'
OR Billed LIKE '%'+@Criteria+'%'
OR Insurance LIKE '%'+@Criteria+'%'
OR Adjustments LIKE '%'+@Criteria+'%'
OR PatientPay LIKE '%'+@Criteria+'%'
OR Balance LIKE '%'+@Criteria+'%'
OR @Criteria IS NULL
SELECT TOP ( @PAGE_SIZE) * FROM (
select row_number() OVER (ORDER BY CLAIMNUMBER) RN,claimnumber,Patientfullname,providerfullname, Carriername,Datefiled, ClaimStatus,Billed,Insurance,Adjustments,PatientPay,Balance
, Note,NULL AS Action
from #filter
) AS SUB
WHERE RN > (@PAGE_SIZE * @PAGE_INDEX)
", conn))
{
comm.CommandTimeout = 0;
comm.Parameters.AddWithValue("@PAGE_SIZE", setting.PageSize);
comm.Parameters.AddWithValue("@PAGE_INDEX", setting.PageIndex);
comm.Parameters.AddWithValue("@Criteria", setting.SearchCriteria);
var reader = comm.ExecuteReader();
object[] o = new object[reader.FieldCount];
while (reader.Read())
{
reader.GetValues(o);
res.Add(new DashboardResult()
{
claimnumber = int.Parse(o[0].ToString()),
Patientfullname = (o[1].ToString()),
providerfullname = o[2].ToString(),
Carriername = o[3].ToString(),
Datefiled = DateTime.Parse(o[4].ToString()),
ClaimStatus = (o[5].ToString()),
Billed = float.Parse(o[6].ToString()),
Insurance = int.Parse(o[7].ToString()),
Adjustments = int.Parse(o[8].ToString()),
PatientPay = int.Parse(o[9].ToString()),
Balance = int.Parse(o[10].ToString()),
Note = (o[11].ToString()),
Action = 0
});
}
conn.Close();
}
}
return(res);
}
public DataBase(DataSetting.DataSettingItem DataBaseItem)
{
_db = Runtime.DataProvideLibrary.Get(DataBaseItem.DataProvider);
_db.Init(DataBaseItem);
}
/// <summary>
/// 完成
/// </summary>
public void DoDone()
{
DataSetting.Save();
this.DialogResult = DialogResult.OK;
this.Close();
}
private void SaveRecord(DataSetting setting, string[] pks, object jsonResult, string checkedRecordSql)
{
var dao = Dao.Create();
var dictParam = new Dictionary<string, object>();
foreach (var pk in pks) {
dictParam.Add(pk, ((object)jsonResult).GetDynamicValue(pk));
}
//判断是否新增(资质信息)
var isInsert = (setting.Name != "ZzxxInfo") && !dao.Exists(checkedRecordSql, dictParam);
try {
if (isInsert) {
dao.Insert(setting.TableName, (object)jsonResult);
}
else {
//更新
dao.Update(setting.TableName, (object)jsonResult, pks);
}
}
catch (SqlException ex) {
throw ex;
}
catch (Exception ex) {
throw ex;
}
}
public void LoadDataConfig(string xmlfile)
{
_data_list.Clear();
try
{
XDocument document = XDocument.Load(xmlfile);
XElement root = document.Root;
Dictionary <string, DataSetting> classlist = new Dictionary <string, DataSetting>();
IEnumerable <XElement> enumerable = root.Elements();
foreach (XElement item in enumerable)
{
var classname = ReadXmlData(item, "Id");
var data_name = ReadXmlData(item, "Name");
var datatext = ReadXmlData(item, "Element");
var containclass = ReadXmlData(item, "ContainClass");
if (datatext != "" && classname != "Player")
{
DataSetting datastting = null;
FindDataSetting(ref classlist, classname, out datastting);
datastting._text = datatext;
datastting.AddDataValue(datatext, data_name, "0", containclass);
}
}
//
foreach (XElement item in enumerable)
{
var classname = ReadXmlData(item, "Id");
var data_name = ReadXmlData(item, "Name");
var datatext = ReadXmlData(item, "Element");
if (datatext != "" && classname == "Player")
{
DataSetting datasetting = new DataSetting();
datasetting._name = data_name;
datasetting._text = datatext;
{
DataSetting childstting = null;
var containclass = ReadXmlData(item, "ContainClass");
if (containclass != "")
{
datasetting._isobject = true;
FindDataSetting(ref classlist, containclass, out childstting);
foreach (DataValue datavalue in childstting._child_list)
{
DataSetting substting = null;
FindDataSetting(ref classlist, datavalue._contain, out substting);
if (substting._text == null || substting._text == "")
{
if (datavalue._contain != "")
{
datavalue._value = "";
}
datasetting._child_list.Add(datavalue);
}
else
{
foreach (DataValue subvalue in substting._child_list)
{
var addvalue = new DataValue();
addvalue._text = datavalue._text + "-" + subvalue._text;
addvalue._name = datavalue._name + "-" + subvalue._name;
addvalue._value = "0";
datasetting._child_list.Add(addvalue);
}
}
}
}
else
{
datasetting._isobject = false;
datasetting.AddDataValue(datatext, data_name, "0", containclass);
}
}
_data_list.Add(datatext, datasetting);
}
}
}
catch (Exception ex)
{
}
}
