public sItemModels GetSearchModels(sItemData sItemData, string cuurip)
{
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@iid", int.Parse(sItemData.items["iid"].ToString().TrimEnd())));
dbparamlist.Add(new dbparam("@name", sItemData.items["name"].ToString().TrimEnd()));
Dictionary <string, object> items = new Dictionary <string, object>();
mainRows = new database().checkSelectSql("mssql", "sysstring", "exec web.searchflowform @iid,@name;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(new sItemModels()
{
status = "nodata"
});
}
string note = mainRows.Rows[0]["pnote"].ToString().TrimEnd().Replace("<", "<").Replace(">", ">");
int firIndex = note.IndexOf("body") + 4;
items.Add("subject", $"簽核單：{mainRows.Rows[0]["subject"].ToString().TrimEnd()}");
items.Add("signin", $"簽核時間：{mainRows.Rows[0]["signin"].ToString().TrimEnd()}");
items.Add("note", note.Substring(firIndex + 1, note.LastIndexOf("body") - firIndex));
return(new sItemModels()
{
items = items, status = "istrue"
});
}
public statusModels GetInsertModels(sItemData sItemData, string cuurip)
{
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@iid", int.Parse(sItemData.items["iid"].ToString().TrimEnd())));
dbparamlist.Add(new dbparam("@name", sItemData.items["name"].ToString().TrimEnd()));
mainRows = database.checkSelectSql("mssql", "sysstring", "exec web.searchflowform @iid,@name;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(new statusModels()
{
status = "nodata"
});
}
switch (mainRows.Rows[0]["status"].ToString().TrimEnd())
{
case "0":
case "1":
dbparamlist.Add(new dbparam("@phonesign", "0"));
if (database.checkActiveSql("mssql", "sysstring", "exec web.signinflowform @iid,@name,@phonesign;", dbparamlist) != "istrue")
{
return(new statusModels()
{
status = "error"
});
}
return(new statusModels()
{
status = "istrue"
});
}
return(new statusModels()
{
status = "istrue"
});
}