public override void AppendTempBCCSet()
{
SortedList condition = new SortedList();
condition.Add(1, PdCode);
condition.Add(2, "0");
condition.Add(3, _MachineCode);
string testSql = RemoteClient.RemotInterface.CheckSelectData("HCS-workset-tempBCC-sec002", condition);
DataTable data = RemoteClient.RemotInterface.SelectData("HCS-workset-tempBCC-sec002", condition);
if (data != null)
{
foreach (DataRow item in data.Rows)
{
int rowIndex = -1;
string bccCode = Convert.ToString(item["bar_code"]);
if (item.Table.Columns.Contains("bar_code") && item["bar_code"] != null && (BarCodeHelper.IsTempSet(item["bar_code"].ToString()) || BarCodeHelper.IsOrderSet(item["bar_code"].ToString())))
{
rowIndex = DataConverter.ConvertSetData(setDataGrid, item);
}
if (BarCodeHelper.IsOrderSet(bccCode) && item.Table.Columns.Contains("order_type") && setDataGrid.Columns.Contains("setTypeCol") && rowIndex >= 0)
{
setDataGrid.Rows[rowIndex].Cells["setTypeCol"].Value = item["order_type"];
}
}
}
}
public override void InitalizeControl()
{
base.InitalizeControl();
if (string.IsNullOrEmpty(_setBarCode) && SetData == null)
{
MessageBox.Show("初始化器械包信息失败", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
setBarCodeTxt.Text = _setBarCode;
if (SetData == null)
{
SortedList condition = new SortedList();
condition.Add(1, "0");
condition.Add(2, _setBarCode);
string sql = string.Empty;
if (BarCodeHelper.IsOrderSet(_setBarCode))
{
sql = "HCS-orderid-manager-sec004";
//setPriortyTxt.Visible = false;
//setSterilizerTxt.Visible = false;
//setWashingTxt.Visible = false;
//setTypeTxt.Visible = false;
}
else
{
sql = "HCS-work-set-sec004";
}
string testSql = RemoteClient.RemotInterface.CheckSelectData(sql, condition);
DataTable data = RemoteClient.RemotInterface.SelectData(sql, condition);
if (data != null && data.Rows.Count > 0)
{
for (int i = 0; i < data.Rows.Count; i++)
{
if (data.Rows[i]["bar_code"] != null && data.Rows[i]["bar_code"].ToString() == _setBarCode)
{
SetData = data.Rows[i];
break;
}
}
}
}
if (SetData != null)
{
if (SetData.Table.Columns.Contains("ca_name") && SetData["ca_name"] != null)
{
setNameTxt.Text = SetData["ca_name"].ToString();
}
//if (SetData.Table.Columns.Contains("pa_type") && SetData["pa_type"] != null) setTypeTxt.Text = SetData["pa_type"].ToString();
//if (SetData.Table.Columns.Contains("pa_priorty") && SetData["pa_priorty"] != null) setPriortyTxt.Text = SetData["pa_priorty"].ToString();
//if (SetData.Table.Columns.Contains("st_pr_Name") && SetData["st_pr_Name"] != null) setSterilizerTxt.Text = SetData["st_pr_Name"].ToString();
//if (SetData.Table.Columns.Contains("wa_pr_Name") && SetData["wa_pr_Name"] != null) setWashingTxt.Text = SetData["wa_pr_Name"].ToString();
//if (SetData.Table.Columns.Contains("location_name") && SetData["location_name"] != null) userLocationTxt.Text = SetData["location_name"].ToString();
RefreshDataGrid();
}
}
}
public virtual void AppendTempBCCSet()
{
DataGridView setDataGrid = CnasUtilityTools.FindControl <DataGridView>(this, "setDataGrid");
if (setDataGrid != null)
{
string tempBCCs = string.Empty;
for (int i = 0; i < ScanBarCodes.Count; i++)
{
string key = ScanBarCodes.GetKey(i).ToString();
if (key.Contains(":BCC") || key.StartsWith("BCC"))
{
string bccCode = key.Substring(key.IndexOf("BCC"), 13);
if (BarCodeHelper.IsOrderSet(bccCode) || BarCodeHelper.IsTempSet(bccCode))
{
tempBCCs += string.Format("{0},", bccCode);
}
}
}
if (!string.IsNullOrEmpty(tempBCCs))
{
tempBCCs = tempBCCs.TrimEnd(',');
SortedList condition = new SortedList();
tempBCCs = tempBCCs.Replace(",", "','");
condition.Add(1, PdCode);
condition.Add(2, "0");
condition.Add(3, tempBCCs);
string testSql = RemoteClient.RemotInterface.CheckSelectData("HCS-workset-tempBCC-sec001", condition);
DataTable data = RemoteClient.RemotInterface.SelectData("HCS-workset-tempBCC-sec001", condition);
if (data != null)
{
foreach (DataRow item in data.Rows)
{
int rowIndex = -1;
string bccCode = Convert.ToString(item["bar_code"]);
if (item.Table.Columns.Contains("bar_code") && item["bar_code"] != null)
{
rowIndex = DataConverter.ConvertSetData(setDataGrid, item);
}
if (BarCodeHelper.IsOrderSet(bccCode) && item.Table.Columns.Contains("order_type") && setDataGrid.Columns.Contains("setTypeCol") && rowIndex >= 0)
{
setDataGrid.Rows[rowIndex].Cells["setTypeCol"].Value = item["order_type"];
}
}
}
}
}
}
public void RefreshInstrumentSearchGrid()
{
try
{
CnasRemotCall remoteClient = new CnasRemotCall();
DataTable instrumentData = null;
if (Data.ContainsKey("SetCode") && !BarCodeHelper.IsTempSet(Data["SetCode"]))
{
string setCode = Data["SetCode"];
if (!string.IsNullOrEmpty(setCode))
{
bool isBCCS = BarCodeHelper.IsSpecialSet(setCode);
string sql = "HCS-instrument-info-sec007";
SortedList condition = new SortedList();
condition.Add(1, CnasBaseData.SystemID); //CnasBaseData.SystemID
condition.Add(2, setCode);
if (BarCodeHelper.IsSpecialSet(setCode))
{
sql = "HCS-instrument-info-sec002";
}
else if (BarCodeHelper.IsOrderSet(setCode))
{
sql = "HCS-instrument-info-sec008";
}
string testSql = remoteClient.RemotInterface.CheckSelectData(sql, condition);
instrumentData = remoteClient.RemotInterface.SelectData(sql, condition);
}
}
else
{
SortedList condition = new SortedList();
condition.Add(1, CnasBaseData.UserBaseInfo.LocationId);
condition.Add(2, CnasBaseData.SystemID);
string testSql = remoteClient.RemotInterface.CheckSelectData("HCS-instrument-info-sec006", condition);
instrumentData = remoteClient.RemotInterface.SelectData("HCS-instrument-info-sec006", condition);
}
if (instrumentData != null)
{
DataRow[] data = instrumentData.Select(string.Format("ca_name like '%{0}%'", instrumentNameTxt.Text));
if (data.Length > 0)
{
inSearchGrid.Rows.Clear();
foreach (DataRow row in data)
{
int rowIndex = inSearchGrid.Rows.Add();
if (row["id"] != null)
{
inSearchGrid.Rows[rowIndex].Cells["idCol"].Value = Convert.ToString(row["id"]);
}
if (row["ca_name"] != null)
{
inSearchGrid.Rows[rowIndex].Cells["nameCol"].Value = Convert.ToString(row["ca_name"]);
}
//if (row["costc_name"] != null) inSearchGrid.Rows[rowIndex].Cells["costCenterCol"].Value = Convert.ToString(row["costc_name"]);
}
}
}
}
catch (Exception)
{
}
}
