public void Bind()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
Sqlselete ss = new Sqlselete();
DataSet dsa = ss.SelectEmp("");
ListBox1.DataSource = dsa.Tables[0];
ListBox1.DataTextField = "Name";
ListBox1.DataValueField = "Employeeid";
ListBox1.DataBind();
con.Open();
string strSql1 = "select * from Employee where Employeeid in (select UserID from FlowStepPerson where StepID=" + Request.QueryString["stepid"] + ")";
SqlDataAdapter daa = new SqlDataAdapter(strSql1, con);
DataSet dss = new DataSet();
daa.Fill(dss);
this.ListBox2.DataSource = dss.Tables[0];
this.ListBox2.DataTextField = "Name";
this.ListBox2.DataValueField = "Employeeid";
this.ListBox2.DataBind();
con.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string id = this.GridView1.DataKeys[this.GridView1.SelectedIndex]["ID"].ToString();
Sqlselete ss = new Sqlselete();
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
con.Open();
string sql = "update Flow set Name='" + this.flowname.Text + "',TypeID=" + this.flowtype.SelectedItem.Value + ",Des='" + this.flowcontent.Text + "',UserID=" + userid + "where ID=" + id;
SqlCommand com = new SqlCommand(sql, con);
if (com.ExecuteNonQuery() > 0)
{
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
con.Close();
Bind();
}
catch (Exception)
{
Response.Write("<script>alert('登录超时，请重新登录！');window.location.href='../Login.aspx'</script>");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Sqlselete ss = new Sqlselete();
try
{
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
con.Open();
string sql = "insert into Flow values('" + this.flowname.Text + "'," + this.flowtype.SelectedItem.Value + ",'" + this.flowcontent.Text + "',1," + userid + ")";
SqlCommand com = new SqlCommand(sql, con);
if (com.ExecuteNonQuery() > 0)
{
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
con.Close();
Bind();
}
catch (Exception)
{
Response.Write("<script>alert('登录超时，请重新登录！');window.location.href='../Login.aspx'</script>");
}
}
public void Bind()
{
DataSet ds = new Sqlselete().Getds("select * from Flow where IsFix=0");
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (drpFltype.SelectedIndex != 0 && !string.IsNullOrEmpty(drpFlow.SelectedItem.Text))
{
string title = this.txtTitle.Text;
int urgent = Convert.ToInt32(this.drpUrgent.SelectedIndex);
int flowid = Convert.ToInt32(this.drpFlow.SelectedItem.Value);
Sqlselete ss = new Sqlselete();
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
//string FileName = this.FileUpload1.PostedFile.FileName;
string content = this.TextBox2.Text;
string src = "";
if (Request.QueryString["id"] != null)
{
string sql = "update FlowDoc set Title='" + title + "',Content='" + content + "'";
if (OperateDB.ExecuteNonQuery(sql) > 0)
{
Response.Write("<script language=javascript>alert('保存成功！');</script>");
}
else
{
Response.Write("<script language=javascript>alert('保存失败!');</script>");
}
}
else
{
if (!Directory.Exists(Server.MapPath(".") + "\\Files\\"))
{
Directory.CreateDirectory(Server.MapPath(".") + "\\Files\\");
}
if (FileUpload1.PostedFile.ContentLength == 0)
{
src = "";
}
else
{
string strFilePath = FileUpload1.PostedFile.FileName;
FileInfo fl = new FileInfo(strFilePath);
string Ext = fl.Name;
src = Ext;
string ServerPath = Server.MapPath(".");
string strSeraPath = ServerPath + "\\Files\\" + src;
FileUpload1.PostedFile.SaveAs(strSeraPath);
}
string strSql = "insert into FlowDoc values('" + title + "'," + urgent + "," + flowid + ",1," + userid + ",'" + content + "',default,1,0,'" + src + "')";
if (OperateDB.ExecuteNonQuery(strSql) > 0)
{
Response.Write("<script>alert('保存成功！');</script>");
}
else
{
Response.Write("<script>alert('保存失败!');</script>");
}
}
}
}
public string getStep(string id)
{
string step = null;
string sql = "select IsEnd from FlowDoc where ID=" + Convert.ToInt32(id);
Sqlselete ss = new Sqlselete();
int end = Convert.ToInt32(ss.getScalar(sql));
if (end > 0)
{
step = "完成";
}
else
{
string sqlstr = "select * from FlowPath where DocID=" + Convert.ToInt32(id);
DataSet ds = ss.Getds(sqlstr);
//Response.Write("<script>alert('" + dr["IsApprove"].ToString() + "')</script>");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["IsApprove"]) != 2)
{
string sql1 = "select Name from FlowAction where ID in (select ActionId from FlowStep where Num=" + Convert.ToInt32(dr["Num"]) + " and FlowID=" + Convert.ToInt32(dr["FlowID"]) + ")";
step = new Sqlselete().getScalar(sql1).ToString();
break;
}
}
}
return(step);
}
public string getFlow(string id)
{
Sqlselete ss = new Sqlselete();
string sql = "select Name from Flow where ID=" + Convert.ToInt32(id);
string flow = ss.getScalar(sql);
return(flow);
}
public void Bind()
{
Sqlselete ss = new Sqlselete();
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
string sql = "select * from FlowDoc where UserID=" + userid;
DataSet ds = ss.Getds(sql);
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
}
public void Bind()
{
id = Request.QueryString["id"];
DataSet ds = new Sqlselete().Getds("select * from FlowPath where Comment<>'' and DocID=" + id);
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
if (ds.Tables[0].Rows.Count == 0)
{
this.warn.Visible = true;
}
}
protected void btnRefer_Click(object sender, EventArgs e)
{
if (!Directory.Exists(Server.MapPath(".") + "\\ArchivesFiles\\"))
{
Directory.CreateDirectory(Server.MapPath(".") + "\\ArchivesFiles\\");
}
//string FileName = this.FileUpload1.PostedFile.FileName;
string comment = this.txComment.Text.ToString();
string src = "";
if (FileUpload1.PostedFile == null)
{
src = "";
}
else
{
string strFilePath = FileUpload1.PostedFile.FileName;
FileInfo fl = new FileInfo(strFilePath);
string Ext = fl.Name;
//string i = fl.Name;
src = Ext;
string ServerPath = Server.MapPath(".");
string strSeraPath = ServerPath + "\\ArchivesFiles\\" + src;
FileUpload1.PostedFile.SaveAs(strSeraPath);
}
int userid = Convert.ToInt32(new Sqlselete().getScalar("select Employeeid from Employee where username='******'"));
int num = 0;
DataSet dsp = new Sqlselete().Getds("select * from FlowPath");
foreach (DataRow dr in dsp.Tables[0].Rows)
{
if (Convert.ToInt32(dr["DocID"]) == Convert.ToInt32(Request.QueryString["id"]) && Convert.ToInt32(dr["UserID"]) == userid && Convert.ToInt32(dr["IsApprove"]) != 2)
{
num = Convert.ToInt32(dr["Num"]);
break;
}
}
string strSql = "update FlowPath set Comment='" +
comment + "',Atteachment='" + src
+ "',IsApprove=2 where Num=" + num + " and DocID=" + Convert.ToInt32(Request.QueryString["id"]) + " and UserID=" + userid;
if (new Sqlselete().Query(strSql) > 0)
{
Response.Write("<script>alert('提交成功')</script>");
}
upEnd();
}
protected void btnFind_Click(object sender, EventArgs e)
{
if (this.drpType.SelectedItem.Text == "请选择")
{
Bind();
}
else
{
string type = this.drpType.SelectedItem.Value.ToString();
DataSet ds = new Sqlselete().Getds("select * from Flow where IsFix=0 and TypeID=" + type);
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex]["ID"].ToString());
int result = new Sqlselete().Query("delete from Flow where ID=" + id);
if (result > 0)
{
}
else
{
Response.Write("<script language=javascript>alert('删除失败！')</script>");
}
Bind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
this.panel.Visible = true;
this.Button1.Visible = false;
this.Button3.Visible = true;
string id = this.GridView1.DataKeys[this.GridView1.SelectedIndex]["ID"].ToString();
DataSet dsf = new Sqlselete().Getds("select * from Flow where ID=" + id);
foreach (DataRow drf in dsf.Tables[0].Rows)
{
this.txtName.Text = drf["Name"].ToString();
this.drpFlowType.SelectedValue = drf["TypeID"].ToString();
this.txtContent.Text = drf["Des"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.panel.Visible = false;
DataSet ds = new Sqlselete().Getds("select * from FlowType");
foreach (DataRow dr in ds.Tables[0].Rows)
{
this.drpType.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
this.drpFlowType.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString()));
}
this.drpType.Items.Insert(0, "请选择");
Bind();
}
}
public void Bind()
{
int userid = Convert.ToInt32(new Sqlselete().getScalar("select Employeeid from Employee where username='******'"));
string strsql = "select * from FlowDoc where ID in (select DocID from FlowPath where IsApprove<>2 and UserID=" + userid + ")";
DataSet ds = new Sqlselete().Getds(strsql);
DataView dv = ds.Tables[0].DefaultView;
PagedDataSource pds = new PagedDataSource();
AspNetPager1.RecordCount = dv.Count;
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
this.GridView1.DataSource = pds;
this.GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txtName.Text;
int userID = Convert.ToInt32(new Sqlselete().getScalar("select Employeeid from Employee where username='******'"));
string typeID = this.drpFlowType.SelectedItem.Value;
string Des = this.txtContent.Text;
string strsql = "insert into Flow values('" + name + "'," + typeID + ",'" + Des + "',0," + userID + ")";
int result = new Sqlselete().Query(strsql);
if (result > 0)
{
Bind();
}
else
{
Response.Write("<script language=javascript>alert('保存失败！')</script>");
}
}
public void Bind()
{
Sqlselete ss = new Sqlselete();
DataSet dsa = ss.SelectEmp("");
ListBox1.DataSource = dsa.Tables[0];
ListBox1.DataTextField = "Name";
ListBox1.DataValueField = "Employeeid";
ListBox1.DataBind();
string strSql1 = "select * from Employee where Employeeid in (select UserID from FlowStepPerson where StepID=" + Request.QueryString["stepid"] + ")";
this.ListBox2.DataSource = OperateDB.ExecuteDataSet(strSql1).Tables[0];
this.ListBox2.DataTextField = "Name";
this.ListBox2.DataValueField = "Employeeid";
this.ListBox2.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
Sqlselete ss = new Sqlselete();
try
{
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
string sql = "insert into Flow values('" + this.flowname.Text + "'," + this.flowtype.SelectedItem.Value + ",'" + this.flowcontent.Text + "',1," + userid + ")";
if (OperateDB.ExecuteNonQuery(sql) > 0)
{
}
else
{
Response.Write("<script>alert('保存失败！');</script>");
}
Bind();
}
catch (Exception)
{
Response.Write("<script>alert('登录超时，请重新登录！');window.location.href='../Login.aspx'</script>");
}
}
public void upEnd()
{
DataSet ds = new Sqlselete().Getds("select * from FlowPath where DocID=" + Convert.ToInt32(Request.QueryString["id"]));
int approve = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["IsApprove"]) != 2)
{
approve = Convert.ToInt32(dr["IsApprove"]);
break;
}
else
{
approve = Convert.ToInt32(dr["IsApprove"]);
}
}
if (approve == 2)
{
new Sqlselete().Query("update FlowDoc set IsEnd=1 where ID=" + Convert.ToInt32(Request.QueryString["id"]));
}
}
public void Bind()
{
id = Request.QueryString["id"].ToString();
DataSet ds = new Sqlselete().Getds("select * from FlowDoc where ID=" + Convert.ToInt32(Request.QueryString["id"]));
foreach (DataRow dr in ds.Tables[0].Rows)
{
this.lblTitle.Text = dr["Title"].ToString();
this.lblStep.Text = new Sqlselete().getScalar("select Name from Flow where ID=" + Convert.ToInt32(dr["FlowID"])).ToString();
this.lblUrgent.Text = dr["IsUrgent"].ToString().Equals("0") ? "一般" : "重要";
this.lblUser.Text = new Sqlselete().getScalar("select Name from Employee where Employeeid=" + dr["UserID"]).ToString();
this.lblPubDate.Text = dr["PubDate"].ToString();
this.txtcontent.Text = dr["Content"].ToString();
path = dr["Attachment"].ToString();
string[] a;
a = path.Split(';');
string[] AccIDList = { "0" };
for (int i = 0; i < a.Length; i++)
{
//LblAcc.Text += "<a href=\"upfiles/" + "+a[i]+"+ target=\"_blank\">" + a[i] + "</a>" + " " + " ";
this.lblAr.Text += "<a href=\"Files/"
+ a[i]
+ "\" target=\"_blank\">"
+ a[i]
+ "</a>" + " " + " ";
}
}
string sql = "select * from FlowAction where ID in (select ActionID from FlowStep where FlowID in (select FlowID from FlowDoc where ID=" + Convert.ToInt32(Request.QueryString["id"]) + "))";
DataSet dsstep = new Sqlselete().Getds(sql);
string step = null;
foreach (DataRow drs in dsstep.Tables[0].Rows)
{
step += Convert.ToString(drs["Name"]) + "-->";
}
this.lblStep.Text = step + "完成";
}
public void send()
{
int approve = Convert.ToInt32(new Sqlselete().getScalar("select top 1 Num from Path where FlowID=" + Convert.ToInt32(Request.QueryString["flowid"]) + " order by Num desc"));
int userid = Convert.ToInt32(new Sqlselete().getScalar("select Employeeid from Employee where username='******'"));
int num = Convert.ToInt32(new Sqlselete().getScalar("select Num from Path where UserID=" + userid));
DataSet ds = new Sqlselete().Getds("select * from Path where FlowID=" + Convert.ToInt32(Request.QueryString["flowid"]));
int result = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["UserID"]) == userid)
{
string strSql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + Convert.ToInt32(Request.QueryString["id"]) + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
result = new Sqlselete().Query(strSql);
//result = new DBoperate().ExecuteUpdate(strSql);
continue;
}
if (Convert.ToInt32(dr["Num"]) > num)
{
string strsql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + Convert.ToInt32(Request.QueryString["id"]) + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
result = new Sqlselete().Query(strsql);
}
}
//修改FlowDoc表中IsSave字段值
if (result > 0)
{
string strSql = "update FlowDoc set IsSave=0 where FlowID=" + Convert.ToInt32(Request.QueryString["flowid"]);
int rs = new Sqlselete().Query("update FlowDoc set IsSave=0 where FlowID=" + Convert.ToInt32(Request.QueryString["flowid"]));
}
Bind();
}
protected void Button3_Click(object sender, EventArgs e)
{
string id = this.GridView1.DataKeys[this.GridView1.SelectedIndex]["ID"].ToString();
string name = this.txtName.Text;
//int userId = new DBoperate().ExecuteScalar("select Employeeid from Employee where username="******"UserName"]);
int userID = Convert.ToInt32(new Sqlselete().getScalar("select Employeeid from Employee where username='******'"));
string typeID = this.drpFlowType.SelectedItem.Value;
string Des = this.txtContent.Text;
string strsql = "update Flow set Name='" + name + "',TypeID=" + typeID
+ ",Des='" + Des + "',UserID=" + userID + "where ID=" + id;
int result = new Sqlselete().Query(strsql);
if (result > 0)
{
Response.Write("<script language=javascript>alert('修改成功！');</script>");
Bind();
}
else
{
Response.Write("<script language=javascript>alert('保存失败！')</script>");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (drpFltype.SelectedIndex != 0 && !string.IsNullOrEmpty(drpFlow.SelectedItem.Text))
{
//插入申请
string sql;
string title = this.txtTitle.Text;
int urgent = Convert.ToInt32(this.drpUrgent.SelectedIndex);
int flowid = Convert.ToInt32(this.drpFlow.SelectedItem.Value);
Sqlselete ss = new Sqlselete();
int userid = Convert.ToInt32(ss.SelectEmpByUserName(Session["UserName"].ToString()));
//string FileName = this.FileUpload1.PostedFile.FileName;
string content = this.TextBox2.Text.ToString();
string src = "";
if (Request.QueryString["id"] != null)
{
sql = "update FlowDoc set Title='" + title + "',Content='" + content + "',IsSave=0";
if (OperateDB.ExecuteNonQuery(sql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
sql = "select top 1 Num from Path where FlowID=" + Convert.ToInt32(Request.QueryString["id"]) + " order by Num desc";
int approve = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select Num from Path where UserID=" + userid;
int num = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select * from Path where FlowID=" + flowid;
DataSet ds = OperateDB.ExecuteDataSet(sql);
//int result = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["UserID"]) == userid)
{
string strSql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + Convert.ToInt32(Request.QueryString["id"]) + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strSql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
continue;
}
if (Convert.ToInt32(dr["Num"]) > num)
{
string strsql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + Convert.ToInt32(Request.QueryString["id"]) + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strsql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
}
}
}
else
{
if (!Directory.Exists(Server.MapPath(".") + "\\Files\\"))
{
Directory.CreateDirectory(Server.MapPath(".") + "\\Files\\");
}
if (FileUpload1.PostedFile.ContentLength == 0)
{
src = "";
}
else
{
string strFilePath = FileUpload1.PostedFile.FileName;
FileInfo fl = new FileInfo(strFilePath);
string Ext = fl.Name;
src = Ext;
string ServerPath = Server.MapPath(".");
string strSeraPath = ServerPath + "\\Files\\" + src;
FileUpload1.PostedFile.SaveAs(strSeraPath);
}
string strSql1 = "insert into FlowDoc values('" + title + "'," + urgent + "," + flowid + ",1," + userid + ",'" + content + "',default,1,0,'" + src + "')";
if (OperateDB.ExecuteNonQuery(strSql1) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
//插入申请审批路径
sql = "select top 1 ID from FlowDoc order by PubDate desc";
int docid = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select top 1 Num from Path where FlowID=" + flowid + " order by Num desc";
int approve = Convert.ToInt32(OperateDB.getExecuteScalar(sql));
sql = "select Num from Path where UserID=" + userid;
int num = Convert.ToInt32(OperateDB.getExecuteScalar(sql));//序号
sql = "select * from Path where FlowID=" + flowid;
DataSet ds = OperateDB.ExecuteDataSet(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (Convert.ToInt32(dr["UserID"]) == userid)
{
string strSql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + docid + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strSql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
continue;
}
if (Convert.ToInt32(dr["Num"]) > num)
{
string strsql = "insert into FlowPath (DocID,FlowID,StepID,UserID,IsApprove,Num,IsJoin) values(" + docid + "," +
Convert.ToInt32(dr["FlowID"]) + "," + Convert.ToInt32(dr["ID"]) + "," + dr["UserID"].ToString() + "," + (approve - Convert.ToInt32(dr["Num"])) + "," + dr["Num"].ToString() + "," + dr["IsJoin"].ToString() + ")";
if (OperateDB.ExecuteNonQuery(strsql) != 1)
{
Response.Write("<script>alert('发送失败!');</script>");
return;
}
}
}
}
}
}
public void del()
{
int result = new Sqlselete().Query("delete from FlowDoc where ID=" + Request.QueryString["fdid"]);
}
public string getFlow(string id)
{
string flow = new Sqlselete().getScalar("select Name from Flow where ID=" + Convert.ToInt32(id)).ToString();
return(flow);
}
public string getUser(string id)
{
string user = new Sqlselete().getScalar("select Name from Employee where Employeeid=" + Convert.ToInt32(id)).ToString();
return(user);
}