private void openFileDialog2_FileOk(object sender, CancelEventArgs e)
{
if (openFileDialog2.OpenFile().Length > 31460000)
{
MessageBox.Show("视频大小限制30M");
return;
}
try
{
string name = db.DatebasePIVAsInfo().Split(';')[0].Split('=')[1];
name = Dns.GetHostEntry(name).HostName;
//MessageBox.Show(name);
string source = openFileDialog2.FileName;
string dest = @"\\" + name + "\\Media\\" + DrugCode + ".mp4";
if (File.Exists(dest))
{
DialogResult dr = MessageBox.Show("文件" + dest + "已存在，是否覆盖？", "提示", MessageBoxButtons.OKCancel);
if (dr == DialogResult.OK)
{
File.Delete(dest);
}
else
{
return;
}
}
File.Copy(source, dest);// Dialog2.FileName, "\\ADMIN-PC\\zhangmuyun");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ShowMain(string str)
{
try
{
string WhereStr = string.Empty;
if (str != string.Empty)
{
WhereStr = " WHERE Pro LIKE '%" + str.Trim() + "%' ";
}
Sql = "SELECT ID,Pro,Value,Remark,[Caption],Value2,Value3 FROM [PivasAllSet] " + WhereStr + " order by OrdBy,Pro ";
// dt = db.GetPIVAsDB(Sql).Tables[0];
myDataAdapter = new SqlDataAdapter(Sql, new SqlConnection(db.DatebasePIVAsInfo()));//where Pro!='PassWord'
using (DataTable dt = new DataTable())
{
myDataAdapter.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.Invalidate();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "____" + Sql);
}
}
/// <summary>
/// 画面初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void PivasDWard_Load(object sender, EventArgs e)
{
Pic_Min.Parent = this.panel3;
Panel_Close.Parent = this.panel3;
if (UserID == null || UserID == "")
{
UserID = "00000000000000000000000000000000000000";
}
if (GetPivasLimit.Instance.Limit(UserID, "PivasDWard"))
{
DataSet nm = new DataSet();
label9.Text = "";
DataSet dss = db.GetPIVAsDB("SELECT * FROM [DWard]");
if (dss != null && dss.Tables.Count > 0 && dss.Tables[0].Rows.Count > 0)
{
if (dss.Tables[0].Columns.Contains("Spellcode"))
{
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM [DWard] where Spellcode is null or Spellcode =''", db.DatebasePIVAsInfo());
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["Spellcode"] = GetChineseSpell(dr["WardName"].ToString());
}
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].GetChanges(DataRowState.Modified);
adapter.Update(dt);
}
}
}
else
{
MessageBox.Show("本数据库中没有病区简拼字段");
}
}
isalter = true;
addcontrols();
Load_panel4();
}
else
{
MessageBox.Show("您没有操作权限，请与管理员联系！");
this.Dispose();
}
}
/// <summary>
/// 调用药品控量画面
/// 根据医生或病区设置某药的用药限量，在打印界面进行判断是否达到要求，能否进行打印
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DrugLimitForPrint_Load(object sender, System.EventArgs e)
{
try
{ //设置各控件的默认值：//药品编码 //医生：限药时间间隔//病区：限药时间间隔//医生：确认生效//病区：确认生效//医生：数量//病区：数量//医生：天数//病区：天数
label3.Text = Drugcode;
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
checkBox1.Checked = false;
checkBox2.Checked = false;
textBox1.Text = "1000";
textBox2.Text = "10000";
textBox3.Text = "30";
textBox4.Text = "30";
sda = new SqlDataAdapter(string.Format("SELECT * FROM DrugLimitForPrint where DrugCode='{0}'", Drugcode), db.DatebasePIVAsInfo()); //连接数据库、连接表、执行sql语句
sda.Fill(ds); //执行sql语句得到的结果
//表中是否读取到数据
if (ds != null && ds.Tables.Count > 0)
{
ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] };//第一张表的第一列设为主键
//第一张表的行没有值时，赋予默认值
if (ds.Tables[0].Rows.Count == 0)
{
DataRow dr = ds.Tables[0].NewRow();
dr["DrugCode"] = Drugcode;
ds.Tables[0].Rows.Add(dr);
}
else//将输入的值更新到表中
{
DataRow dr = ds.Tables[0].Rows[0];
int a = 0;
checkBox1.Checked = true.Equals(dr["LimitForDoctor"]);
int.TryParse(dr["IntervalDateForDoctor"].ToString(), out a);
comboBox1.SelectedIndex = a < 3 ? a : 3;// 如果符合a<3，返回值为a，否则返回值为3
textBox1.Text = dr["LimitDgNoForDoctor"].ToString();
textBox3.Text = dr["IntervalDateForDoctor"].ToString();
checkBox2.Checked = true.Equals(dr["LimitForWard"]);
int.TryParse(dr["IntervalDateForWard"].ToString(), out a);
comboBox2.SelectedIndex = a < 3 ? a : 3;
textBox2.Text = dr["LimitDgNoForWard"].ToString();
textBox4.Text = dr["IntervalDateForWard"].ToString();
}
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
