public static int update(PackageInfo pack)
{
string sql = "update PackageInfo set packagename=?,packagepath=?,packtime=?,testtime=?,publishtime=?,moduleid=?,state=?,managerid=? where id=?";
OleDbParameter[] parameters = new OleDbParameter[9];
parameters[0] = new OleDbParameter("@packagename", OleDbType.VarChar, 255);
parameters[0].Value = pack.Packagename;
parameters[1] = new OleDbParameter("@packagepath", OleDbType.VarChar, 255);
parameters[1].Value = pack.Packagepath;
parameters[2] = new OleDbParameter("@packtime", OleDbType.VarChar, 255);
parameters[2].Value = pack.Packtime;
parameters[3] = new OleDbParameter("@testtime", OleDbType.VarChar, 255);
parameters[3].Value = pack.Testtime;
parameters[4] = new OleDbParameter("@publishtime", OleDbType.VarChar, 255);
parameters[4].Value = pack.Publishtime;
parameters[5] = new OleDbParameter("@moduleid", OleDbType.Integer);
parameters[5].Value = pack.Moduleid;
parameters[6] = new OleDbParameter("@state", OleDbType.VarChar, 255);
parameters[6].Value = pack.State;
parameters[7] = new OleDbParameter("@managerid", OleDbType.Integer);
parameters[7].Value = pack.Managerid;
parameters[8] = new OleDbParameter("@id", OleDbType.VarChar, 255);
parameters[8].Value = pack.Id;
return(AccessDBUtil.ExecuteNonQuery(sql, parameters));
}
public static int insert(PackageInfo pack)
{
string sql = "insert into PackageInfo(packagename,packagepath,packtime,testtime,publishtime,moduleid,state,managerid)" +
"values(@packagename,@packagepath,@packtime,@testtime,@publishtime,@moduleid,@state,@managerid);";
OleDbParameter[] parameters = new OleDbParameter[8];
parameters[0] = new OleDbParameter("@packagename", OleDbType.VarChar, 255);
parameters[0].Value = pack.Packagename;
parameters[1] = new OleDbParameter("@packagepath", OleDbType.VarChar, 255);
parameters[1].Value = pack.Packagepath;
parameters[2] = new OleDbParameter("@packtime", OleDbType.VarChar, 255);
parameters[2].Value = pack.Packtime;
parameters[3] = new OleDbParameter("@testtime", OleDbType.VarChar, 255);
parameters[3].Value = null;
parameters[3].IsNullable = true;
parameters[4] = new OleDbParameter("@publishtime", OleDbType.VarChar, 255);
parameters[4].Value = pack.Publishtime;
parameters[5] = new OleDbParameter("@moduleid", OleDbType.Integer);
parameters[5].Value = pack.Moduleid;
parameters[6] = new OleDbParameter("@state", OleDbType.VarChar, 255);
parameters[6].Value = pack.State;
parameters[7] = new OleDbParameter("@managerid", OleDbType.Integer);
parameters[7].Value = pack.Managerid;
return(AccessDBUtil.ExecuteNonQuery(sql, parameters));
}
static public List <PackageInfo> getAllPackageInfo()
{
string sql = "select * from packageinfo";
DataSet data = AccessDBUtil.ExecuteQuery(sql, null);
List <PackageInfo> ls = new List <PackageInfo>();
foreach (DataRow row in data.Tables["ds"].Rows)
{
ls.Add(Row2PackageInfo(row));
}
return(ls);
}
/// <summary>
/// 取得身高体重资料
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetBaseInfo(string strWhere, string conn)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM BaseInfo WHERE Mark='Y' ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
return(AccessDBUtil.ExecuteQuery(builder.ToString(), conn));
}
/// <summary>
/// 取得B超资料
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetTypeBList(string strWhere, string conn)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM PatientInfo WHERE jczt = '是' AND sfzh <> '' ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
return(AccessDBUtil.ExecuteQuery(builder.ToString(), conn));
}
/// <summary>
/// 取得血球资料
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetBloodCorpuscleList(string strWhere, string conn)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM PersonInfoXQ WHERE Mark='Y' ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
return(AccessDBUtil.ExecuteQuery(builder.ToString(), conn));
}
/// <summary>
/// 取得视力资料
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetVsiual(string strWhere, string conn)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM VisionInfo WHERE 1=1 ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
return(AccessDBUtil.ExecuteQuery(builder.ToString(), conn));
}
/// <summary>
/// 取得重庆B超资料
/// </summary>
/// <param name="strWhere"></param>
/// <param name="conn"></param>
/// <returns></returns>
public DataSet GetTypeBByChongQing(string strWhere, string conn)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT * FROM PersonInfoBC WHERE 1=1 ");
if (strWhere.Trim() != "")
{
builder.Append(strWhere);
}
return(AccessDBUtil.ExecuteQuery(builder.ToString(), conn));
}
/// <summary>
/// 取得Table是否存在
/// </summary>
/// <param name="tableName"></param>
/// <param name="conn"></param>
/// <returns></returns>
public bool GetTables(string tableName, string conn)
{
return(AccessDBUtil.GetTables(tableName, conn));
}
/// <summary>
/// 共享文件方式更新数据
/// </summary>
public void DataGet()
{
try
{
btnDataUpload.Enabled = false;
labCountnum.Text = "数据统计中，请稍后...";
labUploadnum.Text = "0";
Application.DoEvents();
// 如果为共享的方式同步
if (uploadType.Equals("Share"))
{
//判断数据库是否连接
bool flag = TestConnection();
if (!flag)
{
MessageBox.Show("数据库连接失败！", "提示！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
btnDataUpload.Enabled = true;
Application.DoEvents();
return;
}
}
lock (obj)
{
btnDataUpload.Enabled = true;
string dTime = "", selectInfo = "";
if (this.ckbCheckDate.Checked)
{
startDate = this.dtpStart.Value.Date.ToString("yyyy-MM-dd 00:00:00");
endDate = this.dtpEnd.Value.Date.ToString("yyyy-MM-dd 23:59:59");
dTime = string.Format(" AND TestTime BETWEEN #{0}# AND #{1}# ", startDate, endDate);
}
selectInfo = "SELECT * FROM PersonInfoSH WHERE Mark='Y' " + dTime;
progressBar1.Visible = true;
progressBar1.Minimum = 0;
progressBar1.BackColor = Color.Green;
// 如果为共享的方式同步
if (uploadType.Equals("Share"))
{
DataSet personInfo = AccessDBUtil.ExecuteQuery(selectInfo);
if (personInfo != null)
{
DataTable dtInfo = personInfo.Tables[0];
progressBar1.Maximum = dtInfo.Rows.Count;
labCountnum.Text = dtInfo.Rows.Count.ToString();
int amount = DataUpload(dtInfo);
labUploadnum.Text = amount.ToString();
progressBar1.Value = amount;
MessageBox.Show("成功匹配：" + amount + "条数据！", "提示");
progressBar1.Visible = false;
Application.DoEvents();
}
}
else
{
DataUpload();
}
}
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
throw;
}
}
