public void LoadShader(string filename, int program, out int address)
{
address = -1;
if (File.Exists(filename))
{
ShaderType type;
switch (Path.GetExtension(filename))
{
case ".vert":
{
type = ShaderType.VertexShader;
};
break;
case ".frag":
{
type = ShaderType.FragmentShader;
};
break;
default:
{
Status = SStatus.Unknown;
return;
};
}
LoadShader(filename, type, program, out address);
}
else
{
Status = SStatus.NotFound;
}
}
public bool RestoreStatus(SStatus status)
{
// 恢复状态
m_listEditedRows = new List <int>(status.listEditedRows.ToArray());
m_listDoDeletedRows = new List <long>(status.listDoDeletes.ToArray());
m_listMaskedDeletedRows = new List <int>(status.listMarkDeleteRows.ToArray());
//this.SuspendLayout();
foreach (int i in status.listMarkDeleteRows)
{
// 标记为删除
base.UpdateRowData(i, new string[]
{
"True",
m_listData[i].StationID.ToString(),
m_listData[i].BGTM.ToString(),
m_listData[i].PTNO.ToString(),
m_listData[i].ZR.ToString("0.00"),
m_listData[i].Q1.ToString("0.000"),
m_listData[i].Q2.ToString("0.000"),
m_listData[i].Q3.ToString("0.000"),
m_listData[i].Q4.ToString("0.000"),
m_listData[i].Q5.ToString("0.000"),
m_listData[i].Q6.ToString("0.000"),
m_listData[i].currQ.ToString("0.000"),
// m_listData[i].RecordId.ToString()
}, EDataState.EDeleted);
}
//this.ResumeLayout(false);
return(true);
}
public static void Insert(string funcionario, string sala, SStatus status, Fila fila)
{
NonQuery($"Erro ao inserir registro em {nameof(Salas)}.", (c) => {
c.CommandText = $"insert into {Name} values (@medico, @sala, @fila, @status);";
c.Parameters.AddWithValue("@medico", funcionario);
c.Parameters.AddWithValue("@sala", sala);
c.Parameters.AddWithValue("@fila", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
return(c);
});
}
public static void InsertOrUpdate(string funcionario, string sala, SStatus status, Fila fila)
{
var r = Select(funcionario);
if (r == null)
{
Insert(funcionario, sala, status, fila);
}
else
{
Update(funcionario, sala, status, fila);
}
}
public static void Update(string funcionario, string sala, SStatus status, Fila fila)
{
NonQuery($"Erro ao atualizar sala.", (c) => {
c.CommandText = $"update {Name} " +
$"set {nameof(Nome)} = @sala, {nameof(_Status)} = @status, {nameof(Funcao)} = @fila " +
$"where {nameof(Funcionario)} = @funcionario;";
c.Parameters.AddWithValue("@funcionario", funcionario);
c.Parameters.AddWithValue("@sala", sala);
c.Parameters.AddWithValue("@fila", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
return(c);
});
}
void ReleaseDesignerOutlets()
{
if (SStatus != null)
{
SStatus.Dispose();
SStatus = null;
}
if (TableColumnSubMax != null)
{
TableColumnSubMax.Dispose();
TableColumnSubMax = null;
}
if (TableColumnSubMin != null)
{
TableColumnSubMin.Dispose();
TableColumnSubMin = null;
}
if (TableColumnSubName != null)
{
TableColumnSubName.Dispose();
TableColumnSubName = null;
}
if (TableColumnSubType != null)
{
TableColumnSubType.Dispose();
TableColumnSubType = null;
}
if (TableView != null)
{
TableView.Dispose();
TableView = null;
}
if (TFLogPath != null)
{
TFLogPath.Dispose();
TFLogPath = null;
}
if (TFDataFileName != null)
{
TFDataFileName.Dispose();
TFDataFileName = null;
}
}
/// <summary>
/// 保存列表状态，此方法要在调用GetAllModifiedData之前，否则都被清空了
/// </summary>
/// <returns></returns>
public bool SaveStatus(out SStatus status)
{
if (this.IsCurrentCellInEditMode)
{
//MessageBox.Show("请完成当前的编辑");
this.EndEdit();
//return false;
}
status = new SStatus();
status.listEditedRows = new List <int>(m_listEditedRows.ToArray());
status.listMarkDeleteRows = new List <int>(m_listMaskedDeletedRows.ToArray());
status.listDoDeletes = new List <long>(m_listDoDeletedRows.ToArray());
return(true);
}
public void LoadShader(string filename, ShaderType type, int program, out int address)
{
address = GL.CreateShader(type);
if (File.Exists(filename))
{
StreamReader Reader = new StreamReader(filename);
GL.ShaderSource(address, Reader.ReadToEnd());
GL.CompileShader(address);
GL.AttachShader(program, address);
Console.WriteLine(GL.GetShaderInfoLog(address));
Reader.Close();
Status = SStatus.OK;
}
else
{
Status = SStatus.NotFound;
}
}
public static string Get(SStatus status)
{
if (status == SStatus.Aguardando)
{
return("Aguardando");
}
else if (status == SStatus.EmAtendimento)
{
return("Em atendimento");
}
else if (status == SStatus.Livre)
{
return("Livre");
}
else if (status == SStatus.Ocupado)
{
return("Ocupado");
}
else
{
throw new NotImplementedException();
}
}
public bool UpdateStatus(SStatus statusObj)
{
bool status = false;
int res;
try
{
res = packXprezObj.UpdateStatus(statusObj.TransactionId, statusObj.Value);
if (res == 1)
{
status = true;
}
else
{
status = false;
}
}
catch
{
status = false;
}
return(status);
}
/// <summary>
/// NomeFuncionario, NomeSala, FuncaoSala, StatusSala
/// </summary>
/// <param name="funcionario">Nome do funcionário</param>
/// <param name="sala">Nome da sala</param>
/// <param name="fila">Função da sala</param>
/// <param name="status">Status da sala</param>
/// <returns></returns>
public static List <_Sala> SelectLike(string funcionario, string sala, Fila fila, SStatus status)
{
var c = new MySqlCommand();
c.CommandText =
$"select " +
$" b.{nameof(Pessoas.Nome)}, " +
$" a.{nameof(Nome)}, " +
$" {nameof(Funcao)}, " +
$" {nameof(_Status)} " +
$"from {Name} as a " +
$"inner join {Pessoas.p.TableName} as b on a.{nameof(Funcionario)} = b.{nameof(Pessoas.CPF)} " +
$"where " +
$" b.{nameof(Pessoas.Nome)} like concat(@nomeF, '%') and " +
$" a.{nameof(Nome)} like concat(@nomeS, '%') and " +
$" a.{nameof(Funcao)} = @funcao and " +
$" a.{nameof(_Status)} = @status;";
c.Parameters.AddWithValue("@nomeF", funcionario);
c.Parameters.AddWithValue("@nomeS", sala);
c.Parameters.AddWithValue("@funcao", ES.f[fila]);
c.Parameters.AddWithValue("@status", Get(status));
var lista = new List <_Sala>();
QueryRLoop("Erro ao obter sala.", c, (r) => {
lista.Add(new _Sala()
{
CPF_Funcionario = funcionario,
Nome_Funcionario = r.GetString(0),
Nome = r.GetString(1),
Funcao = r.GetString(2),
Status = r.GetString(3)
});
});
return(lista);
}
