public header GetGlyphHeader(uint iGlyph, OTFont fontOwner)
{
if (iGlyph >= fontOwner.GetMaxpNumGlyphs())
{
throw new ArgumentOutOfRangeException("iGlyph");
}
header h = null;
Table_loca locaTable = (Table_loca)fontOwner.GetTable("loca");
if (locaTable != null)
{
int offsGlyph, length;
if (locaTable.GetEntryGlyf((int)iGlyph,
out offsGlyph, out length, fontOwner))
{
if (length != 0)
{
h = new header((uint)offsGlyph, m_bufTable);
}
}
}
return(h);
}
public static header FindHeader(string id)
{
string sql;
OleDbConnection conn = new OleDbConnection(db.constring());
sql = string.Format("select * from po_headers_all where po_header_id={0}", id);
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader dr = command.ExecuteReader();
if (dr.Read() == false)
{
dr.Close();
conn.Close();
return(null);
}
else
{
header head = new header();
head.header_id = id;
head.number = dr[1].ToString();
head.type = dr[2].ToString();
head.vender_code = dr[3].ToString();
head.status = dr[4].ToString();
dr.Close();
conn.Close();
return(head);
}
}
public void Dispose()
{
p_Filename = null;
p_Directories = null;
p_Files = null;
p_Header = null;
p_ProjectName = null;
}
public fileWriter(ref header header = default, io.Writer zipw = default, ref ptr <countWriter> rawCount = default, io.WriteCloser comp = default, ref ptr <countWriter> compCount = default, hash.Hash32 crc32 = default, bool closed = default)
{
this.m_headerRef = new ptr <header>(ref header);
this.zipw = zipw;
this.rawCount = rawCount;
this.comp = comp;
this.compCount = compCount;
this.crc32 = crc32;
this.closed = closed;
}
public Parser(slice <byte> msg = default, header header = default, section section = default, long off = default, long index = default, bool resHeaderValid = default, ResourceHeader resHeader = default)
{
this.msg = msg;
this.header = header;
this.section = section;
this.off = off;
this.index = index;
this.resHeaderValid = resHeaderValid;
this.resHeader = resHeader;
}
/// <summary>
/// Builds the standard message header
/// </summary>
private static header BuildHeader(string version)
{
var header = new header();
header.version = new version {
Text = version
};
return(header);
}
public override void LoadContent()
{
pixel = game.Content.Load <Texture2D>("pixel");
font = game.Content.Load <SpriteFont>("font");
buttonpane = new buttonpane(pixel, font, game);
header = new header(game, pixel, font, "about");
base.LoadContent();
}
public initMsg(List <GameObject> obs)
{
header = new header();
header.build("INIT", "initializing world", 0);
objects = new List <obj>();
for (int i = 0; i < obs.Count; i++)
{
objects.Add(new obj(obs[i], i));
}
}
static public glyph_composite GetCompositeGlyphLogicalData(header h)
{
glyph_composite gc = null;
CompositeGlyph cg = h.GetCompositeGlyph();
if (cg != null)
{
// glyph is a composite glyph
gc = new glyph_composite(h.xMin, h.yMin, h.xMax, h.yMax);
// copy any hinting instructions
if (cg.AnyComponentsHaveInstructions())
{
ushort nInstructions = cg.GetNumInstructions();
gc.m_arrInstructions = new byte[nInstructions];
for (uint i = 0; i < nInstructions; i++)
{
gc.m_arrInstructions[i] = cg.GetInstruction(i);
}
}
while (cg != null)
{
glyph_composite.component cc = new glyph_composite.component();
cc.flags = cg.flags;
cc.glyphid = cg.glyphIndex;
cc.arg1 = cg.arg1;
cc.arg2 = cg.arg2;
if ((cg.flags & (ushort)CompositeGlyph.Flags.WE_HAVE_A_SCALE) != 0)
{
cc.scale = cg.scale;
}
else if ((cg.flags & (ushort)CompositeGlyph.Flags.WE_HAVE_AN_X_AND_Y_SCALE) != 0)
{
cc.xscale = cg.xscale;
cc.yscale = cg.yscale;
}
else if ((cg.flags & (ushort)CompositeGlyph.Flags.WE_HAVE_A_TWO_BY_TWO) != 0)
{
cc.xscale_2x2 = cg.xscale_2x2;
cc.scale01_2x2 = cg.scale01_2x2;
cc.scale10_2x2 = cg.scale10_2x2;
cc.yscale_2x2 = cg.yscale_2x2;
}
gc.m_arrComponents.Add(cc);
cg = cg.GetNextCompositeGlyph();
}
}
return(gc);
}
private void getNext()
{
//Debug.Log("getting next");
header next = new header();
next.build("NEXT", "Getting the next command", sent);
string msg = "JSON{\"header\":" + JsonUtility.ToJson(next) + ",\"body\":{}}";
w.SendString(msg);
waiting = 0;
}
private void stop()
{
header stopper = new header();
stopper.build("STOP", "Stopping the server", sent);
string msg = "JSON{\"header\":" + JsonUtility.ToJson(stopper) + ",\"body\":{}}";
//Debug.Log(msg);
w.SendString(msg);
done = true;
}
public static void UpdateHeader(header head)
{
string sql;
OleDbConnection conn = new OleDbConnection(db.constring());
sql = string.Format("update po_headers_all set po_number='" + head.number + "',po_type='" + head.type + "',vender_code='" + head.vender_code + "',status='" + head.status + "' where po_header_id= '" + head.header_id + "'");
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
public static void InsertHeader(header head)
{
string sql;
OleDbConnection conn = new OleDbConnection(db.constring());
sql = string.Format("insert into po_headers_all(po_number,po_type,vender_code,status)values('" + head.number + "','" + head.type + "','" + head.vender_code + "','" + head.status + "')");
OleDbCommand command = new OleDbCommand(sql, conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
/* TAH Procedures*/
public void extract_TAH_directory()
{
Entries = null;
UInt32 arc_size = (UInt32)reader.BaseStream.Length;
header tah_header = new header();
byte[] magic = reader.ReadBytes(4);
if (magic[0] != (byte)'T' || magic[1] != (byte)'A' || magic[2] != (byte)'H' || magic[3] != (byte)'2')
{
throw new Exception("File is not TAH");
}
tah_header.index_entry_count = reader.ReadUInt32();
tah_header.version = reader.ReadUInt32();
tah_header.reserved = reader.ReadUInt32();
UInt32 index_buffer_size = tah_header.index_entry_count * 8; //sizeof(index_entry) == 8
Entries = new TAHEntry[tah_header.index_entry_count];
for (int i = 0; i < tah_header.index_entry_count; i++)
{
Entries[i] = new TAHEntry();
Entries[i].hash_name = reader.ReadUInt32();
Entries[i].offset = reader.ReadUInt32();
}
UInt32 output_length = reader.ReadUInt32();
//entry情報の読み出し長さ
UInt32 input_length = Entries[0].offset - /*sizeof(header)*/ 16 - index_buffer_size;
//entry情報の読み出しバッファ
byte[] data_input = new byte[input_length];
data_input = reader.ReadBytes((int)input_length);
//-- entry情報の読み込み完了! --
byte[] output_data = new byte[output_length];
TAHCryption.crypt(ref data_input, input_length, output_length);
Decompression.infrate(ref data_input, input_length, ref output_data, output_length);
//-- entry情報の復号完了! --
build_TAHEntries(output_data, arc_size);
}
protected void btnheadupdatepost_Click(object sender, EventArgs e)
{
string mess;
header head = new header();
head.header_id = txbheadid.Text;
head.number = txbnumber.Text;
head.type = txbtype.Text;
head.vender_code = txbvendercode.Text;
head.status = txbstatus.Text;
if (txbnumber.Text == "" || txbtype.Text == "" || txbvendercode.Text == "" || txbstatus.Text == "")
{
mess = "请把信息填写完整！！！";
Response.Write(message.goBack(mess));
}
else
{
try
{
int.Parse(txbnumber.Text);
int.Parse(txbvendercode.Text);
if (header.FindUpVender(txbvendercode.Text) == false)
{
mess = "找不到该编号的供应商！！！";
Response.Write(message.goBack(mess));
}
else
{
if (txbstatus.Text == "1" || txbstatus.Text == "2" || txbstatus.Text == "3" || txbstatus.Text == "4")
{
header.UpdateHeader(head);
mess = "订单头修改成功！！！";
string url = "require.aspx";
Response.Write(message.MessageAndUrl(mess, url));
}
else
{
mess = "状态栏只能填1-4之间的值！！";
Response.Write(message.goBack(mess));
}
}
}
catch
{
mess = "供应商号和订单编号只能填写数字！！！";
Response.Write(message.goBack(mess));
}
}
}
static public glyph_simple GetSimpleGlyphLogicalData(header h)
{
glyph_simple gs = null;
SimpleGlyph sg = h.GetSimpleGlyph();
if (sg != null)
{
// glyph is a simple glyph
gs = new glyph_simple(h.numberOfContours, h.xMin, h.yMin, h.xMax, h.yMax);
SimpleGlyph.Coordinate[] coords = sg.GetDecodedRelativeCoordinates();
glyph_simple.Coordinate16 prevPoint;
prevPoint.x = prevPoint.y = 0;
glyph_simple.Coordinate16 newPoint;
for (uint iContour = 0; iContour < h.numberOfContours; iContour++)
{
// convert the coordinates in this contour from relative to absolute
uint startCoord = 0;
if (iContour > 0)
{
startCoord = (uint)sg.GetEndPtOfContour(iContour - 1) + 1;
}
uint endCoord = sg.GetEndPtOfContour(iContour);
int nPoints = (int)(endCoord - startCoord + 1);
glyph_simple.contour Contour = new glyph_simple.contour(nPoints);
for (uint iCoord = startCoord; iCoord <= endCoord; iCoord++)
{
newPoint.x = (short)(prevPoint.x + coords[iCoord].x);
newPoint.y = (short)(prevPoint.y + coords[iCoord].y);
newPoint.bOnCurve = coords[iCoord].bOnCurve;
Contour.m_arrPoints.Add(newPoint);
prevPoint = newPoint;
}
gs.m_arrContours.Add(Contour);
// copy the hinting instructions
gs.m_arrInstructions = new byte[sg.instructionLength];
for (uint i = 0; i < sg.instructionLength; i++)
{
gs.m_arrInstructions[i] = sg.GetInstruction(i);
}
}
}
return(gs);
}
public static List <header> GetHeaders()
{
List <header> list = new List <header>();
//header header1 = new header { code = "vehicle_id", title = "Код типа автомобиля" };
//list.Add(header1);
header header2 = new header {
code = "model_name", title = "Модель автомобиля"
};
list.Add(header2);
header header3 = new header {
code = "xcardrs", title = "Кол-во дверей"
};
list.Add(header3);
header header4 = new header {
code = "dmodyr", title = "Год выпуска"
};
list.Add(header4);
header header5 = new header {
code = "xgradefulnam", title = "Класс"
};
list.Add(header5);
header header6 = new header {
code = "ctrsmtyp", title = "Тип трансмиссии"
};
list.Add(header6);
header header7 = new header {
code = "cmftrepc", title = "Страна производитель"
};
list.Add(header7);
header header8 = new header {
code = "carea", title = "Страна рынок"
};
list.Add(header8);
header header9 = new header {
code = "nengnpf", title = "Код двигателя"
};
list.Add(header9);
return(list);
}
public static object EmsService(object value)
{
if (value is HateEmsData)
{
var data = (HateEmsData)value;
if (!string.IsNullOrEmpty(data.MesWebProxy))
{
var proxy = new WebProxy(data.MesWebProxy, true);
//var proxy = new WebProxy(data.MesWebProxy, data.MesWebProxyPort);
WebRequest.DefaultWebProxy = proxy;
}
HateEmsGetDataService.HateEmsGetDataService Ems = new HateEmsGetDataServiceClient();
var header = new header {
props = new headerEntry[3]
};
header.props[0] = new headerEntry {
key = "username", value = data.UserName + "@" + data.Factory
};
header.props[1] = new headerEntry {
key = "factory", value = data.Factory
};
header.props[2] = new headerEntry {
key = "procstep", value = data.ProcStep
};
var ServiceIn = new hateEmsGetDataServiceIn();
ServiceIn.language = data.Language;
ServiceIn.service = data.Service;
ServiceIn.barcode = data.Barcode;
ServiceIn.operation = data.Operation;
ServiceIn.barcodeType = data.BarcodeType;
ServiceIn.result = data.Result;
var DataService = new emsGetDataService()
{
@in = ServiceIn
};
var Request = new emsGetDataService1(header, DataService);
var Response = Ems.emsGetDataService(Request);
var ServiceOut = Response.@out;
return(ServiceOut);
}
return(null);
}
public List <soundFile> GetWEMFileList()
{
_header = new header();
folderHashTable = new Hashtable();
soundBankList.Clear();
List <soundFile> Temp = new List <soundFile>();
BinaryReader br2 = new BinaryReader(File.Open(_packPath, FileMode.Open, FileAccess.Read, FileShare.Read));
if (ParseHeader(br2))
{
GetFolders(br2);
GatherSoundBanks(br2);
Temp = GetSoundFiles(br2);
}
br2.Close();
return(Temp);
}
public static header buildHeader(string pAuthor, string pCategory, string pComment, string pDate, string pDescription,
string pEmail, string pHomepage, string pName, string pUrl, string pVersion)
{
header datHeader = new header();
datHeader.author = pAuthor;
datHeader.category = pCategory;
datHeader.comment = pComment;
datHeader.date = pDate;
datHeader.description = pDescription;
datHeader.email = pEmail;
datHeader.homepage = pHomepage;
datHeader.name = pName;
datHeader.url = pUrl;
datHeader.version = pVersion;
return(datHeader);
}
public Project(string filename)
{
p_Filename = filename;
//perform restore (if needed)
Helpers.Restore(filename);
//open the file
FileStream fileStream = new FileStream(filename, FileMode.Open);
//read the header
p_Header = new header();
p_Header.load(fileStream, this);
//read the project name
p_ProjectName = Helpers.ReadString255(fileStream);
//read the build directory
p_BuildDirectory = Helpers.ReadString(fileStream);
//read the directories
int directoryLength = Helpers.DecodeInt32(fileStream);
p_Directories = new ProjectEntity[directoryLength];
for (int c = 0; c < directoryLength; c++)
{
p_Directories[c] = new ProjectDirectory(null, this);
p_Directories[c].Load(fileStream);
}
//read the files
int fileLength = Helpers.DecodeInt32(fileStream);
p_Files = new ProjectEntity[fileLength];
for (int c = 0; c < fileLength; c++)
{
p_Files[c] = new ProjectFile(null, this);
p_Files[c].Load(fileStream);
}
//clean up
fileStream.Close();
}
public static List <header> GetHeaders()
{
List <header> list = new List <header>();
header header1 = new header {
fid = "pos", title = "ИД"
};
list.Add(header1);
header header2 = new header {
fid = "model", title = "Модель"
};
list.Add(header2);
header header3 = new header {
fid = "body", title = "Кузов"
};
list.Add(header3);
header header4 = new header {
fid = "modification", title = "Модификация"
};
list.Add(header4);
header header5 = new header {
fid = "transmission", title = "Трансмиссия"
};
list.Add(header5);
header header6 = new header {
fid = "door", title = "Двери"
};
list.Add(header6);
header header7 = new header {
fid = "engine", title = "Двигатель"
};
list.Add(header7);
return(list);
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
txbheadid.Text = GridView1.SelectedDataKey.Values[0].ToString();
header head = new header();
head = header.FindHeader(txbheadid.Text);
if (head == null)
{
string mess = "选择数据出错！！";
string url = "require.aspx";
Response.Write(message.MessageAndUrl(mess, url));
}
else
{
txbnumber.Text = head.number;
txbtype.Text = head.type;
txbvendercode.Text = head.vender_code;
txbstatus.Text = head.status;
}
}
public static List <header> GetBrand()
{
var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json");
IConfiguration Configuration = builder.Build();
List <header> list = new List <header>();
header toyota = new header();
toyota.code = Configuration.GetSection("brand").GetSection("toyota").GetSection("brand_id").Value;
toyota.title = Configuration.GetSection("brand").GetSection("toyota").GetSection("brand_name").Value;
list.Add(toyota);
header Lexus = new header();
Lexus.code = Configuration.GetSection("brand").GetSection("Lexus").GetSection("brand_id").Value;
Lexus.title = Configuration.GetSection("brand").GetSection("Lexus").GetSection("brand_name").Value;
list.Add(Lexus);
return(list);
}
// constructor
public glyf_cache(Table_glyf OwnerTable, OTFont OwnerFont)
{
m_arrGlyphs = new ArrayList();
// get each glyph from the glyf table
for (uint iGlyph = 0; iGlyph < OwnerFont.GetMaxpNumGlyphs(); iGlyph++)
{
header h = OwnerTable.GetGlyphHeader(iGlyph, OwnerFont);
if (h == null)
{
m_arrGlyphs.Add(null);
}
else
{
glyph_base gb = GetGlyphLogicalData(h);
m_arrGlyphs.Add(gb);
}
}
}
protected void btnheadaddpost_Click(object sender, EventArgs e)
{
string mess;
header head = new header();
head.number = txbnumber.Text;
head.type = txbtype.Text;
head.vender_code = txbvendercode.Text;
head.status = txbstatus.Text;
if (txbnumber.Text == "" || txbtype.Text == "" || txbvendercode.Text == "" || txbstatus.Text == "")
{
mess = "请把信息填写完整！！！";
Response.Write(message.goBack(mess));
}
else
{
try
{
int.Parse(txbnumber.Text);
int.Parse(txbvendercode.Text);
if (header.FindUpVender(txbvendercode.Text) == false)
{
mess = "找不到该编号的供应商！！！";
Response.Write(message.goBack(mess));
}
else
{
header.InsertHeader(head);
mess = "订单头添加成功！！！";
string url = "order.aspx";
Response.Write(message.MessageAndUrl(mess, url));
}
}
catch
{
mess = "供应商号和订单编号只能填写数字！！！";
Response.Write(message.goBack(mess));
}
}
}
public Project(string filename)
{
p_Filename = filename;
//perform restore (if needed)
Helpers.Restore(filename);
//open the file
FileStream fileStream = new FileStream(filename, FileMode.Open);
//read the header
p_Header = new header();
p_Header.load(fileStream, this);
//read the project name
p_ProjectName = Helpers.ReadString255(fileStream);
//read the build directory
p_BuildDirectory = Helpers.ReadString(fileStream);
//read the directories
int directoryLength = Helpers.DecodeInt32(fileStream);
p_Directories = new ProjectEntity[directoryLength];
for (int c = 0; c < directoryLength; c++) {
p_Directories[c] = new ProjectDirectory(null, this);
p_Directories[c].Load(fileStream);
}
//read the files
int fileLength = Helpers.DecodeInt32(fileStream);
p_Files = new ProjectEntity[fileLength];
for (int c = 0; c < fileLength; c++) {
p_Files[c] = new ProjectFile(null, this);
p_Files[c].Load(fileStream);
}
//clean up
fileStream.Close();
}
InitSequential(header, databaseBinary, options, maxDegreeOfParallelism);
foreach (var(header, value) in headers)
var(header, result) = convertResponse(response);
public TRT_ChargeCodes(int count)
{
// TODO: Add constructor logic here
TRT_header = new header();
TRT_child = new ChargeCode[count];
}
public TRT_ChargeCodes()
{
// TODO: Add constructor logic here
TRT_header = new header();
}
static public glyph_simple GetSimpleGlyphLogicalData(header h)
{
glyph_simple gs = null;
SimpleGlyph sg = h.GetSimpleGlyph();
if (sg != null)
{
// glyph is a simple glyph
gs = new glyph_simple(h.numberOfContours, h.xMin, h.yMin, h.xMax, h.yMax);
SimpleGlyph.Coordinate[] coords = sg.GetDecodedRelativeCoordinates();
glyph_simple.Coordinate16 prevPoint;
prevPoint.x = prevPoint.y = 0;
glyph_simple.Coordinate16 newPoint;
for (uint iContour=0; iContour<h.numberOfContours; iContour++)
{
// convert the coordinates in this contour from relative to absolute
uint startCoord = 0;
if (iContour > 0)
{
startCoord = (uint)sg.GetEndPtOfContour(iContour-1)+1;
}
uint endCoord = sg.GetEndPtOfContour(iContour);
int nPoints = (int)(endCoord - startCoord + 1);
glyph_simple.contour Contour = new glyph_simple.contour(nPoints);
for (uint iCoord = startCoord; iCoord <= endCoord; iCoord++)
{
newPoint.x = (short)(prevPoint.x + coords[iCoord].x);
newPoint.y = (short)(prevPoint.y + coords[iCoord].y);
newPoint.bOnCurve = coords[iCoord].bOnCurve;
Contour.m_arrPoints.Add(newPoint);
prevPoint = newPoint;
}
gs.m_arrContours.Add(Contour);
// copy the hinting instructions
gs.m_arrInstructions = new byte[sg.instructionLength];
for (uint i=0; i<sg.instructionLength; i++)
{
gs.m_arrInstructions[i] = sg.GetInstruction(i);
}
}
}
return gs;
}
public header GetGlyphHeader(uint iGlyph, OTFont fontOwner)
{
if (iGlyph >= fontOwner.GetMaxpNumGlyphs())
{
throw new ArgumentOutOfRangeException("iGlyph");
}
header h = null;
Table_loca locaTable = (Table_loca)fontOwner.GetTable("loca");
if (locaTable != null)
{
int offsGlyph, length;
if (locaTable.GetEntryGlyf((int)iGlyph,
out offsGlyph, out length, fontOwner))
{
if (length!=0)
{
h = new header((uint)offsGlyph, m_bufTable);
}
}
}
return h;
}
public CompositeGlyph(header h, uint offset, MBOBuffer bufTable)
{
m_header = h;
m_offsetCompositeGlyph = offset;
m_bufTable = bufTable;
}
public SimpleGlyph(header h, uint offset, MBOBuffer bufTable)
{
m_header = h;
m_offsetSimpleGlyph = offset;
m_bufTable = bufTable;
}
public void Dispose()
{
p_Filename = null;
p_Directories = null;
p_Files = null;
p_Header = null;
p_ProjectName = null;
}
private static AddDataRequestMsg PrepMessage(MessageCorrelator message)
{
Logger.debug(DateTime.Now.ToString("o") + " Prepmessage enter " + message.MessageID);
MessageProcessor i = MessageProcessor.Instance;
Logger.info("SendPerformanceData, Data acquistion successful, sending data to the data collector." + message.URL + " at " + message.RecievedAt + " recording agent " + message.agenttype);
//if (FGSMSConstants.log) log.TraceEvent(TraceEventType.Information, 0, ());
AddDataRequestMsg request = new AddDataRequestMsg();
request = new AddDataRequestMsg();
request.Action = message.soapAction;
if (String.IsNullOrEmpty(message.URL))
{
Logger.warn("FGSMS.MessageProcessor Send Peformance Data, the url on this message is null, skipping");
message = null;
return null;
}
if (message.agenttype.ToLower().Contains(".client"))
message.URL = ModifyURL(message.URL, true);
else message.URL = ModifyURL(message.URL, false);
Logger.debug(
DateTime.Now.ToString("o") + " Prepmessage after url mod " + message.MessageID);
//This double check is required due to adjusted urls do not remove
if (IsOnIgnoreList(message.URL))
{
message = null;
try
{
//if (FGSMSConstants.log) EventLog.WriteEntry("FGSMS.MessageProcessor", "Message ignored due to ignore list " + message.originalUrl + " translated " + message.URL, EventLogEntryType.Information);
}
catch { }
return null;
}
PolicyHelper myPolicy = FetchPolicy(message.URL);
Logger.debug(
DateTime.Now.ToString("o") + " Prepmessage after pol fetch" + message.MessageID);
if (myPolicy == null)
return null;
//record the request
if (!String.IsNullOrEmpty(message.RequestMessage))
if (myPolicy.policy.RecordRequestMessage)
{
request.XmlRequest =
message.RequestMessage;
//truncate the request
if (myPolicy.policy.RecordedMessageCap < request.XmlRequest.Length)
request.XmlRequest = request.XmlRequest.Substring(0, myPolicy.policy.RecordedMessageCap);
}
//record response
if (!String.IsNullOrEmpty(message.ResponseMessage))
if (myPolicy.policy.RecordResponseMessage)
{
request.XmlResponse =
message.ResponseMessage;
//truncate the response
if (myPolicy.policy.RecordedMessageCap < request.XmlResponse.Length)
request.XmlResponse = request.XmlResponse.Substring(0, myPolicy.policy.RecordedMessageCap);
}
request.requestSize = (int)message.requestsize;
request.responseSize = (int)message.responsesize;
if (myPolicy.policy.RecordFaultsOnly && message.IsFault)
{
request.XmlRequest =
message.RequestMessage;
request.XmlResponse =
message.ResponseMessage;
//truncate the request
if (myPolicy.policy.RecordedMessageCap < request.XmlRequest.Length)
request.XmlRequest = request.XmlRequest.Substring(0, myPolicy.policy.RecordedMessageCap);
//truncate the response
if (myPolicy.policy.RecordedMessageCap < request.XmlResponse.Length)
request.XmlResponse = request.XmlResponse.Substring(0, myPolicy.policy.RecordedMessageCap);
}
if (myPolicy.policy.RecordHeaders)
{
if (message.RequestHeaders != null && message.RequestHeaders.Count > 0)
{
List<header> l = new List<header>();
for (int b = 0; b < message.RequestHeaders.AllKeys.Length; b++)
{
header h = new header();
h.name = message.RequestHeaders.AllKeys[b];
h.value = new string[] { message.RequestHeaders[message.RequestHeaders.AllKeys[b]] };
l.Add(h);
}
request.headersRequest = l.ToArray();
l = null;
}
if (message.ResponseHeaders != null && message.ResponseHeaders.Count > 0)
{
List<header> l = new List<header>();
for (int b = 0; b < message.ResponseHeaders.Count; b++)
{
header h = new header();
h.name = message.ResponseHeaders.AllKeys[b];
h.value = new string[] { message.ResponseHeaders[message.ResponseHeaders.AllKeys[b]] };
l.Add(h);
}
request.headersResponse = l.ToArray();
l = null;
}
}
request.Identity = GetUserIdentity(myPolicy.policy.UserIdentification, ref message);
long ticks = message.CompletedAt.Ticks - message.RecievedAt.Ticks;
request.recordedat = message.RecievedAt;
TimeSpan ts = new TimeSpan(ticks);
request.responseTime = (ts.Hours * 60 * 60 * 1000) + (ts.Minutes * 60 * 1000) + (ts.Seconds * 1000) + (ts.Milliseconds);
request.ServiceHost = System.Environment.MachineName.ToLower();
request.Success = !message.IsFault;
request.URI = message.URL;
request.TransactionID = message.MessageID;
request.TransactionThreadID = message.threadid;
request.RelatedTransactionID = message.relatedtransactionid;
request.agentType = message.agenttype;
request.RequestURI = message.originalUrl;
request.Action = message.soapAction;
request.Action = request.Action.Replace("\"", string.Empty);
request.Action = request.Action.Replace("'", string.Empty);
long memused = System.GC.GetTotalMemory(false);
ulong installedMemory = 0;
ulong freememroy = 0;
MEMORYSTATUSEX memStatus = new MEMORYSTATUSEX();
if (GlobalMemoryStatusEx(memStatus))
{
installedMemory = memStatus.ullTotalPhys;
freememroy = memStatus.ullAvailPhys;
}
request.Message += "Agent Outbound queue: " + the_queue.Count + " Outbound Threads " + ThreadPoolSize() + " Thread " + Thread.CurrentThread.Name;
request.Message += " mem stat " + freememroy + "/" + installedMemory;
/*if (String.IsNullOrEmpty(message.RequestMessage))
request.requestSize = 0;
else request.requestSize = message.RequestMessage.Length;
if (String.IsNullOrEmpty(message.ResponseMessage))
request.responseSize = 0;
else request.responseSize = message.ResponseMessage.Length;*/
request.classification = currentlevel;
Logger.debug(
DateTime.Now.ToString("o") + " Prepmessage exit " + message.MessageID);
message = null;
return request;
}
static public glyph_composite GetCompositeGlyphLogicalData(header h)
{
glyph_composite gc = null;
CompositeGlyph cg = h.GetCompositeGlyph();
if (cg != null)
{
// glyph is a composite glyph
gc = new glyph_composite(h.xMin, h.yMin, h.xMax, h.yMax);
// copy any hinting instructions
if (cg.AnyComponentsHaveInstructions())
{
ushort nInstructions = cg.GetNumInstructions();
gc.m_arrInstructions = new byte[nInstructions];
for (uint i=0; i<nInstructions; i++)
{
gc.m_arrInstructions[i] = cg.GetInstruction(i);
}
}
while (cg != null)
{
glyph_composite.component cc = new glyph_composite.component();
cc.flags = cg.flags;
cc.glyphid = cg.glyphIndex;
cc.arg1 = cg.arg1;
cc.arg2 = cg.arg2;
if ((cg.flags & (ushort)CompositeGlyph.Flags.WE_HAVE_A_SCALE) != 0)
{
cc.scale = cg.scale;
}
else if ((cg.flags & (ushort)CompositeGlyph.Flags.WE_HAVE_AN_X_AND_Y_SCALE) != 0)
{
cc.xscale = cg.xscale;
cc.yscale = cg.yscale;
}
else if ((cg.flags & (ushort)CompositeGlyph.Flags.WE_HAVE_A_TWO_BY_TWO) != 0)
{
cc.xscale_2x2 = cg.xscale_2x2;
cc.scale01_2x2 = cg.scale01_2x2;
cc.scale10_2x2 = cg.scale10_2x2;
cc.yscale_2x2 = cg.yscale_2x2;
}
gc.m_arrComponents.Add(cc);
cg = cg.GetNextCompositeGlyph();
}
}
return gc;
}
HeaderMatchesVersion(header, version);
public void run(string pdfFile, string txtFileOutPut, String MembidDummy, String tblSubscribers, String whatIsTable, String tblProvider, String pay_name1_117, System.Windows.Forms.Label lblTotal, System.Windows.Forms.Label lblCount, ToolStripProgressBar Bar, ToolStripStatusLabel Label,System.Windows.Forms.DataGridView dgview,String sCount)
{
//Para MMM y PMC 837i
jolParseDBF.DBF foxCnn = null;
String Images = null;
String sqlCnnString = null;
findData.Search myFindData = null;
DataSet mySqlDataSet = null;
header myHeader = null;
detail myDetail = null;
// createString.create myCreateFile = null;
// writeFile.file myWriteFile = null;
Int32 iCC = 0; //Contador de la categoria
String TMPcc = null;
try
{
myFindData = new findData.Search();
mySqlDataSet = new DataSet();
myHeader = new header();
myDetail = new detail();
StringBuilder sHDOut = new StringBuilder();
string file2 = txtFileOutPut.Substring(0, txtFileOutPut.IndexOf("."));
file2 += ".dtl"; //
if (File.Exists(txtFileOutPut.Trim()))
File.Delete(txtFileOutPut.Trim());
if (File.Exists(file2.Trim()))
File.Delete(file2.Trim());
sqlCnnString = _sqlCnnString;
foxCnn = new jolParseDBF.DBF();
DataTable foxTable = foxCnn.parse(pdfFile); // TODO: New Parse
lblTotal.Text = String.Format("{0:0,0}", foxTable.Select("V1PAGINA <> '99'").Length.ToString()); //String.Format("{0:0,0}", foxCmd.ExecuteScalar());
int totalrecord = foxTable.Select("V1PAGINA <> '99'").Length; //Convert.ToInt16(foxCmd.ExecuteScalar());
Bar.Maximum = totalrecord;
System.Windows.Forms.Application.DoEvents();
string V1SUSCRIID = null;
string V156NPI = null;
String V1FEDTAXNO = null;
string V276NPI = null;
//string V276NPILegaci = null;
string V2OPERANPI = null;
//string V2OPERANPILegaci = null;
string V278NPI = null;
//string V278NPILegaci = null;
string V279NPI = null;
//string V279NPILegaci = null;
bool isNotGoodV276NPI = false;
bool isNotGoodV2OPERANPI = false;
bool isNotGoodV278NPI = false;
bool isNotGoodV279NPI = false;
bool isNotGoodV156NPI = false;
int intClaim_no_2 = 0;
Int64 myCount = 0;
foreach (System.Data.DataRow foxDR in foxTable.Select("V1PAGINA <> '99'", "V0DOCUMENT"))//TODO: Star loop
{
myHeader = null;
myDetail = null;
myHeader = new header();
myDetail = new detail();
Bar.Value++;
Double iP = Bar.Value;
iP = iP / Bar.Maximum;
Label.Text = String.Format("{0:0%}", iP);
Application.DoEvents();
myCount++;
lblCount.Text = String.Format("{0:0,0}", myCount);
System.Windows.Forms.Application.DoEvents();
isNotGoodV276NPI = false;
isNotGoodV2OPERANPI = false;
isNotGoodV278NPI = false;
isNotGoodV279NPI = false;
intClaim_no_2++;
Images = foxDR["V0IFNAME01"].ToString().Trim();
V156NPI = foxDR["V156NPI"].ToString();
V276NPI = foxDR["V276NPI"].ToString();
V2OPERANPI = foxDR["V2OPERANPI"].ToString();
V278NPI = foxDR["V278NPI"].ToString();
V279NPI = foxDR["V279NPI"].ToString();
V1FEDTAXNO = foxDR["V1FEDTAXNO"].ToString();
//TODO V279NPI **
if (V279NPI.Trim().Length == 0)
{
V279NPI = new String(' ', 10);
isNotGoodV279NPI = true;
}
else
{
if (!check_digit_NPI.isValidNPI(V279NPI.Trim()))
{
V279NPI = new String(' ', 10);
isNotGoodV279NPI = true;
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select count(*) from " + tblProvider + " where (npi ='" + V279NPI + "') or (PAYEE_NPI ='" + V279NPI + "')");
if (count == "0")
{
V279NPI = "9999999995";
isNotGoodV279NPI = true;
}
else
{
isNotGoodV279NPI = false;
}
}
}
//TODO V278NPI **
if (V278NPI.Trim().Length == 0)
{
V278NPI = new string(' ', 10);
isNotGoodV278NPI = true;
}
else
{
if (!check_digit_NPI.isValidNPI(V278NPI.Trim()))
{
V278NPI = new string(' ', 10);
isNotGoodV278NPI = true;
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select count(*) from " + tblProvider + " where (npi ='" + V278NPI + "') or (PAYEE_NPI ='" + V278NPI + "')");
if (count == "0")
{
V278NPI = "9999999995";
isNotGoodV278NPI = true;
}
else
{
isNotGoodV278NPI = false;
}
}
}
//TODO V2OPERANPI **
if (V2OPERANPI.Trim().Length == 0)
{
V2OPERANPI = new string(' ', 10);
isNotGoodV2OPERANPI = true;
}
else
{
if (!check_digit_NPI.isValidNPI(V2OPERANPI.Trim()))
{
V2OPERANPI = new string(' ', 10);
isNotGoodV2OPERANPI = true;
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select count(*) from " + tblProvider + " where (npi ='" + V2OPERANPI + "') or (PAYEE_NPI ='" + V2OPERANPI + "')");
if (count == "0")
{
V2OPERANPI = "9999999995";
isNotGoodV2OPERANPI = true;
}
else
{
isNotGoodV2OPERANPI = false;
}
}
}
//TODO V276NPI **
if (V276NPI.Trim().Length == 0)
{
V276NPI = new string(' ', 10);
isNotGoodV276NPI = true;
}
else
{
if (!check_digit_NPI.isValidNPI(V276NPI.Trim()))
{
V276NPI = new string(' ', 10);
isNotGoodV276NPI = true;
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select count(*) from " + tblProvider + " where (npi ='" + V276NPI + "') or (PAYEE_NPI ='" + V276NPI + "')");
if (count == "0")
{
V276NPI = "9999999995";
isNotGoodV276NPI = true;
}
else
{
isNotGoodV276NPI = false;
}
}
}
//TODO V156NPI
if (V156NPI.Trim().Length == 0)
{
V156NPI = "9999999995";
}
else
{
if (!check_digit_NPI.isValidNPI(V156NPI.Trim()))
{
V156NPI = "9999999995";
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select count(*) from " + tblProvider + " where (npi ='" + V156NPI + "')");
if (count == "0")
{
V156NPI = "9999999995";
isNotGoodV156NPI = true;
}
else
{
isNotGoodV156NPI = false;
}
}
}
V1SUSCRIID = foxDR["V1SUSCRIID"].ToString().Trim();
if (V1SUSCRIID.Trim().Length == 0)
{
V1SUSCRIID = MembidDummy;
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select membid from " +
tblSubscribers + " where (membid = '" + V1SUSCRIID + "')");
if (count.Trim().Length == 0)
{//or (membid2 = '" + V1SUSCRIID + "')"
string count2 = Program.MySqlbusqueda(sqlCnnString, "select membid from " +
tblSubscribers + " where (membid2 = '" + V1SUSCRIID + "')");
if (count2.Trim().Length == 0)
{
V1SUSCRIID = MembidDummy;
}
else
{
V1SUSCRIID = count2;
}
}
else
{
V1SUSCRIID = count;
}
}
if (V1FEDTAXNO.Trim().Length == 0)
{
V1FEDTAXNO = "999999999";
}
else
{
string count = Program.MySqlbusqueda(sqlCnnString, "select count(*) from " + tblProvider + " where vendor ='" + V1FEDTAXNO + "'");
if (count == "0")
{
V1FEDTAXNO = "999999999";
}
}
//TODO: /////////////////////////// header //////////////
myHeader.uniquekey_1= (new string(' ', 60));
myHeader.claim_no_2 = ( intClaim_no_2.ToString("00000000000000#"));
{// Nota nopuede estar en blanco
myHeader.prov_name_3 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LASTNAME],1,CHARINDEX (' ',[LASTNAME],1)) AS LASTNAME from " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
if(myHeader.prov_name_3.ToString().Trim().Length == 0 )
{
myHeader.prov_name_3 = (Program.MySqlbusqueda(sqlCnnString, "select LASTNAME from " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
}
myHeader.prov_addrs_4 = (Program.MySqlbusqueda(sqlCnnString, "select rtrim(ltrim(STREET)) as Add1 from " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
if (myHeader.prov_addrs_4.ToString().Trim().Length == 0 )
{
myHeader.prov_addrs_4 = ("Dummy");
}
if(myHeader.prov_addrs_4.ToString().Trim().ToUpper().Contains("BOX"))
{
myHeader.prov_addrs_4 = ("Dummy");
}
myHeader.prov_csz_5 = (Program.MySqlbusqueda(sqlCnnString, "select rtrim(lTRIM(City)) from " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
myHeader.prov_state_5 = (Program.MySqlbusqueda(sqlCnnString, "select rtrim(lTRIM(State)) From " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
myHeader.prov_zipcode_5 = (Program.MySqlbusqueda(sqlCnnString, "select rtrim(lTRIM(Zip)) from " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
if (myHeader.prov_zipcode_5.ToString().Trim().Length >0)
{
if (myHeader.prov_zipcode_5.ToString().Trim().Length<9) {
myHeader.prov_zipcode_5 += (new string('9', 9 - myHeader.prov_zipcode_5.ToString().Trim().Length));
}
}else {
myHeader.prov_zipcode_5 = ("999999999");
}
myHeader.prov_phone_6 = ("7879999999");//Program.MySqlbusqueda(sqlCnnString, "select ContactTelephone from tblProvider where NPI = '" + V156NPI + "'");
myHeader.provpaynam_7 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LASTNAME],1,CHARINDEX (' ',[LASTNAME],1)) + ' ' + FIRSTNAME from " + tblProvider + " where (payee_npi ='" + V156NPI + "') or (npi='" + V156NPI + "')"));
myHeader.prov_contac = myHeader.provpaynam_7;
}
{
myHeader.prov_name_3 = (myHeader.prov_name_3.ToString().Trim());
if (myHeader.prov_name_3.Length > 33)
{
myHeader.prov_name_3 = ( myHeader.prov_name_3.ToString().Substring(0, 33));
}
}
myHeader.provpayadr_8 = (" "); //myHeader.prov_addrs_4;
myHeader.provpaycsz_9 = (" ");//myHeader.prov_csz_5;
myHeader.provpayphn_10 = (" ");// myHeader.prov_phone_6;
myHeader.two_1_11 = (new string(' ', 37));
myHeader.two_2_12 = (new string(' ', 37));
{
myHeader.pat_id_13 = (foxDR["V1PATCNTRL"].ToString());
if (myHeader.pat_id_13.ToString().Trim().Length == 0)
{
myHeader.pat_id_13 = ("0");
}
}
myHeader.med_rec_no_14 = (foxDR["V1MEDREC"].ToString());
myHeader.batch_type_15 = (foxDR["V1TYOFBILL"].ToString());
myHeader.clam_freq = (" ");
myHeader.fedtaxid_16 = (V1FEDTAXNO.Trim()); ; //foxDR["V1FEDTAXNO"].ToString();
myHeader.from_date_17 = (Program.setFecha(foxDR["V1STDATE1"].ToString(), Images));
myHeader.thru_date_18 = (Program.setFecha(foxDR["V1STDATE2"].ToString(), Images));
{
String fl_7_19 = foxDR["V1ADMIDATE"].ToString().Trim();
if (fl_7_19.Trim().Length == 0)
{
fl_7_19 = myHeader.from_date_17.ToString().Trim();
}
if (fl_7_19.Length < 6)
{
throw new Exception("Error en la fecha V1ADMIDATE -->" + fl_7_19 + " -->Imagen-->" + Images);
}
if (fl_7_19.Length == 0)
{
myHeader.fl_7_19 = ( Program.setFecha(Images.Substring(0, 6), Images));
}
else
{
try
{
String imgDate = "20" + Images.Substring(4, 2) +
Images.Substring(0, 2) +
Images.Substring(2, 2);
fl_7_19 = "20" + fl_7_19.Substring(4, 2) +
fl_7_19.Substring(0, 2) +
fl_7_19.Substring(2, 2);
string dateNow = System.DateTime.Today.ToString("yyMMdd");
if (Convert.ToInt32(fl_7_19) > Convert.ToInt32(dateNow))
{
myHeader.fl_7_19 = (Program.setFecha(Images.Substring(0, 6), Images));
}
else
{
myHeader.fl_7_19 = (Program.setFecha(foxDR["V1ADMIDATE"].ToString(), Images));
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString() + " --fl_7_19");
}
}
}
myHeader.cov_d_20 = (new string(' ', 10));
myHeader.ncd_21 = (new string(' ', 10));
myHeader.cid_22 = (new string(' ', 10));
myHeader.lrd_23 = (new string(' ', 10));
myHeader.eleven_1_24 = (new string(' ', 16));
myHeader.eleven_2_25 = (new string(' ', 16));
myHeader.pat_lname_26 = (Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LastNM],1,CHARINDEX (' ',[LastNM],1)) AS LASTNAME from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
if (myHeader.pat_lname_26.ToString().Trim().Length == 0)
{
myHeader.pat_lname_26 = (Program.MySqlbusqueda(sqlCnnString, "select LastNM from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
}
myHeader.pat_fname_27 = (Program.MySqlbusqueda(sqlCnnString, "select FirstNM from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.pat_mname_28 = (Program.MySqlbusqueda(sqlCnnString, "select MI from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.pat_nmsfx_29 = (new string(' ', 10));
myHeader.pat_addrs_30 = (Program.MySqlbusqueda(sqlCnnString, "select Street from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.pat_city_31 = (Program.MySqlbusqueda(sqlCnnString, "select City from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.pat_state_32 = (Program.MySqlbusqueda(sqlCnnString, "select State from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
{
myHeader.pat_zip_33 = (Program.MySqlbusqueda(sqlCnnString, "select Zip from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
if (myHeader.pat_zip_33.ToString().Trim().Length > 0)
{
if (myHeader.pat_zip_33.ToString().Trim().Length >= 5)
{
myHeader.pat_zip_33 = (myHeader.pat_zip_33.ToString().Trim().Substring(0, 5));
}
else
{
myHeader.pat_zip_33 = ("99999");
}
}
else
{
myHeader.pat_zip_33 = ("99999");
}
}
{
myHeader.pat_bd_34 = (Program.MySqlbusqueda(sqlCnnString, "select Birth from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
if (myHeader.pat_bd_34.ToString().Trim().Length == 10)
{
try
{
System.DateTime Dt = System.DateTime.Parse(myHeader.pat_bd_34.ToString());
myHeader.pat_bd_34 = ( Dt.ToString("yyyyMMdd"));
}
catch (Exception ex)
{
throw new Exception(ex.Message + "--pat_bd_34-->" + myHeader.pat_bd_34);
}
}
else
{
try
{//Dummy
System.DateTime Dt = System.DateTime.Parse("01/01/1901");
myHeader.pat_bd_34 = (Dt.ToString("yyyyMMdd"));
}
catch (Exception ex)
{
throw new Exception(ex.Message + "--pat_bd_34-->" + myHeader.pat_bd_34);
}
}
}
myHeader.pat_sex_35 = (Program.MySqlbusqueda(sqlCnnString, "select sex from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.pat_ms_36 = (new string(' ', 1));
{
if (foxDR["V1ADMIDATE"].ToString().Trim().Length != 0)
{
myHeader.adm_date_37 = (Program.setFecha(foxDR["V1ADMIDATE"].ToString(), Images));
}
else
{
myHeader.adm_date_37 = ( myHeader.from_date_17.ToString().Trim());
}
}
{
myHeader.adm_hour_38 = (foxDR["V1ADMIHOUR"].ToString());
try
{
//Int32 adm_hour_38 = Convert.ToInt32(myHeader.adm_hour_38);
string HH = myHeader.adm_hour_38.ToString().Trim().Substring(0, 2);
string MM = myHeader.adm_hour_38.ToString().Trim().Substring(2, 2);
int iHH = int.Parse(HH);
int iMM = int.Parse(MM);
if ((iHH > 24))
{
HH = "24";
}
if (iMM > 59)
{
MM = "00";
}
myHeader.adm_hour_38 = (HH + MM);
}
catch
{
myHeader.adm_hour_38 = ("2400");
}
}
{
Int32 itype_39 = Int32.Parse(foxDR["V1ADMITYPE"].ToString());
if ((itype_39 > 0) && (itype_39 < 5))
{
myHeader.adm_type_39 = (itype_39.ToString());
}
else
{
myHeader.adm_type_39 = ("9");
}
}
{
Int32 iadm_src_40 = Int32.Parse(foxDR["V1ADMSOURC"].ToString());
//1 2 4 6 7 8
switch (iadm_src_40)
{
case 1:
myHeader.adm_src_40 = (iadm_src_40.ToString());
break;
case 2:
myHeader.adm_src_40 = (iadm_src_40.ToString());
break;
case 4:
myHeader.adm_src_40 = (iadm_src_40.ToString());
break;
case 6:
myHeader.adm_src_40 = (iadm_src_40.ToString());
break;
case 7:
myHeader.adm_src_40 = (iadm_src_40.ToString());
break;
case 8:
myHeader.adm_src_40 = (iadm_src_40.ToString());
break;
default:
myHeader.adm_src_40 = ("9");
break;
}
}
myHeader.d_hr_41 = (foxDR["V1DHR"].ToString());
myHeader.stat_42 = (foxDR["V1PATSTATU"].ToString());
myHeader.cond_1_43 = (foxDR["V1CONCOD18"].ToString());
myHeader.cond_2_44 = (foxDR["V1CONCOD19"].ToString());
myHeader.cond_3_45 = (foxDR["V1CONCOD20"].ToString());
myHeader.cond_4_46 = (foxDR["V1CONCOD21"].ToString());
myHeader.cond_5_47 = (foxDR["V1CONCOD22"].ToString());
myHeader.cond_6_48 = (foxDR["V1CONCOD23"].ToString());
myHeader.cond_7_49 = (foxDR["V1CONCOD24"].ToString());
myHeader.cond_8_50 = (foxDR["V1CONCOD25"].ToString());
myHeader.cond_9_51 = (foxDR["V1CONCOD26"].ToString());
myHeader.cond_10_52 = (foxDR["V1CONCOD27"].ToString());
myHeader.cond_11_53 = (foxDR["V1CONCOD28"].ToString());
myHeader.acdt_st_54 = (new string(' ', 2));
myHeader.thirty1_55 = (new string(' ', 10));
myHeader.thirty_56 = (new string(' ', 10));
myHeader.occ_code1_57 = (new string(' ', 2));
myHeader.occ_date1_58 = (new string(' ', 8));
myHeader.occ_code2_59 = (new string(' ', 2));
myHeader.occ_date2_60 = (new string(' ', 8));
myHeader.occ_code3_61 = (new string(' ', 2));
myHeader.occ_date3_62 = (new string(' ', 8));
myHeader.occ_code4_63 = (new string(' ', 2));
myHeader.occ_date4_64 = (new string(' ', 8));
myHeader.occ_spanc1_65 = (new string(' ', 2));
myHeader.occ_spanf1_66 = (new string(' ', 8));
myHeader.occ_spant1_67 = (new string(' ', 8));
myHeader.occ_spanc2_68 = (new string(' ', 2));
myHeader.occ_spanf2_69 = (new string(' ', 8));
myHeader.occ_spant2_70 = (new string(' ', 8));
myHeader.occ_code5_71 = (new string(' ', 2));
myHeader.occ_date5_72 = (new string(' ', 8));
myHeader.occ_code6_73 = (new string(' ', 2));
myHeader.occ_date6_74 = (new string(' ', 8));
myHeader.occ_code7_75 = (new string(' ', 2));
myHeader.occ_date7_76 = (new string(' ', 8));
myHeader.occ_code8_77 = (new string(' ', 2));
myHeader.occ_date8_78 = (new string(' ', 8));
myHeader.occ_spanc3_79 = (new string(' ', 2));
myHeader.occ_spanf3_80 = (new string(' ', 8));
myHeader.occ_spant3_81 = (new string(' ', 8));
myHeader.occ_span4_82 = (new string(' ', 2));
myHeader.occ_spanf4_83 = (new string(' ', 8));
myHeader.occ_spant4_84 = (new string(' ', 8));
myHeader.a_37_85 = (new string(' ', 28));
myHeader.b_37_86 = (new string(' ', 28));
myHeader.c_37_87 = (new string(' ', 29));
myHeader.a_38_88 = (new string(' ', 50));
myHeader.LNAME_38 = (" ");
myHeader.FNAME_38 = (" ");
myHeader.MNAME_38 = (" ");
myHeader.NAMESFX_38 = (" ");
myHeader.b_38_89 = (new string(' ', 50));
myHeader.c_38_90 = (new string(' ', 50));
myHeader.CITY_38 = ( " ");
myHeader.STATE_38 = (" ");
myHeader.ZIP_38 = (" ");
myHeader.d_38_91 = (new string(' ', 50));
myHeader.e_38_92 = (" "); //new string(' ', 50);
{
try
{
myHeader.val_code1_93 = (foxDR["V1VALUCO39"].ToString());
if (myHeader.val_code1_93.ToString().Trim() == "00")
{
myHeader.val_code1_93 = (" ");
}
}
catch
{
throw new Exception("Error con val_code1_93 [V1VALUCO39]:" + myHeader.val_code1_93);
}
}
myHeader.val_code1_93 = ( " "); // esto es temporero pues esta esta mal
{
myHeader.val_code2_94 = (foxDR["V1VALUCO40"].ToString());
if (myHeader.val_code2_94.ToString().Trim() == "00")
{
myHeader.val_code2_94 = ( " ");
}
}
myHeader.val_code2_94 = (" "); // esto es temporero pues esta mal
myHeader.val_code3_95 = ( new string(' ', 2));
myHeader.val_code4_96 = (new string(' ', 2));
myHeader.val_code5_97 = ( new string(' ', 2));
myHeader.val_code6_98 = ( new string(' ', 2));
myHeader.val_code7_99 = (new string(' ', 2));
myHeader.val_code8_100 = ( new string(' ', 2));
myHeader.val_code9_101 = ( new string(' ', 2));
myHeader.val_code10_102 = ( new string(' ', 2));
myHeader.val_code11_103 = ( new string(' ', 2));
myHeader.val_code12_104 = ( new string(' ', 2));
{
myHeader.val_amt1_105 = (foxDR["V1AMOUNT39"].ToString());
if (myHeader.val_amt1_105.ToString() == "00")
{
myHeader.val_amt1_105 = ( " ");
}
myHeader.val_amt1_105 = ( " "); // esto es temporero pues esta mal
myHeader.val_amt2_106 = ( foxDR["V1AMOUNT40"].ToString());
if (myHeader.val_amt2_106.ToString() == "00")
{
myHeader.val_amt2_106 = (" ");
}
myHeader.val_amt2_106 = (" "); // esto es temporero pues esta mal
}
myHeader.val_amt3_107 = (new string(' ', 12));
myHeader.val_amt4_108 = (new string(' ', 12));
myHeader.val_amt5_109 = (new string(' ', 12));
myHeader.val_amt6_110 = (new string(' ', 12));
myHeader.val_amt7_111 = (new string(' ', 12));
myHeader.val_amt8_112 = (new string(' ', 12));
myHeader.val_amt9_113 = (new string(' ', 12));
myHeader.val_amt10_114 = (new string(' ', 12));
myHeader.val_amt11_115 = (new string(' ', 12));
myHeader.val_amt12_116 = (new string(' ', 12));
myHeader.pay_name1_117 = ( pay_name1_117);
myHeader.pay_name2_118 = (new string(' ', 31));
myHeader.pay_name3_119 = (new string(' ', 31));
myHeader.pay_id1_120 = ( "660610220"); //MMM ID
myHeader.pay_id2_121 = (new string(' ', 20));
myHeader.pay_id3_122 = (new string(' ', 20));
{
if (isNotGoodV156NPI)
{
myHeader.prov_npi56_123 = ( foxDR["V156NPI"].ToString());
}
else
{
myHeader.prov_npi56_123 = ( V156NPI);
}
}
myHeader.prov_no1_124 = (new string(' ', 16));
myHeader.prov_no2_125 = (new string(' ', 16));
myHeader.prov_no3_126 = (new string(' ', 16));
myHeader.rel_info1_127 = ( "N" + new string(' ', 9));
myHeader.rel_info2_128 = (new string(' ', 10));
myHeader.rel_info3_129 = (new string(' ', 10));
myHeader.asg_ben1_130 = ( "Y");// new string(' ', 10));
myHeader.asg_ben2_131 = (new string(' ', 10));
myHeader.asg_ben3_132 = (new string(' ', 10));
myHeader.prior_pay1_133 = (new string(' ', 12));
myHeader.prior_pay2_134 = (new string(' ', 12));
myHeader.prior_pay3_135 = (new string(' ', 12));
myHeader.prior_pay4_136 = (new string(' ', 12));
myHeader.est_due1_137 = (new string(' ', 12));
myHeader.est_due2_138 = (new string(' ', 12));
myHeader.est_due3_139 = (new string(' ', 12));
myHeader.est_due4_140 = (new string(' ', 12));
myHeader.a_56_141 = (new string(' ', 18)); //V1BILLPROV;// new string(' ', 18));
myHeader.b_56_142 = (new string(' ', 18));
myHeader.c_56_143 = (new string(' ', 18));
myHeader.d_56_144 = (new string(' ', 18));
myHeader.e_56_145 = (new string(' ', 18));
myHeader.a_57_146 = (new String(' ', 34)); //V1BILLPROV;
// SI NO ESTA LE PONGO 99999
myHeader.ins_name1_147 = ( Program.MySqlbusqueda(sqlCnnString, "select " +
" rtrim(ltrim(SUBSTRING([LastNM],1,CHARINDEX (' ',[LastNM],1)))) + ',' + rtrim(ltrim(FirstNM)) as name from " +
tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.ins_lname1 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LastNM],1,CHARINDEX (' ',[LastNM],1)) AS LASTNAME from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')").Trim());
if (myHeader.ins_lname1.ToString ().Trim().Length == 0)
{
myHeader.ins_lname1 = ( Program.MySqlbusqueda(sqlCnnString, "select LastNM from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')").Trim());
}
myHeader.ins_fname1 = ( Program.MySqlbusqueda(sqlCnnString, "select rtrim(ltrim(FirstNM)) from " + tblSubscribers + " where (membid = '" + V1SUSCRIID + "') or (membid2 = '" + V1SUSCRIID + "')"));
myHeader.ins_mname1 = ( " ");
myHeader.ins_namesfx1 = ( " ");
myHeader.ins_name2_148 = ( ""); // Program.busqueda(sqlCnnString, "select LastName2 from " + tblSubscribers + " where SubscriberID = '" + V1SUSCRIID + "'");
myHeader.ins_lname2 = ( " ");
myHeader.ins_fname2 = ( " ");
myHeader.ins_mname2 = ( " ");
myHeader.ins_namesfx2 = ( " ");
myHeader.ins_name3_149 = ( ""); //Program.busqueda(sqlCnnString, "select FirstName from " + tblSubscribers + " where SubscriberID = '" + V1SUSCRIID + "'");
myHeader.ins_lname3 = ( " ");
myHeader.ins_fname3 = ( " ");
myHeader.ins_mname3 = ( " ");
myHeader.ins_namesfx3 = ( " ");
myHeader.p_relat1_150 = ( "18"); // Ref:18 PPO: 001 (18), 011(01), other(24)
myHeader.p_relat2_151 = ( new string(' ', 3));
myHeader.p_relat3_152 = ( new string(' ', 3));
myHeader.crt1_153 = ( V1SUSCRIID); //foxDR["V1SUSCRIID"].ToString(); // new string(' ',24);
//Program.busqueda(sqlCnnString, "select GenderCode from " + tblSubscribers + " where SuscriberID = '" + V1SUSCRIID + "'");
myHeader.crt2_154 = ( new string(' ', 24));
myHeader.crt3_155 = ( new string(' ', 24));
myHeader.group1_156 = (new string(' ', 20));
myHeader.group2_157 = ( new string(' ', 20));
myHeader.group3_158 = ( new string(' ', 20));
myHeader.ins_group1_159 = (new string(' ', 21));
myHeader.ins_group2_160 = (new string(' ', 21));
myHeader.ins_group3_161 = (new string(' ', 21));
myHeader.treat_cod1_162 = ( foxDR["V1TREATAUT"].ToString());
myHeader.treat_cod2_163 = ( new string(' ', 22));
myHeader.treat_cod3_164 = ( new string(' ', 22));
myHeader.esc1_165 = ( new string(' ', 2));
myHeader.esc2_166 = ( new string(' ', 2));
myHeader.esc3_167 = ( new string(' ', 2));
myHeader.doc_ctrl1_168 = ( new string(' ', 20));
myHeader.doc_ctrl2_169 = ( new string(' ', 20));
myHeader.doc_ctrl3_170 = ( new string(' ', 20));
myHeader.emp_name1_171 = ( new string(' ', 30));
myHeader.emp_name2_172 = ( new string(' ', 30));
myHeader.emp_name3_173 = ( new string(' ', 30));
myHeader.emp_loc1_174 = ( new string(' ', 43));
myHeader.emp_loc2_175 = ( new string(' ', 43));
myHeader.emp_loc3_176 = ( new string(' ', 43));
{//mydbMMM.tblDiagnosisCodes
myHeader.diag1_177 = ( foxDR["V2PRINDIAG"].ToString().ToString().Trim());
if (myHeader.diag1_177.Length == 0)
{
myHeader.diag1_177 = ("99999");
}
else
{
String count = Program.MySqlbusqueda(sqlCnnString,
"select count(*) from tblDiagnosisCodes where code='" + myHeader.diag1_177 + "';");
if (count == "0")
{
myHeader.diag1_177 = ("99999");
}
}
}
myHeader.diag2_178 = (foxDR["V267ACOD"].ToString());
myHeader.diag3_179 = (foxDR["V267BCOD"].ToString());
myHeader.diag4_180 = (foxDR["V267CCOD"].ToString());
myHeader.diag5_181 = (foxDR["V267DCOD"].ToString());
myHeader.diag6_182 = (foxDR["V267ECOD"].ToString());
myHeader.diag7_183 = (foxDR["V267FCOD"].ToString());
myHeader.diag8_184 = (foxDR["V267GCOD"].ToString());
myHeader.diag9_185 = (foxDR["V267HCOD"].ToString());
myHeader.diag10_186 = (foxDR["V267ICOD"].ToString());
myHeader.diag11_187 = (foxDR["V267JCOD"].ToString());
myHeader.diag12_188 = (foxDR["V267KCOD"].ToString());
myHeader.diag13_189 = (foxDR["V267LCOD"].ToString());
myHeader.diag14_190 = (foxDR["V267MCOD"].ToString());
myHeader.diag15_191 = (foxDR["V267NCOD"].ToString());
myHeader.diag16_192 = (foxDR["V267OCOD"].ToString());
myHeader.diag17_193 = (foxDR["V267PCOD"].ToString());
myHeader.diag18_194 = (foxDR["V267QCOD"].ToString());
myHeader.adm_diag_195 = (foxDR["V2ADMDIACD"].ToString());
myHeader.e_code1_196 = (foxDR["V2PATIENDX"].ToString());
myHeader.e_code2_197 = ( new string(' ', 8));
myHeader.e_code3_198 = (new string(' ', 8));
myHeader.pat_rdx1_199 = ( new string(' ', 8));
myHeader.pat_rdx2_200 = (new string(' ', 8));
myHeader.pat_rdx3_201 = ( new string(' ', 8));
myHeader.pps_code = ( " ");
myHeader.a_73_202 = ( new string(' ', 10));
{
myHeader.proc_cod1_203 = (foxDR["V2CODE74"].ToString());
myHeader.proc_cod2_204 = (foxDR["V2CODE74A"].ToString());
myHeader.proc_cod3_205 = (foxDR["V2CODE74B"].ToString());
myHeader.proc_cod4_206 = (foxDR["V2CODE74C"].ToString());
myHeader.proc_cod5_207 = (foxDR["V2CODE74D"].ToString());
myHeader.proc_cod6_208 = (foxDR["V2CODE74E"].ToString());
if (myHeader.proc_cod1_203.ToString ().Trim().Length > 0)
{
myHeader.proc_date1_209 = ( GetDate2(foxDR["V2DATE74"].ToString()));
if (myHeader.proc_date1_209.ToString().Trim().Length == 0)
{
myHeader.proc_date1_209 = myHeader.from_date_17;
}
}
else
{
myHeader.proc_date1_209 = ( new string(' ', 8));
}
if (myHeader.proc_cod2_204.ToString().Trim().Length > 0)
{
myHeader.proc_date2_210 = ( GetDate2(foxDR["V2DATE74A"].ToString()));
if (myHeader.proc_date2_210.ToString().Trim().Length == 0)
{
myHeader.proc_date2_210 = myHeader.from_date_17;
}
}
else
{
myHeader.proc_date2_210 = ( new string(' ', 8));
}
if (myHeader.proc_cod3_205.ToString ().Trim().Length > 0)
{
myHeader.proc_date3_211 = ( GetDate2(foxDR["V2DATE74B"].ToString()));
if (myHeader.proc_date3_211.ToString().Trim().Length == 0)
{
myHeader.proc_date3_211 = myHeader.from_date_17;
}
}
else
{
myHeader.proc_date3_211 = ( new string(' ', 8));
}
if (myHeader.proc_cod4_206.ToString().Trim().Length > 0)
{
myHeader.proc_date4_212 = (GetDate2(foxDR["V2DATE74C"].ToString()));
if (myHeader.proc_date4_212.ToString().Trim().Length == 0)
{
myHeader.proc_date4_212 = myHeader.from_date_17;
}
}
else
{
myHeader.proc_date4_212 = ( new string(' ', 8));
}
if (myHeader.proc_cod5_207.ToString ().Trim().Length > 0)
{
myHeader.proc_date5_213 = ( GetDate2(foxDR["V2DATE74D"].ToString()));
if (myHeader.proc_date5_213.ToString().Trim().Length == 0)
{
myHeader.proc_date5_213 = myHeader.from_date_17;
}
}
else
{
myHeader.proc_date5_213 = ( new string(' ', 8));
}
if (myHeader.proc_cod6_208.ToString().Trim().Length > 0)
{
myHeader.proc_date6_214 = ( GetDate2(foxDR["V2DATE74E"].ToString()));
if (myHeader.proc_date6_214.ToString().Trim().Length == 0)
{
myHeader.proc_date6_214 = myHeader.from_date_17;
}
}
else
{
myHeader.proc_date6_214 = ( new string(' ', 8));
}
}
//
myHeader.att_phyln_215 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LASTNAME],1,CHARINDEX (' ',[LASTNAME],1)) AS LASTNAME from " + tblProvider + " where (NPI = '" + V276NPI + "') or (payee_npi ='" + V276NPI + "')")); //LASTNAME FIRSTNAME
if (myHeader.att_phyln_215.ToString().Trim().Length ==0)
{
myHeader.att_phyln_215 = (Program.MySqlbusqueda(sqlCnnString, "select LASTNAME from " + tblProvider + " where (NPI = '" + V276NPI + "') or (payee_npi ='" + V276NPI + "')")); //LASTNAME FIRSTNAME
}
myHeader.att_phyfn_216 = ( Program.MySqlbusqueda(sqlCnnString, "select FIRSTNAME from " + tblProvider + " where (NPI = '" + V276NPI + "') or (payee_npi='" + V276NPI + "')"));
myHeader.att_phymn = ( " ");
myHeader.att_physfx = ( " ");
//***********************************************************************************
//TODO Write 217, 218,219 ** V276NPI
if (V276NPI == "9999999995")
{
myHeader.att_phynpi_217 = (foxDR["V276NPI"].ToString());
if (myHeader.att_phynpi_217.ToString().Trim().Length == 0)
{
myHeader.att_phynpi_217 = ( V276NPI);
}
myHeader.att_phyidq_218 = ( new string(' ', 3));
myHeader.att_phyid_219 = ( new string(' ', 15));
}
else
{
myHeader.att_phynpi_217 = ( V276NPI);
if (!isNotGoodV276NPI)
{
myHeader.att_phyidq_218 = ( new string(' ', 3));
myHeader.att_phyid_219 = (new string(' ', 15));
}
else
{
myHeader.att_phyidq_218 = ( new string(' ', 3));
myHeader.att_phyid_219 = (new string(' ', 15));
}
}
myHeader.op_phyln_220 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LASTNAME],1,CHARINDEX (' ',[LASTNAME],1)) AS LASTNAME from " + tblProvider + " where (NPI = '" + V2OPERANPI + "') or (payee_npi='" + V2OPERANPI + "')")); //LASTNAME FIRSTNAME
if (myHeader.op_phyln_220.ToString().Trim().Length == 0)
{
myHeader.op_phyln_220 = ( Program.MySqlbusqueda(sqlCnnString, "select LASTNAME from " + tblProvider + " where (NPI = '" + V2OPERANPI + "') or (payee_npi='" + V2OPERANPI + "')")); //LASTNAME FIRSTNAME
}
myHeader.op_phyfn_221 = ( Program.MySqlbusqueda(sqlCnnString, "select FIRSTNAME from " + tblProvider + " where (NPI = '" + V2OPERANPI + "') or (payee_npi='" + V2OPERANPI + "')")); //LASTNAME FIRSTNAME
myHeader.op_phymn = ( " ");
myHeader.op_physfx = (" ");
// Write 222, 223,224 ** V2OPERANPI
if (V2OPERANPI == "9999999995")
{
myHeader.op_phy_npi_222 = ( foxDR["V2OPERANPI"].ToString());
myHeader.op_phyidq_223 = ( new string(' ', 3));
myHeader.op_phyid_224 = ( new string(' ', 15));
}
else
{
myHeader.op_phy_npi_222 = ( V2OPERANPI);
if (!isNotGoodV2OPERANPI)
{
myHeader.op_phyidq_223 = ( new string(' ', 3));
myHeader.op_phyid_224 = ( new string(' ', 15));
}
else
{
myHeader.op_phyidq_223 = ( new string(' ', 3));
myHeader.op_phyid_224 = ( new string(' ', 15));
}
}
myHeader.ot_phy1ln_225 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LASTNAME],1,CHARINDEX (' ',[LASTNAME],1)) AS LASTNAME from " + tblProvider + " where (NPI = '" + V278NPI + "') or (payee_npi='" + V278NPI + "')")); //LASTNAME FIRSTNAME
if (myHeader.ot_phy1ln_225.ToString().Trim().Length == 0)
{
myHeader.ot_phy1ln_225 = ( Program.MySqlbusqueda(sqlCnnString, "select LASTNAME from " + tblProvider + " where (NPI = '" + V278NPI + "') or (payee_npi='" + V278NPI + "')")); //LASTNAME FIRSTNAME
}
myHeader.ot_phy1fn_226 = (Program.MySqlbusqueda(sqlCnnString, "select FIRSTNAME from " + tblProvider + " where (NPI = '" + V278NPI + "') or (payee_npi='" + V278NPI + "')")); //LASTNAME FIRSTNAME
// Write 227, 228,229 ** V278NPI
if (V278NPI == "9999999995")
{
myHeader.ot_phy1npi_227 = ( foxDR["V278NPI"].ToString());
myHeader.ot_phy1idq_228 = ( new string(' ', 3));
myHeader.ot_phy1id_229 = ( new string(' ', 15));
}
else
{
myHeader.ot_phy1npi_227 = ( V278NPI);
if (isNotGoodV278NPI == false)
{
myHeader.ot_phy1idq_228 = (new string(' ', 3));
myHeader.ot_phy1id_229 = (new string(' ', 15));
}
else
{
myHeader.ot_phy1idq_228 = ( new string(' ', 3));
myHeader.ot_phy1id_229 = ( new string(' ', 15));
}
}
myHeader.ot_phy2ln_230 = ( Program.MySqlbusqueda(sqlCnnString, "select SUBSTRING([LASTNAME],1,CHARINDEX (' ',[LASTNAME],1)) AS LASTNAME from " + tblProvider + " where (NPI = '" + V279NPI + "') or (payee_npi='" + V279NPI + "')")); //LASTNAME FIRSTNAME
if (myHeader.ot_phy2ln_230.ToString().Trim().Length == 0)
{
myHeader.ot_phy2ln_230 = ( Program.MySqlbusqueda(sqlCnnString, "select LASTNAME from " + tblProvider + " where (NPI = '" + V279NPI + "') or (payee_npi='" + V279NPI + "')")); //LASTNAME FIRSTNAME
}
myHeader.ot_phy2fn_231 = (Program.MySqlbusqueda(sqlCnnString, "select FIRSTNAME from " + tblProvider + " where (NPI = '" + V279NPI + "') or (payee_npi='" + V279NPI + "')")); //LASTNAME FIRSTNAME
// Write 232, 233,234 ** V279NPI
if (V279NPI == "9999999995")
{
myHeader.ot_phy2npi_232 = (foxDR["V279NPI"].ToString());
myHeader.ot_phy2idq_233 = (new string(' ', 3));
myHeader.ot_phy2id_234 = ( new string(' ', 15));
}
else
{
myHeader.ot_phy2npi_232 = ( V279NPI);
if (!isNotGoodV279NPI)
{
myHeader.ot_phy2idq_233 = ( new string(' ', 3));
myHeader.ot_phy2id_234 = (new string(' ', 15));
}
else
{
myHeader.ot_phy2idq_233 = ( new string(' ', 3));
myHeader.ot_phy2id_234 = (new string(' ', 15));
}
}
//***************************************************************************************
myHeader.remarks1_235 = ( foxDR["V2REMARKS"].ToString());
myHeader.remarks2_236 = ( new string(' ', 58));
myHeader.remarks3_237 = (new string(' ', 58));
myHeader.remarks4_238 = ( new string(' ', 58));
myHeader.prov_rep_239 = ( new string(' ', 26));
myHeader.prov_rp_dt_240 = ( new string(' ', 15));
myHeader.fl81a_1_241 = ( new string(' ', 2));
myHeader.fl81a_2_242 = ( new string(' ', 10));
myHeader.fl81a_3_243 = ( new string(' ', 12));
myHeader.fl81b_1_244 = ( new string(' ', 2));
myHeader.fl81b_2_245 = ( new string(' ', 10));
myHeader.fl81b_3_246 = ( new string(' ', 12));
myHeader.fl81c_1_247 = ( new string(' ', 2));
myHeader.fl81c_2_248 = ( new string(' ', 10));
myHeader.fl81c_3_249 = ( new string(' ', 12));
myHeader.fl81d_1_250 = ( new string(' ', 2));
myHeader.fl81d_2_251 = ( new string(' ', 10));
myHeader.fl81d_3_252 = (new string(' ', 12));
myHeader.poa1_253 = (foxDR["V2COD1"].ToString());
myHeader.poa2_254 = ( foxDR["V2COD2"].ToString());
myHeader.poa3_255 = ( foxDR["V2COD3"].ToString());
myHeader.poa4_256 = ( foxDR["V2COD4"].ToString());
myHeader.poa5_257 = ( foxDR["V2COD5"].ToString());
myHeader.poa6_258 = ( foxDR["V2COD6"].ToString());
{
// Estrututa de la image file : MMDDYY CC BBBB SEQDOC.TIF
//**** Icn ejemplo: CCNNNNMMMDD`YY Nota:CC es el numero de la CATEGORIA
//NNNN numero de la Seq no usal LA DE LA IMAGEN hay que calcularlo Cadave q cabies de Categoria regresa a uno,
//MMM es el Nombre del mes, DD es el dia,YY es el ano
String img = Images;
String CC = img.Substring(6, 2);
if (TMPcc == CC)
{
iCC++;
}
else
{
if (CC == "97")
{
iCC = int.Parse(sCount);
iCC++;
}
else
{
iCC = 1;
}
TMPcc = CC;
}
String NNNN = iCC.ToString("000#");
String MMM = img.Substring(0, 2);
String DD = img.Substring(2, 2);
String YY = img.Substring(4, 2);
switch (MMM)
{
case "01":
MMM = "JAN";
break;
case "02":
MMM = "FEB";
break;
case "03":
MMM = "MAR";
break;
case "04":
MMM = "APR";
break;
case "05":
MMM = "MAY";
break;
case "06":
MMM = "JUN";
break;
case "07":
MMM = "JUL";
break;
case "08":
MMM = "AUG";
break;
case "09":
MMM = "SEP";
break;
case "10":
MMM = "OCT";
break;
case "11":
MMM = "NOV";
break;
case "12":
MMM = "DEC";
break;
}
myHeader.icn_259 = ( CC + NNNN + MMM.Substring(0, 3) + DD + "'" + YY);
}
myHeader.bht_260 = ( Images.Substring(0, 2) + "/" + Images.Substring(2, 2) + "/20" + Images.Substring(4, 2)); // mm/dd/ccyy
if (myHeader.prov_addrs_4.ToString().Trim().Length == 0)
{
myHeader.prov_addrs_4 = ( "DUMMY ADDRESS");
}
if (myHeader.pat_addrs_30.ToString().Trim().Length == 0)
{
myHeader.pat_addrs_30 = ("DUMMY ADDRESS");
}
if (myHeader.diag1_177.ToString().Trim().Length == 0)
{
myHeader.diag1_177 = ( "99999");
}
if (myHeader.adm_diag_195.ToString().Trim().Length == 0)
{
myHeader.adm_diag_195 = ( "99999");
}
//////////////////////////////////////////////////////////////////////////////////////////////////
using (StreamWriter fs = File.AppendText(txtFileOutPut.Trim()))
{
sHDOut.Clear();
//myHeader.uniquekey_1 + "|" +
sHDOut.Append(myHeader.claim_no_2 ); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_name_3); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_addrs_4.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_csz_5.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_state_5.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_zipcode_5.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_phone_6); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_contac); sHDOut.Append("|");
//sHDOut.Append(myHeader.provpayadr_8.Trim()); sHDOut.Append("|");
//sHDOut.Append(myHeader.provpaycsz_9.Trim()); sHDOut.Append("|");
//sHDOut.Append(myHeader.provpayphn_10); sHDOut.Append("|");
sHDOut.Append(myHeader.two_1_11); sHDOut.Append("|");
sHDOut.Append(myHeader.two_2_12); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_id_13); sHDOut.Append("|");
sHDOut.Append(myHeader.med_rec_no_14); sHDOut.Append("|");
sHDOut.Append(myHeader.batch_type_15); sHDOut.Append("|");
sHDOut.Append(myHeader.clam_freq); sHDOut.Append("|");
sHDOut.Append(myHeader.fedtaxid_16); sHDOut.Append("|");
sHDOut.Append(myHeader.from_date_17); sHDOut.Append("|");
sHDOut.Append(myHeader.thru_date_18); sHDOut.Append("|");
sHDOut.Append(myHeader.fl_7_19); sHDOut.Append("|");
sHDOut.Append(myHeader.cov_d_20); sHDOut.Append("|");
sHDOut.Append(myHeader.ncd_21); sHDOut.Append("|");
sHDOut.Append(myHeader.cid_22); sHDOut.Append("|");
sHDOut.Append(myHeader.lrd_23); sHDOut.Append("|");
sHDOut.Append(myHeader.eleven_1_24); sHDOut.Append("|");
sHDOut.Append(myHeader.eleven_2_25); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_lname_26); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_fname_27); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_mname_28); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_nmsfx_29); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_addrs_30); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_city_31); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_state_32); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_zip_33); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_bd_34); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_sex_35); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_ms_36); sHDOut.Append("|");
sHDOut.Append(myHeader.adm_date_37); sHDOut.Append("|");
sHDOut.Append(myHeader.adm_hour_38); sHDOut.Append("|");
sHDOut.Append(myHeader.adm_type_39); sHDOut.Append("|");
sHDOut.Append(myHeader.adm_src_40); sHDOut.Append("|");
sHDOut.Append(myHeader.d_hr_41); sHDOut.Append("|");
sHDOut.Append(myHeader.stat_42); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_1_43); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_2_44); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_3_45); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_4_46); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_5_47); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_6_48); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_7_49); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_8_50); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_9_51); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_10_52); sHDOut.Append("|");
sHDOut.Append(myHeader.cond_11_53); sHDOut.Append("|");
sHDOut.Append(myHeader.acdt_st_54); sHDOut.Append("|");
sHDOut.Append(myHeader.thirty1_55); sHDOut.Append("|");
sHDOut.Append(myHeader.thirty_56); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code1_57); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date1_58); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code2_59); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date2_60); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code3_61); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date3_62); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code4_63); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date4_64); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanc1_65); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanf1_66); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spant1_67); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanc2_68); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanf2_69); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spant2_70); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code5_71); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date5_72); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code6_73); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date6_74); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code7_75); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date7_76); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_code8_77); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_date8_78); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanc3_79); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanf3_80); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spant3_81); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_span4_82); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spanf4_83); sHDOut.Append("|");
sHDOut.Append(myHeader.occ_spant4_84); sHDOut.Append("|");
sHDOut.Append(myHeader.a_37_85); sHDOut.Append("|");
sHDOut.Append(myHeader.b_37_86); sHDOut.Append("|");
sHDOut.Append(myHeader.c_37_87); sHDOut.Append("|");
sHDOut.Append(myHeader.a_38_88); sHDOut.Append("|");
sHDOut.Append(myHeader.LNAME_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.FNAME_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.MNAME_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.NAMESFX_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.b_38_89); sHDOut.Append("|");
sHDOut.Append(myHeader.c_38_90); sHDOut.Append("|");
sHDOut.Append(myHeader.CITY_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.STATE_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ZIP_38.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.d_38_91); sHDOut.Append("|");
// sHDOut.Append(myHeader.e_38_92); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code1_93); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code2_94); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code3_95); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code4_96); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code5_97); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code6_98); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code7_99); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code8_100); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code9_101); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code10_102); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code11_103); sHDOut.Append("|");
sHDOut.Append(myHeader.val_code12_104); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt1_105); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt2_106); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt3_107); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt4_108); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt5_109); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt6_110); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt7_111); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt8_112); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt9_113); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt10_114); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt11_115); sHDOut.Append("|");
sHDOut.Append(myHeader.val_amt12_116); sHDOut.Append("|");
sHDOut.Append(myHeader.pay_name1_117); sHDOut.Append("|");
sHDOut.Append(myHeader.pay_name2_118); sHDOut.Append("|");
sHDOut.Append(myHeader.pay_name3_119); sHDOut.Append("|");
sHDOut.Append(myHeader.pay_id1_120); sHDOut.Append("|");
sHDOut.Append(myHeader.pay_id2_121); sHDOut.Append("|");
sHDOut.Append(myHeader.pay_id3_122); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_npi56_123); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_no1_124); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_no2_125); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_no3_126); sHDOut.Append("|");
sHDOut.Append(myHeader.rel_info1_127); sHDOut.Append("|");
sHDOut.Append(myHeader.rel_info2_128); sHDOut.Append("|");
sHDOut.Append(myHeader.rel_info3_129); sHDOut.Append("|");
sHDOut.Append(myHeader.asg_ben1_130); sHDOut.Append("|");
sHDOut.Append(myHeader.asg_ben2_131); sHDOut.Append("|");
sHDOut.Append(myHeader.asg_ben3_132); sHDOut.Append("|");
sHDOut.Append(myHeader.prior_pay1_133); sHDOut.Append("|");
sHDOut.Append(myHeader.prior_pay2_134); sHDOut.Append("|");
sHDOut.Append(myHeader.prior_pay3_135); sHDOut.Append("|");
sHDOut.Append(myHeader.prior_pay4_136); sHDOut.Append("|");
sHDOut.Append(myHeader.est_due1_137); sHDOut.Append("|");
sHDOut.Append(myHeader.est_due2_138); sHDOut.Append("|");
sHDOut.Append(myHeader.est_due3_139); sHDOut.Append("|");
sHDOut.Append(myHeader.est_due4_140); sHDOut.Append("|");
sHDOut.Append(myHeader.a_56_141); sHDOut.Append("|");
sHDOut.Append(myHeader.b_56_142); sHDOut.Append("|");
sHDOut.Append(myHeader.c_56_143); sHDOut.Append("|");
sHDOut.Append(myHeader.d_56_144); sHDOut.Append("|");
sHDOut.Append(myHeader.e_56_145); sHDOut.Append("|");
sHDOut.Append(myHeader.a_57_146); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_name1_147); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_lname1.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_fname1.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_mname1.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_namesfx1.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_name2_148); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_lname2.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_fname2.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_mname2.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_namesfx2.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_name3_149); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_lname3.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_fname3.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_mname3.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_namesfx3.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.p_relat1_150); sHDOut.Append("|");
sHDOut.Append(myHeader.p_relat2_151); sHDOut.Append("|");
sHDOut.Append(myHeader.p_relat3_152); sHDOut.Append("|");
sHDOut.Append(myHeader.crt1_153); sHDOut.Append("|");
sHDOut.Append(myHeader.crt2_154); sHDOut.Append("|");
sHDOut.Append(myHeader.crt3_155); sHDOut.Append("|");
sHDOut.Append(myHeader.group1_156); sHDOut.Append("|");
sHDOut.Append(myHeader.group2_157); sHDOut.Append("|");
sHDOut.Append(myHeader.group3_158); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_group1_159); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_group2_160); sHDOut.Append("|");
sHDOut.Append(myHeader.ins_group3_161); sHDOut.Append("|");
sHDOut.Append(myHeader.treat_cod1_162); sHDOut.Append("|");
sHDOut.Append(myHeader.treat_cod2_163); sHDOut.Append("|");
sHDOut.Append(myHeader.treat_cod3_164); sHDOut.Append("|");
sHDOut.Append(myHeader.esc1_165); sHDOut.Append("|");
sHDOut.Append(myHeader.esc2_166); sHDOut.Append("|");
sHDOut.Append(myHeader.esc3_167); sHDOut.Append("|");
sHDOut.Append(myHeader.doc_ctrl1_168); sHDOut.Append("|");
sHDOut.Append(myHeader.doc_ctrl2_169); sHDOut.Append("|");
sHDOut.Append(myHeader.doc_ctrl3_170); sHDOut.Append("|");
sHDOut.Append(myHeader.emp_name1_171); sHDOut.Append("|");
sHDOut.Append(myHeader.emp_name2_172); sHDOut.Append("|");
sHDOut.Append(myHeader.emp_name3_173); sHDOut.Append("|");
sHDOut.Append(myHeader.emp_loc1_174); sHDOut.Append("|");
sHDOut.Append(myHeader.emp_loc2_175); sHDOut.Append("|");
sHDOut.Append(myHeader.emp_loc3_176); sHDOut.Append("|");
sHDOut.Append(myHeader.diag1_177); sHDOut.Append("|");
sHDOut.Append(myHeader.diag2_178); sHDOut.Append("|");
sHDOut.Append(myHeader.diag3_179); sHDOut.Append("|");
sHDOut.Append(myHeader.diag4_180); sHDOut.Append("|");
sHDOut.Append(myHeader.diag5_181); sHDOut.Append("|");
sHDOut.Append(myHeader.diag6_182); sHDOut.Append("|");
sHDOut.Append(myHeader.diag7_183); sHDOut.Append("|");
sHDOut.Append(myHeader.diag8_184); sHDOut.Append("|");
sHDOut.Append(myHeader.diag9_185); sHDOut.Append("|");
sHDOut.Append(myHeader.diag10_186); sHDOut.Append("|");
sHDOut.Append(myHeader.diag11_187); sHDOut.Append("|");
sHDOut.Append(myHeader.diag12_188); sHDOut.Append("|");
sHDOut.Append(myHeader.diag13_189); sHDOut.Append("|");
sHDOut.Append(myHeader.diag14_190); sHDOut.Append("|");
sHDOut.Append(myHeader.diag15_191); sHDOut.Append("|");
sHDOut.Append(myHeader.diag16_192); sHDOut.Append("|");
sHDOut.Append(myHeader.diag17_193); sHDOut.Append("|");
sHDOut.Append(myHeader.diag18_194); sHDOut.Append("|");
sHDOut.Append(myHeader.adm_diag_195); sHDOut.Append("|");
sHDOut.Append(myHeader.e_code1_196); sHDOut.Append("|");
sHDOut.Append(myHeader.e_code2_197); sHDOut.Append("|");
sHDOut.Append(myHeader.e_code3_198); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_rdx1_199); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_rdx2_200); sHDOut.Append("|");
sHDOut.Append(myHeader.pps_code.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.pat_rdx3_201); sHDOut.Append("|");
sHDOut.Append(myHeader.a_73_202); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_cod1_203); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_cod2_204); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_cod3_205); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_cod4_206); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_cod5_207); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_cod6_208); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_date1_209); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_date2_210); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_date3_211); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_date4_212); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_date5_213); sHDOut.Append("|");
sHDOut.Append(myHeader.proc_date6_214); sHDOut.Append("|");
sHDOut.Append(myHeader.att_phyln_215); sHDOut.Append("|");
sHDOut.Append(myHeader.att_phyfn_216); sHDOut.Append("|");
sHDOut.Append(myHeader.att_phymn.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.att_physfx.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.att_phynpi_217); sHDOut.Append("|");
sHDOut.Append(myHeader.att_phyidq_218); sHDOut.Append("|");
sHDOut.Append(myHeader.att_phyid_219); sHDOut.Append("|");
sHDOut.Append(myHeader.op_phyln_220); sHDOut.Append("|");
sHDOut.Append(myHeader.op_phyfn_221); sHDOut.Append("|");
sHDOut.Append(myHeader.op_phymn.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.op_physfx.ToString().Trim()); sHDOut.Append("|");
sHDOut.Append(myHeader.op_phy_npi_222); sHDOut.Append("|");
sHDOut.Append(myHeader.op_phyidq_223); sHDOut.Append("|");
sHDOut.Append(myHeader.op_phyid_224); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy1ln_225); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy1fn_226); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy1npi_227); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy1idq_228); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy1id_229); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy2ln_230); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy2fn_231); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy2npi_232); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy2idq_233); sHDOut.Append("|");
sHDOut.Append(myHeader.ot_phy2id_234); sHDOut.Append("|");
sHDOut.Append(myHeader.remarks1_235); sHDOut.Append("|");
sHDOut.Append(myHeader.remarks2_236); sHDOut.Append("|");
sHDOut.Append(myHeader.remarks3_237); sHDOut.Append("|");
sHDOut.Append(myHeader.remarks4_238); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_rep_239); sHDOut.Append("|");
sHDOut.Append(myHeader.prov_rp_dt_240); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81a_1_241); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81a_2_242); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81a_3_243); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81b_1_244); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81b_2_245); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81b_3_246); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81c_1_247); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81c_2_248); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81c_3_249); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81d_1_250); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81d_2_251); sHDOut.Append("|");
sHDOut.Append(myHeader.fl81d_3_252); sHDOut.Append("|");
sHDOut.Append(myHeader.poa1_253);
sHDOut.Append(myHeader.poa2_254);
sHDOut.Append(myHeader.poa3_255);
sHDOut.Append(myHeader.poa4_256);
sHDOut.Append(myHeader.poa5_257);
sHDOut.Append(myHeader.poa6_258); sHDOut.Append("|");
sHDOut.Append(myHeader.icn_259); sHDOut.Append("|");
sHDOut.Append(myHeader.bht_260);
fs.WriteLine(sHDOut.ToString());
sHDOut.Clear();
}
// write heder //
//myWriteFile.setString = myCreateFile.getString;
//myWriteFile.write(txtFileOutPut);
//myWriteFile = null;
/////////////// Detail ////////////////////////////////////////////////////////////////////////////
int i = 3;
int j = 1;
String strJ = null;
string strI = null;
//myWriteFile = new writeFile.file();
// myCreateFile.setStringLen = 138;
while (i < 23)
{
if (i > 9)
{
switch (i)
{
case 10:
strI = "a";
break;
case 11:
strI = "b";
break;
case 12:
strI = "c";
break;
case 13:
strI = "d";
break;
case 14:
strI = "e";
break;
case 15:
strI = "f";
break;
case 16:
strI = "g";
break;
case 17:
strI = "h";
break;
case 18:
strI = "i";
break;
case 19:
strI = "j";
break;
case 20:
strI = "k";
break;
case 21:
strI = "l";
break;
case 22:
strI = "M";
break;
}
}
else
{
strI = i.ToString();
}
String REVENUCD = null;
String SERVICID = null;
String SERVIDAT = null;
String SERUNTCO = null;
String CHARGAMT = null;
j = 1;
while (j < 6)
{
if (j == 1)
{
strJ = "";
REVENUCD = "REVENUCD";
SERVICID = "SERVICID";
SERVIDAT = "SERVIDAT";
SERUNTCO = "SERUNTCO";
CHARGAMT = "CHARGAMT";
}
else
{
strJ = j.ToString();
REVENUCD = "REVENUC";
SERVICID = "SERVICI";
SERVIDAT = "SERVIDA";
SERUNTCO = "SERUNTC";
CHARGAMT = "CHARGAM";
}
if (foxDR["V" + strI + REVENUCD + strJ].ToString().Trim() != "0000")
{
myDetail.claim_no_1 = myHeader.claim_no_2.ToString();
myDetail.rev_cd_2 = foxDR["V" + strI + REVENUCD + strJ].ToString(); //falta taba revcode
myDetail.descr_3 = new string(' ', 30);
{
myDetail.hcps_4 = foxDR["V" + strI + SERVICID + strJ].ToString().Trim();
if (myDetail.hcps_4.Trim().Length == 0)
{
myDetail.hcps_4 = new String(' ', 5);
}
else
{
String count = Program.MySqlbusqueda(sqlCnnString,
"select count(*) from tblServiceCodes where serviceCode='" + myDetail.hcps_4.Trim() + "';");
if (count == "0")
{
myDetail.hcps_4 = "99999";
}
}
}
{/////////////////////// mydbMMM.tbtMod //////////////////////////////
if (j == 3)
{
myDetail.hcps_mode1_5 = foxDR["V" + strI + "MODF1" + strJ].ToString().Trim();
}
else
{
myDetail.hcps_mode1_5 = foxDR["V" + strI + "MODIF1" + strJ].ToString().Trim();
}
myDetail.hcpcs_mode2_6 = foxDR["V" + strI + "MODIF2" + strJ].ToString().Trim();
myDetail.hcpcs_mode3_7 = foxDR["V" + strI + "MODIF3" + strJ].ToString().Trim();
myDetail.hcpcs_mode4_8 = foxDR["V" + strI + "MODIF4" + strJ].ToString().Trim();
////////////////////// hcps_mode1_5 /////////////////////////////
if (myDetail.hcps_mode1_5.Trim().Length == 0)
{
myDetail.hcps_mode1_5 = new String(' ', 2);
}
else
{
String count = Program.MySqlbusqueda(sqlCnnString,
"select count(*) from tbtMod where code='" + myDetail.hcps_mode1_5 + "';");
if (count == "0")
{
myDetail.hcps_mode1_5 = "MD";
}
}
////////////////////// hcps_mode2_6 ////////////////////////
if (myDetail.hcpcs_mode2_6.Trim().Length == 0)
{
myDetail.hcpcs_mode2_6 = new String(' ', 2);
}
else
{
String count = Program.MySqlbusqueda(sqlCnnString,
"select count(*) from tbtMod where code='" + myDetail.hcpcs_mode2_6 + "';");
if (count == "0")
{
myDetail.hcpcs_mode2_6 = "MD";
}
}
/////////////// hcps_mode3_7 ///////////////////////////////
if (myDetail.hcpcs_mode3_7.Trim().Length == 0)
{
myDetail.hcpcs_mode3_7 = new string(' ', 2);
}
else
{
String count = Program.MySqlbusqueda(sqlCnnString,
"select count(*) from tbtMod where code='" + myDetail.hcpcs_mode3_7 + "';");
if (count == "0")
{
myDetail.hcpcs_mode3_7 = "MD";
}
}
///////////////// hcps_mode4_8 ///////////////////////////////
if (myDetail.hcpcs_mode4_8.Trim().Length == 0)
{
myDetail.hcpcs_mode4_8 = new String(' ', 2);
}
else
{
String count = Program.MySqlbusqueda(sqlCnnString,
"select count(*) from tbtMod where code='" + myDetail.hcpcs_mode4_8 + "';");
if (count == "0")
{
myDetail.hcpcs_mode4_8 = "MD";
}
}
///////////////////////////////////////////////////////////////////////
}
{
string serv_date_9 = foxDR["V" + strI + SERVIDAT + strJ].ToString().Trim();
if (serv_date_9.Length < 6)
{
// throw new Exception("Error con la fecha V" + strI + "SERVIDAT -->Imagen-->" + Images);
myDetail.serv_date_9 = myHeader.fl_7_19.ToString();
}
if (serv_date_9.Length == 0)
{
myDetail.serv_date_9 = myHeader.fl_7_19.ToString();
}
else
{
try
{
serv_date_9 = "20" + foxDR["V" + strI + SERVIDAT + strJ].ToString().Trim().Substring(4, 2) +
foxDR["V" + strI + SERVIDAT + strJ].ToString().Trim().Substring(0, 2) +
foxDR["V" + strI + SERVIDAT + strJ].ToString().Trim().Substring(2, 2);
}
catch
{
serv_date_9 = myHeader.fl_7_19.ToString();
}
string imgDate = "20" + Images.Substring(4, 2) +
Images.Substring(0, 2) +
Images.Substring(2, 2);
if (Convert.ToInt32(serv_date_9) > Convert.ToInt32(imgDate))
{
myDetail.serv_date_9 = myHeader.fl_7_19.ToString();
}
else
{
try
{
myDetail.serv_date_9 = Program.setFecha(foxDR["V" + strI + SERVIDAT + strJ].ToString(), Images);
}
catch
{
myDetail.serv_date_9 = myHeader.fl_7_19.ToString();
}
}
}
}
{
myDetail.serv_units_10 = foxDR["V" + strI + SERUNTCO + strJ].ToString().Trim();
Int32 serv_units_10 = Convert.ToInt32(myDetail.serv_units_10);
if (serv_units_10 == 0)
{
serv_units_10 = 1 * 10;
}
else
{
serv_units_10 = serv_units_10 * 10;
}
myDetail.serv_units_10 = serv_units_10.ToString("000000000#");
}
{
myDetail.total_chgs_11 = foxDR["V" + strI + CHARGAMT + strJ].ToString();
}
myDetail.noncv_chgs_12 = new string(' ', 13);
myDetail.a49_13 = new string(' ', 6);
using (StreamWriter fs = File.AppendText(file2.Trim()))
{
sHDOut.Clear();
sHDOut.Append(myDetail.claim_no_1); sHDOut.Append("|");
sHDOut.Append(myDetail.rev_cd_2); sHDOut.Append("|" );
sHDOut.Append(myDetail.descr_3); sHDOut.Append("|" );
sHDOut.Append(myDetail.hcps_4); sHDOut.Append("|" );
sHDOut.Append(myDetail.hcps_mode1_5); sHDOut.Append("|" );
sHDOut.Append(myDetail.hcpcs_mode2_6); sHDOut.Append("|" );
sHDOut.Append(myDetail.hcpcs_mode3_7); sHDOut.Append("|" );
sHDOut.Append(myDetail.hcpcs_mode4_8); sHDOut.Append("|" );
sHDOut.Append(myDetail.serv_date_9); sHDOut.Append("|" );
sHDOut.Append(myDetail.serv_units_10); sHDOut.Append("|" );
sHDOut.Append(myDetail.total_chgs_11); sHDOut.Append("|" );
sHDOut.Append(myDetail.noncv_chgs_12); sHDOut.Append("|");
sHDOut.Append(myDetail.a49_13);
fs.WriteLine(sHDOut.ToString().Trim());
//clear
myDetail = null;
myDetail = new detail();
// write Detail
// myWriteFile.setString = myCreateFile.getString;
// myWriteFile.write(file2 + ".dtl");
}
}
j++;
}//end loop while (j <6)
i++;
}// end loop while (i < 23)
}//end loop foreach (System.Data.DataRow foxDR in myTable.Rows)
// myWriteFile = null;
/////////////// Detail ////////////////////////////////////////////////////////////////////////////
//MessageBox.Show("Done...");
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
foxCnn = null;
//foxCmd = null;
}
}
