/// <summary>
/// 下载事件
/// 解压并下载
/// by xlb 2012-12-17
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
DataRow focusRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
if (focusRow == null)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条记录");
return;
}
string QueryStr = "select tempname,tempcontent from CommonnotePrintTemp where tempflow=@tempflow";
SqlParameter[] sps = { new SqlParameter("@tempflow", focusRow["TEMPFLOW"]) };
DbDataReader dbreander = DS_SqlHelper.ExecuteDataReader(QueryStr, sps, CommandType.Text);
while (dbreander.Read())
{
FileStream fstrem = null;
string content = DS_Common.UnzipEmrXml(dbreander["TEMPCONTENT"].ToString());
byte[] bytecontent = Convert.FromBase64String(content);
//MemoryStream ms = new MemoryStream(bytecontent);
SaveFileDialog saveModel = new SaveFileDialog();
saveModel.Title = "下载到本地文件";
//saveModel.Filter = "模板文件(*.xrp)|*.xrp";
saveModel.FileName = dbreander["TEMPNAME"].ToString();
if (saveModel.ShowDialog() == DialogResult.OK)
{
FileInfo fileinfo = new FileInfo(saveModel.FileName);
fstrem = fileinfo.OpenWrite();
fstrem.Write(bytecontent, 0, bytecontent.Length);
fstrem.Close();
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("下载成功");
}
}
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 保存方法
/// 新增或修改
/// EditState.Add:新增,EditState.Edit:修改
/// by xlb 2012-12-27
/// </summary>
private void Save()
{
try
{
DataTable dt = DS_SqlHelper.ExecuteDataTable("select name from users where id=@ID", new SqlParameter[] { new SqlParameter("ID", m_app.User.Id) }, CommandType.Text);
if (dt == null || dt.Rows.Count <= 0)
{
return;
}
string dtRowsToStringTrim = dt.Rows[0]["NAME"].ToString().Trim();
if (m_State == EditState.Add)
{
if (txtSearch.Text.Trim() == null || txtSearch.Text.Trim().Length <= 0 && ofDialog.FileName.Length <= 0)
{
btnSearch.Focus();
MessageBox.Show("请选择上传文件");
return;
}
string sqlcompare = "select tempname from CommonnotePrintTemp where tempname like @tempname||'%' and valide='1'";
string temptext = txtTempName.Text.Trim().Substring(0, txtTempName.Text.Trim().IndexOf(".") + 1);
SqlParameter[] spr = { new SqlParameter("@tempname", temptext) };
DbDataReader dbr = DS_SqlHelper.ExecuteDataReader(sqlcompare, spr, CommandType.Text);
if (dbr.Read())
{
txtTempName.Focus();
MessageBox.Show("该文件名已存在");
return;
}
string btyetostr = ToStream(ofDialog.FileName);
string nowTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string stradd = @" insert into CommonnotePrintTemp (tempflow,tempname,tempcontent,tempdesc,createdatetime,createuserid,createusername,valide,modifydatetime)
values(@tempflow,@tempname,@tempcontent,@tempdesc,@createdatetime,@createuserid,@createusername,@valide,@modifydatetime) ";
SqlParameter[] sps = { new SqlParameter("@tempflow", Guid.NewGuid().ToString()),
new SqlParameter("@tempname", txtTempName.Text.Trim()),
new SqlParameter("@tempcontent", SqlDbType.Text),
new SqlParameter("@tempdesc", txtDesc.Text.Trim()),
new SqlParameter("@createdatetime", nowTime),
new SqlParameter("@createuserid", m_app.User.Id),
new SqlParameter("@createusername", dtRowsToStringTrim),
new SqlParameter("@valide", "1"),
new SqlParameter("@modifydatetime", nowTime) };
sps[2].Value = btyetostr;
DS_SqlHelper.ExecuteNonQuery(stradd, sps, CommandType.Text);
MessageBox.Show("添加成功");
}
else if (m_State == EditState.Edit)
{
string strupdate = "update CommonnotePrintTemp set tempcontent=@tempcontent,tempdesc=@tempdesc,modifydatetime=@modifydatetime,createuserid=@createuserid,createusername=@createusername where tempflow=@tempflow";
SqlParameter[] sps =
{
new SqlParameter("@tempcontent", SqlDbType.Text),
new SqlParameter("@tempdesc", txtDesc.Text.Trim()),
new SqlParameter("@modifydatetime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
new SqlParameter("@createuserid", m_app.User.Id),
new SqlParameter("@createusername", dtRowsToStringTrim),
new SqlParameter("@tempflow", dataRowFile["TEMPFLOW"] == null?"":dataRowFile["TEMPFLOW"].ToString())
};
if (txtSearch.Text.Trim() != null && txtSearch.Text.Trim().Length > 0 && ofDialog.FileName.Length > 0)
{
string btyetostr = ToStream(ofDialog.FileName);
sps[0].Value = btyetostr;
}
else
{
SqlParameter[] spr = { new SqlParameter("@tempflow", dataRowFile["TEMPFLOW"] == null ? "" : dataRowFile["TEMPFLOW"].ToString()) };
string content = DS_SqlHelper.ExecuteDataTable("select tempcontent from CommonnotePrintTemp where tempflow=@tempflow", spr, CommandType.Text).Rows[0]["TEMPCoNTENT"].ToString();
sps[0].Value = content;
}
DS_SqlHelper.ExecuteNonQuery(strupdate, sps, CommandType.Text);
MessageBox.Show("修改成功");
}
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
throw ex;
}
}
