/// <summary>
/// Constructor
/// </summary>
/// <param name="f">database file object</param>
public TreeNodeFile(DataBase.File f, TreeViewCatalog tvc)
: base(f.Name, f, false, false, "GenericFile", f.Size, f.Date, true, false, false, false, false)
{
this.file = f;
if (f.Attributes == 1)
{
this.ImageIndex = TreeImages.Folder;
this.SelectedImageIndex = TreeImages.FolderOpen;
this.typeName = "Folder";
this.size = -1;
}
else
{
int pos = f.Name.LastIndexOf(".");
string ext = "";
if (pos >= 0)
{
ext = f.Name.Substring(pos);
}
this.ImageIndex = tvc.FileIcons.GetFileIconId(ext);
this.SelectedImageIndex = this.ImageIndex;
this.typeName = "File";
}
}
/* public static Toon LoadDataBlob(byte[] p) {
return Serializer.DeserializeWithLengthPrefix<Toon>(new MemoryStream(p), PrefixStyle.Base128);
}*/
internal static Toon LoadDataBlob(DataBase.AccountDBDataSet.charactersRow row)
{
Toon t = Serializer.DeserializeWithLengthPrefix<Toon>(new MemoryStream(row.serialized_data), PrefixStyle.Base128);
t.Serial = row.toonid;
t.Name = row.name;
return t;
}
/// <summary>
/// 添加评论确定按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void submit_Click(object sender, EventArgs e)
{
DataBase db = new DataBase();
CommentEntity ce = new CommentEntity();
ce.Agree = 0;
ce.nid = int.Parse(Request.QueryString["nid"].ToString());
ce.DisAgree = 0;
ce.CommentTitle = "";
ce.ConText = tb_comment.Text;
ce.uid = int.Parse(Session["uid"].ToString());
ce.UpTime = DateTime.Now;
if (ce.ConText == "")
{
Response.Write("请填写评论内容！");
return;
}
if (CommentOperation.AddComment(ce))
{
Response.Redirect("LoadComment.aspx?nid=" + ce.nid );
return;
}
else
{
Response.Write("添加评论失败");
}
}
public static void EditAnnouncement(int ID,String amtitle, String essay)
{
/*更新公告*/
DataBase db = new DataBase();
String sql = "UPDATE tb_announcement SET amtitle='" + amtitle + "',essay='" + essay + "' where id=" + ID.ToString();
db.ExCommandNoBack(sql);
}
public NickServ(ServicesDaemon Base)
: base(Base)
{
NickDB = new DataBase();
AddRequired("Help.dll");
}
public static void EditNote(string NoteName, int ID)
{
/*注释的修改*/
DataBase db = new DataBase();
string sql = "UPDATE tb_project SET projectName ='" + NoteName + "'where id=" + ID.ToString();
db.ExCommandNoBack(sql);
}
/// <summary>
/// 点击修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnEdit_Click(object sender, EventArgs e)
{
Validate();
if (!Page.IsValid)
{
//如果页面验证没通过则返回
return;
}
/*实例化一个数据库*/
DataBase db1 = new DataBase();
/*获取用户ID*/
string ID = Session["uid"].ToString();
string PassWord = tb_PassWord.Text;
String str = Encrypt.encrypt(PassWord);
string sql = "UPDATE tb_user SET password ='******' where id=" + ID.ToString();
try
{
db1.ExCommandNoBack(sql);
}
catch
{
/*修改成功，页面跳出提示*/
SmallScript.MessageBox(Page, "修改失败！");
return;
}
/*修改失败，页面跳出提示*/
SmallScript.MessageBox(Page, "修改密码成功。");
return;
}
public static void EditProject(string ProjectName, string description, int type,int ID)
{
/*工程的修改*/
DataBase db = new DataBase();
string sql = "UPDATE tb_project SET projectName ='" + ProjectName + "',description ='" + description + "',Tid = "+ type +" where id=" + ID.ToString();
db.ExCommandNoBack(sql);
}
public static void DelProject(String id)
{
/*删除工程*/
DataBase db = new DataBase();
string sql = "delete from dbo.tb_project where id=" + id + "";
db.ExCommandNoBack(sql);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//判断是否存在该id的工程
int id = int.Parse(Request.QueryString["id"].ToString());
ProjectEntity pe = ProjectOperation.GetProject(int.Parse(Request.QueryString["id"].ToString()));
if (pe == null)
{
SmallScript.MessageBox(Page, "不存在该工程！点击返回！");
SmallScript.GoBack(Page);
return;
}
else
{
//在表单中显示数据
DataBase db = new DataBase();
DataSet sql = db.ExCommand(string.Format("SELECT tb_project.tid, tb_project.uid, tb_user.userName, "
+ "tb_project.description, tb_project.upTime, "
+ "tb_project.projectName, tb_type.typeName, tb_project.id FROM tb_project INNER "
+ "JOIN tb_type ON tb_project.tid = tb_type.id INNER JOIN tb_user ON tb_project.uid = tb_user.id WHERE (tb_project.id ={0} ) ",id));
string User= sql.Tables[0].Rows[0][2].ToString();
string Type = sql.Tables[0].Rows[0][0].ToString();
tb_ProjectName.Text = pe.ProjectName;
lb_User.Text = User;
db_Type.SelectedIndex =int.Parse(Type);
tb_description.Text = pe.Description;
lb_UpTime.Text = pe.UpTime.ToString();
lb_ID.Text = pe.Id.ToString();
}
}
}
/// <summary>
/// Page_Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//判断是否存在该id的公告
int id = int.Parse(Request.QueryString["id"].ToString());
AnnouncementEntity ae = AnnouncementOperation.GetAM(int.Parse(Request.QueryString["id"].ToString()));
if (ae == null)
{
SmallScript.MessageBox(Page, "不存在该公告！点击返回！");
SmallScript.GoBack(Page);
return;
}
else
{
//在表单中显示数据
DataBase db = new DataBase();
DataSet sql = db.ExCommand(string.Format("SELECT tb_announcement.id, tb_announcement.uid, tb_announcement.amtitle, tb_announcement.essay, tb_announcement.uptime, tb_user.userName FROM tb_announcement INNER JOIN tb_user ON tb_announcement.uid = tb_user.id WHERE (tb_announcement.id ={0} )", id));
string User = sql.Tables[0].Rows[0]["userName"].ToString();
lb_ID.Text = ae.Id.ToString();
tb_amtitle.Text = ae.AmTitle;
lb_User.Text = User;
lb_essay.Text = ae.Essay;
lb_UpTime.Text =ae.Time.ToString();
}
}
}
public string[] createSalaryValue(string Value)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
Sqlconn.Open();
string sql = "INSERT INTO PointValue (PointValue, CreateFileBy, CreateFileDate) " +
"VALUES(@PointValue, @CreateFileBy, (getDate()))";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@PointValue", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(Value);
cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message;
}
}
return returnValue;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = int.Parse(Request.QueryString["id"].ToString());
ProjectEntity pe = ProjectOperation.GetProject(int.Parse(Request.QueryString["id"].ToString()));
if (pe != null)
{
DataBase db = new DataBase();
DataSet sql = db.ExCommand(string.Format("SELECT tb_project.tid, tb_project.uid, tb_user.userName, "
+ "tb_project.description, tb_project.upTime, "
+ "tb_project.projectName, tb_type.typeName, tb_project.id FROM tb_project INNER "
+ "JOIN tb_type ON tb_project.tid = tb_type.id INNER JOIN tb_user ON tb_project.uid = tb_user.id WHERE (tb_project.id ={0} ) ", id));
string User = sql.Tables[0].Rows[0]["userName"].ToString();
string Type = sql.Tables[0].Rows[0]["typeName"].ToString();
//在表单中显示数据
lb_ProjectName.Text = pe.ProjectName;
lb_Id.Text = pe.Id.ToString();
lb_description.Text = pe.Description;
lb_User.Text = User;
lb_UpTime.Text = pe.UpTime.ToString();
lb_Type.Text = Type;
}
}
}
/// <summary>
/// 添加按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void A_Button1_Click(object sender, EventArgs e)
{
this.Validate();
if (!IsValid)
{
return;
}
DataBase db = new DataBase();
//从表单中取出数据
string userName = tb_UserName.Text;
string password = Encrypt.encrypt(tb_Password.Text);
string email = tb_Email.Text;
bool isAdmin = cb_IsAdmin.Checked;
//新增用户的数据库操作
if (UserOperation.Reg(userName, password, email, "", true, isAdmin, DateTime.Now))
{
//添加成功后显示
SmallScript.MessageBox(Page, "添加用户成功。"+isAdmin);
return;
}
else
{
//失败后显示信息
SmallScript.MessageBox(Page, "添加用户失败。");
return;
}
}
public string[] createAidsBrandList(CreateAidsBrand structValue)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
Sqlconn.Open();
string sql = "INSERT INTO AidsBrandTable (Category, Brand, CreateFileBy, CreateFileDate, UpFileBy , UpFileDate) " +
"VALUES(@Category, @Brand, @CreateFileBy, getDate(), @UpFileBy, getDate() )";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@Category", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(structValue.brandType);
cmd.Parameters.Add("@Brand", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(structValue.brandName);
cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message;
}
}
return returnValue;
}
public override string buildInsertQuery( String table, DataBase.TraceEntities.TraceEntityCollection fields, String[] values )
{
StringBuilder stringBuilderFields = new StringBuilder();
StringBuilder stringBuilderValues = new StringBuilder();
String queryString = "INSERT INTO {0} ({1}) values ({2})";
// fields preparation
if( fields != null )
{
foreach( TraceEntity field in fields )
stringBuilderFields.AppendFormat( "{0}, ", field.Field );
stringBuilderFields.Remove( stringBuilderFields.Length - 2, 2 ); // suppression des derniers ', '
}
// values preparation
if( values != null )
{
for( int i = 0; i < values.Length; i++ )
{
if( fields.Count >= values.Length )
{
String convertedValue = getConvertedValue( values[i], fields[i].DataType, fields[i].MaxLengthNumeric );
stringBuilderValues.AppendFormat( "{0}, ", convertedValue );
}
else
stringBuilderValues.AppendFormat( "{0}, ", values[i] );
}
stringBuilderValues.Remove( stringBuilderValues.Length - 2, 2 ); // suppression des derniers ', '
}
// build the query
return string.Format( queryString, table, stringBuilderFields.ToString(), stringBuilderValues.ToString() );
}
//添加考试科目事件
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
Course course = new Course(); //创建考试科目对象
//start:胡媛媛修改,去掉考试科目输入框两边的空格,加trim(),2010-4-29
course.Name = txtName.Text.Trim(); //设置考试科目对象属性
//程军添加，添加考试科目，名称不能相同。2010-4-25
DataBase db = new DataBase();
string mySql = "select * from Course where Name ='" + txtName.Text.Trim() + "'";
//end:胡媛媛修改,去掉考试科目输入框两边的空格,加trim(),2010-4-29
if (db.GetRecord(mySql))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('课程章节重复!')</script>");
this.txtName.Focus();
}
else
{
if (course.InsertByProc()) //调用添加考试科目方法添加考试科目
{
lblMessage.Text = "成功添加该章节科目！";
}
else
{
lblMessage.Text = "添加该章节失败！";
}
}
//程军添加，添加考试科目，名称不能相同。2010-4-25
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
Validate();
if (!Page.IsValid)
{
SmallScript.MessageBox(Page, "修改失败！"); /*修改失败，页面跳出提示*/
/*如果页面验证没通过则返回*/
return;
}
else
{
DataBase db1 = new DataBase(); /*实例化一个数据库*/
string ID = Session["uid"].ToString(); /*获取用户ID*/
/*获取用户填写信息*/
bool Sex = (rb_Sex.SelectedIndex == 0);
string Email = tb_Email.Text;
string QQ = tb_QQ.Text;
/*执行数据库更新语句*/
/*将修改好的个人资料录入数据库*/
string sql = "UPDATE tb_user SET email ='" + Email + "', sex =" + (Sex ? 1 : 0).ToString() + ", qq ='" + QQ + "' where id=" + ID.ToString();
try
{
db1.ExCommandNoBack(sql);
}
catch
{
SmallScript.MessageBox(Page, "修改失败！"); /*修改失败，页面跳出提示*/
return;
}
SmallScript.MessageBox(Page, "修改用户成功。"); /*修改成功，页面跳出提示*/
return;
}
}
protected void GridViewVillages_SelectedIndexChanging(object sender,
GridViewSelectEventArgs e)
{
GridViewRow row = GridViewVillages.Rows[e.NewSelectedIndex];
int villageId = Misc.String2Number(row.Cells[0].Text.Trim());
PanelStats.Visible = true;
TotalStats.Visible = true;
string srcTable = "Goods";
DataBase dataBase = new DataBase();
DataSet dataSet = dataBase.GetGoods(srcTable, villageId);
DataRow dataRow = dataSet.Tables[srcTable].Rows[0];
string inputWood = dataRow.ItemArray[0].ToString();
string inputClay = dataRow.ItemArray[1].ToString();
string inputIron = dataRow.ItemArray[2].ToString();
string inputCrop = dataRow.ItemArray[3].ToString();
string inputVillageName = dataRow.ItemArray[4].ToString();
LabelGoodsWood.Text = inputWood;
LabelGoodsClay.Text = inputClay;
LabelGoodsIron.Text = inputIron;
LabelGoodsCrop.Text = inputCrop;
int wood = Misc.String2Number(inputWood);
int clay = Misc.String2Number(inputClay);
int iron = Misc.String2Number(inputIron);
int crop = Misc.String2Number(inputIron);
int total = wood + clay + iron + crop;
LabelGoodsTotal.Text = total.ToString();
LabelVillageName.Text = inputVillageName;
srcTable = "Reports";
dataBase = new DataBase();
dataSet = dataBase.GetLast5Reports(srcTable, villageId);
RepeaterReports.DataSource = dataSet;
RepeaterReports.DataMember = srcTable;
RepeaterReports.DataBind();
}
protected void LinkButtonAddUser_Click(object sender, EventArgs e)
{
Log.Debug("Add user");
labelManageUsersBodyInputStatus.Text = "";
string username = textBoxManageUsersBodyInputUserName.Text.Trim();
if (username.Length < 3)
{
labelManageUsersBodyInputStatus.Text = statusWrongUsername;
Log.Warn(statusWrongUsername);
return;
}
string password = textBoxManageUsersBodyInputPassword.Text.Trim();
if (password.Length < 3)
{
labelManageUsersBodyInputStatus.Text = statusWrongPassword;
Log.Warn(statusWrongPassword);
return;
}
User user = new User {Name = username, Password = Misc.ConvertToSha1(password), Level = 2};
DataBase dataBase = new DataBase();
if (dataBase.InsertUser(user))
{
PopulateUsers();
labelManageUsersBodyInputStatus.Text = "";
}
else
{
labelManageUsersBodyInputStatus.Text = statusFailedToAddUser;
Log.Warn(statusFailedToAddUser);
}
}
/// <summary>
/// Page_Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
/*实例化一个数据库*/
DataBase db = new DataBase();
/* 统计现有代码数 */
DataSet rs2 = db.ExCommand("SELECT COUNT(*) FROM tb_code");
string intNum2 = rs2.Tables[0].Rows[0][0].ToString();
code_num.Text = intNum2;
/* 统计现有注释数 */
DataSet rs3 = db.ExCommand("SELECT COUNT(*) FROM tb_note");
string intNum3 = rs3.Tables[0].Rows[0][0].ToString();
note_num.Text = intNum3;
/* 统计现有评论数 */
DataSet rs1 = db.ExCommand("SELECT COUNT(*) FROM tb_comment");
string intNum1 = rs1.Tables[0].Rows[0][0].ToString();
comment_num.Text = intNum1;
/* 统计现有会员数 */
DataSet rs = db.ExCommand("SELECT COUNT(*) FROM tb_user");
string intNum = rs.Tables[0].Rows[0][0].ToString();
user_num.Text = intNum;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["uid"] == null)
{
Response.Write("请登录后再填写注释。");
return;
}
DataBase db = new DataBase();
NoteEntity ne = new NoteEntity();
ne.Agree = 0;
ne.Cid = int.Parse(Request.QueryString["cid"].ToString());
ne.Disagree = 0;
ne.EndLine = int.Parse(Request.QueryString["endline"].ToString());
ne.NoteName = "";
ne.StartLine = int.Parse(Request.QueryString["startline"].ToString());
ne.Context = Request.QueryString["context"].ToString();
ne.Uid = int.Parse(Session["uid"].ToString());
ne.UpTime = DateTime.Now;
if (NoteOperation.AddNote(ne))
{
Response.Write("注释添加成功。点击确定，关闭本窗口。");
return;
}
else
{
Response.Write("添加注释失败");
}
}
protected void Bind(string keyWord)
{
DataBase DB = new DataBase();
Hashtable ht1 = new Hashtable();
ht1.Add("Title", keyWord);
ht1.Add("AnswerA", keyWord);
ht1.Add("AnswerB", keyWord);
ht1.Add("AnswerC", keyWord);
ht1.Add("AnswerD", keyWord);
DataSet ds1 = DB.AdvancedSearch("SingleProblem", ht1);
if (ds1.Tables[0].Rows.Count > 0)//判断下是否有单选题
{
GridView11.DataSource = ds1;
GridView11.DataBind();
}
DataSet ds2 = DB.AdvancedSearch("MultiProblem", ht1);
if (ds2.Tables[0].Rows.Count > 0)
{
GridView2.DataSource = ds2;
GridView2.DataBind();
}
Hashtable ht2 = new Hashtable();
ht2.Add("Title", keyWord);
DataSet ds3 = DB.AdvancedSearch("JudgeProblem", ht2);
if (ds3.Tables[0].Rows.Count > 0)
{
GridView3.DataSource = ds3;
GridView3.DataBind();
}
}
public DataBase Build()
{
var tmp = new DataBase();
switch (Connection.DBType)
{
case DataBaseType.NONE:
break;
case DataBaseType.MSSQL:
tmp = new MsSqlReader(Connection).Read();
break;
case DataBaseType.MYSQL:
break;
case DataBaseType.ORICAL:
break;
case DataBaseType.SQLCE:
tmp = new SqlCeReader(Connection).Read();
break;
case DataBaseType.ACCESS:
break;
case DataBaseType.SQLITE:
break;
default:
throw new ArgumentOutOfRangeException();
}
return tmp;
}
protected void loadVideos()
{
DataBase db = new DataBase();
SqlConnection conn = db.Connection();
SqlCommand cmd = db.GetCommand(conn, "dbo.GetVideos");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
conn.Open();
da.Fill(ds, "Videos");
}
catch (Exception err)
{
lblError.Text = err.Message;
}
finally
{
conn.Close();
conn.Dispose();
}
if (ds.Tables["Videos"].Rows.Count == 0)
{
lblError.Text = "Нема внесено видеа во базата!";
return;
}
ViewState["dsVideos"] = ds;
gvVideos.DataSource = ds.Tables["Videos"];
gvVideos.DataBind();
}
/// <summary>
/// 添加顶操作
/// </summary>
/// <param name="de">顶的实例</param>
/// <returns>添加成功返回true 失败返回false</returns>
public static bool AddDing(DingEntity de)
{
DataBase db = new DataBase();
try
{
string sql = string.Format("INSERT INTO tb_Ding (nid,uid,isDing) VALUES ( '{0}', '{1}','{2}')", de.Nid, de.Uid, de.isDing);
db.ExCommandNoBack(sql);
DataSet rs = db.RunProcReturn("select * from tb_Ding where nid=" + de.Nid + "and uid=" + de.Uid, "tb_Ding");
int ID = int.Parse(rs.Tables[0].Rows[0]["id"].ToString());
if (rs.Tables[0].Rows.Count == 1)
{
return true;
}
else
{
string sql3 = "delete from dbo.tb_Ding where id=" + ID + "";
db.ExCommandNoBack(sql3);
return false;
}
}
catch
{
return false;
}
}
/// <summary>
/// 获取顶的信息
/// </summary>
/// <param name="nId">注释的ID</param>
/// <param name="uId">用户的ID </param>
/// <param name="isDing">顶操作的类型 1为顶 0为踩</param>
/// <returns></returns>
public static DingEntity GetDing(int nId,int uId, int isDing)
{
DataBase db = new DataBase();
DataSet rs = db.RunProcReturn("select * from tb_Ding where nid=" + nId +"and uid=" + uId, "tb_Ding");
DataSet rs1 = db.RunProcReturn("select * from tb_note where id=" + nId , "tb_note");
int ding = int.Parse(rs1.Tables[0].Rows[0]["agree"].ToString());
int cai = int.Parse(rs1.Tables[0].Rows[0]["disagree"].ToString());
int ID = int.Parse(rs.Tables[0].Rows[0]["id"].ToString());
ding = ding + 1;
cai = cai + 1;
if (rs.Tables[0].Rows.Count >= 1)
{
if (isDing ==1 )
{
string sql1 = "UPDATE tb_note SET agree =" + ding + " where id="+nId;
db.ExCommandNoBack(sql1);
}
else if(isDing == 0)
{
string sql2 = "UPDATE tb_note SET disagree =" + cai+ " where id=" + nId;
db.ExCommandNoBack(sql2);
}
}
/*else
{
string sql3 = "delete from dbo.tb_Ding where id=" + ID + "";
db.ExCommandNoBack(sql3);
}*/
return null;
}
public AddRuleBase(Rule model, DataBase db, string bName)
{
_model = model;
ButtonName = bName;
_oldModel = (model is QuestionRule ? new QuestionRule(model as QuestionRule) : (Rule)new ResultRule(model as ResultRule)) ;
_db = db;
}
public FloodServ(ServicesDaemon Base)
: base(Base)
{
FloodDB = new DataBase();
AddRequired("Help.dll");
}
public static void DelAnnouncement(String id)
{
/*删除公告*/
DataBase db = new DataBase();
string sql = "delete from dbo.tb_announcement where id=" + id + "";
db.ExCommandNoBack(sql);
}
//查询所有用户考试的试卷
public DataSet QueryUserPaperList()
{
DataBase DB = new DataBase();
string strsql = "SELECT distinct Usersmr.UserID,Usersmr.UserName,Usersmr.DepartmentId, Departmentmr.DepartmentId,Departmentmr.DepartmentName,UserAnswermr.UserID,UserAnswermr.PaperID,UserAnswermr.ExamTime,UserAnswermr.state,Papermr.PaperName FROM Usersmr,Departmentmr,UserAnswermr,Papermr where Usersmr.DepartmentId=Departmentmr.DepartmentId and Usersmr.UserID=UserAnswermr.UserID and UserAnswermr.PaperID=Papermr.PaperID order by UserAnswermr.ExamTime desc";
return DB.GetStrDataSet(strsql);
}
//查询所用试卷
//不需要参数
public DataSet QueryAllPaper()
{
DataBase DB = new DataBase();
string strsql = "SELECT *,CASE Papermr.PaperState WHEN 1 THEN '可用' ELSE '不可用' END AS state FROM Papermr,Coursemr where Papermr.CourseID=Coursemr.ID";
return DB.GetStrDataSet(strsql);
}
public override void SetUrl(DataBase db, Table table)
{
Url = $"{db.Settings.RootPath}{Constants.Separator}{db.Name}{Constants.Separator}{table.Name}";
Create();
}
public void dis()
{
TableCell cell1 = new TableCell();
cell1.Text = "报修日期";
TableCell cell2 = new TableCell();
cell2.Text = "报修人员";
TableCell cell3 = new TableCell();
cell3.Text = "设备名称";
TableCell cell4 = new TableCell();
cell4.Text = "故障描述";
TableCell cell5 = new TableCell();
cell5.Text = "原因分析";
TableCell cell6 = new TableCell();
cell6.Text = "解决方案";
TableCell cell7 = new TableCell();
cell7.Text = "维修人员";
TableCell cell8 = new TableCell();
cell8.Text = "维修日期";
TableCell cell9 = new TableCell();
cell9.Text = "维修处理";
TableRow row1 = new TableRow();
row1.Cells.Add(cell1);
row1.Cells.Add(cell2);
row1.Cells.Add(cell3);
row1.Cells.Add(cell4);
row1.Cells.Add(cell5);
row1.Cells.Add(cell6);
row1.Cells.Add(cell7);
row1.Cells.Add(cell8);
row1.Cells.Add(cell9);
TableCell cell10 = new TableCell();
row1.Style.Add("background-color", "green");
row1.Style.Add("color", "white");
cell10.Text = "维修处理";
Table1.Rows.Add(row1);
SqlConnection conn = new DataBase().getSqlConnection();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from 维修记录 order by id desc";
try
{
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
TableCell cella = new TableCell();
cella.Width = Unit.Pixel(80);
if (sdr[2].ToString() != "")
{
cella.Text = Convert.ToDateTime(sdr[2].ToString()).ToShortDateString();
//报修日期
}
TableCell cellb = new TableCell();
cellb.Width = Unit.Pixel(80);
cellb.Text = sdr[4].ToString();//报修人员
TableCell cellc = new TableCell();
cellc.Width = Unit.Pixel(80);
cellc.Text = tb[sdr[1].ToString()].ToString(); //设备名称
TableCell celld = new TableCell();
celld.Text = sdr[3].ToString(); //故障描述
TableCell celle = new TableCell();
celle.Text = sdr[6].ToString(); //原因分析
TableCell cellf = new TableCell();
cellf.Text = sdr[7].ToString(); //解决方案
TableCell cellg = new TableCell();
cellg.Text = sdr[8].ToString(); //解决人员
cellg.Width = Unit.Pixel(80);
TableCell cellh = new TableCell();
cellh.Width = Unit.Pixel(80);
if (sdr[9].ToString() != "")
{
cellh.Text = Convert.ToDateTime(sdr[9].ToString()).ToShortDateString();//维修日期
}
TableCell cellk = new TableCell();
cellk.Width = Unit.Pixel(80);
//if (sdr[6].ToString() == "" || sdr[7].ToString()=="")
{
LinkButton lkbtn = new LinkButton();
lkbtn.PostBackUrl = "/machine/shebeiweixiu.aspx?id=" + sdr[0].ToString() + "&machineName=" + cellc.Text.ToString();
lkbtn.Text = "维修设备";
cellk.Controls.Add(lkbtn);
}
TableRow row = new TableRow();
row.Cells.Add(cella);
row.Cells.Add(cellb);
row.Cells.Add(cellc);
row.Cells.Add(celld);
row.Cells.Add(celle);
row.Cells.Add(cellf);
row.Cells.Add(cellg);
row.Cells.Add(cellh);
row.Cells.Add(cellk);
Table1.Rows.Add(row);
}
}
catch (Exception ey)
{
}
finally
{
conn.Close();
}
}
/**
* Função que apaga a relação de pontosrotulopaciente inteira de uma vez.
*/
public static void Drop()
{
DataBase.Drop(tableId);
}
/**
* Função que deleta dados cadastrados anteriormente na relação de pontosrotulopaciente.
*/
public static void DeleteValue(int id)
{
DataBase.DeleteValue(tableId, id);
}
private DataTable tblReport()
{
string trial = Request.QueryString.Get("trial");
bool trialFlag = false;
string sql = "SELECT *, (select top 1 Detail from tblPendingInfo where TicketID = t1.ID order by PendingInfoOn desc) as Detail FROM tblTicket t1";
if (Session["CompanyID"].ToString() != "7")
{
sql += " WHERE BranchID = " + Session["BranchID"];
if (!string.IsNullOrEmpty(trial))
{
sql += " and CreationDate < '2020-01-01'";
trialFlag = true;
}
else
{
sql += " and CreationDate >= '2020-01-01'";
}
}
else if (!string.IsNullOrEmpty(trial))
{
sql += " where CreationDate < '2020-01-01'";
trialFlag = true;
}
else
{
sql += " where CreationDate >= '2020-01-01'";
}
sql += " ORDER BY ID DESC";
DataTable tblTicket = DataBase.GetDT(sql);
DataTable table = new DataTable();
table.Columns.Add("ID");
table.Columns.Add("CreationDate");
table.Columns.Add("ResponseDate");
table.Columns.Add("TimeResponse");
table.Columns.Add("SlaResponse");
table.Columns.Add("RestorationDate");
table.Columns.Add("TimeRestoration");
table.Columns.Add("SlaRestoration");
table.Columns.Add("TotalPendingInfoRestoration");
table.Columns.Add("TotalAmerinodeRestoration");
table.Columns.Add("ResolutionDate");
table.Columns.Add("TimeResolution");
table.Columns.Add("SlaResolution");
table.Columns.Add("TotalPendingInfoResolution");
table.Columns.Add("TotalAmerinodeResolution");
table.Columns.Add("ClosureDate");
table.Columns.Add("BranchID");
table.Columns.Add("OEMID");
table.Columns.Add("TechnologyID");
table.Columns.Add("StatusID");
table.Columns.Add("SeverityID");
table.Columns.Add("SolutionTypeID");
table.Columns.Add("NetworkElementID");
table.Columns.Add("UserName");
table.Columns.Add("ProblemTitle");
table.Columns.Add("Advances");
foreach (DataRow dr in tblTicket.Rows)
{
ClsSLA clsSla = new ClsSLA(Convert.ToInt32(dr["id"]), Convert.ToInt32(dr["SeverityID"]), Convert.ToInt32(dr["BranchID"]), trialFlag);
DateTime currentTime = DateTime.Now;
DataRow fila = table.NewRow();
fila["ID"] = dr["id"];
fila["CreationDate"] = dr["CreationDate"];
fila["ResponseDate"] = dr["ResponseDate"];
if (!string.IsNullOrEmpty(dr["ResponseDate"].ToString()))
{
currentTime = DateTime.Parse(dr["ResponseDate"].ToString());
}
ClsSlaData tResponse = clsSla.getSla(DateTime.Parse(dr["CreationDate"].ToString()), currentTime, 2);
if (Convert.ToInt32(dr["StatusID"]) != 6)
{
fila["TimeResponse"] = tResponse.timeSla;
if (!string.IsNullOrEmpty(dr["ResponseDate"].ToString()))
{
fila["SlaResponse"] = tResponse.inSla;
}
else
{
fila["SlaResponse"] = "PENDING";
}
}
else
{
fila["TimeResponse"] = "NA";
fila["SlaResponse"] = "NA";
}
fila["RestorationDate"] = dr["RestorationDate"];
if (Convert.ToInt32(dr["StatusID"]) > 2 && Convert.ToInt32(dr["StatusID"]) != 6)
{
currentTime = DateTime.Now;
if (!string.IsNullOrEmpty(dr["RestorationDate"].ToString()))
{
currentTime = DateTime.Parse(dr["RestorationDate"].ToString());
}
try
{
ClsSlaData tRestoration = clsSla.getSla(DateTime.Parse(dr["ResponseDate"].ToString()), currentTime, 3);
fila["TimeRestoration"] = tRestoration.timeSla;
if (!string.IsNullOrEmpty(dr["RestorationDate"].ToString()))
{
fila["SlaRestoration"] = tRestoration.inSla;
}
else
{
fila["SlaRestoration"] = "PENDING";
}
fila["TotalPendingInfoRestoration"] = tRestoration.slaFromPendingInfo;
fila["TotalAmerinodeRestoration"] = tRestoration.timeSla;
}
catch (Exception)
{
fila["TimeRestoration"] = "";
fila["SlaRestoration"] = "PENDING";
fila["TotalPendingInfoRestoration"] = "";
fila["TotalAmerinodeRestoration"] = "";
}
}
else if (Convert.ToInt32(dr["StatusID"]) == 6)
{
fila["TimeRestoration"] = "NA";
fila["SlaRestoration"] = "NA";
fila["TotalPendingInfoRestoration"] = "NA";
fila["TotalAmerinodeRestoration"] = "NA";
}
else
{
fila["TimeRestoration"] = "";
fila["SlaRestoration"] = "PENDING";
fila["TotalPendingInfoRestoration"] = "";
fila["TotalAmerinodeRestoration"] = "";
}
if (Convert.ToInt32(dr["StatusID"]) > 3 && Convert.ToInt32(dr["StatusID"]) != 6)
{
currentTime = DateTime.Now;
if (!string.IsNullOrEmpty(dr["ResolutionDate"].ToString()))
{
currentTime = DateTime.Parse(dr["ResolutionDate"].ToString());
}
try
{
ClsSlaData tResolution = clsSla.getSla(DateTime.Parse(dr["RestorationDate"].ToString()), currentTime, 4);
fila["TimeResolution"] = tResolution.timeSla;
if (!string.IsNullOrEmpty(dr["ResolutionDate"].ToString()))
{
fila["SlaResolution"] = tResolution.inSla;
}
else
{
fila["SlaResolution"] = "PENDING";
}
fila["TotalPendingInfoResolution"] = tResolution.slaFromPendingInfo;
fila["TotalAmerinodeResolution"] = tResolution.timeSla;
}
catch (Exception)
{
fila["TimeResolution"] = "";
fila["SlaResolution"] = "PENDING";
fila["TotalPendingInfoResolution"] = "";
fila["TotalAmerinodeResolution"] = "";
}
}
else if (Convert.ToInt32(dr["StatusID"]) == 6)
{
fila["TimeResolution"] = "NA";
fila["SlaResolution"] = "NA";
fila["TotalPendingInfoResolution"] = "";
fila["TotalAmerinodeResolution"] = "";
}
else
{
fila["TimeResolution"] = "";
fila["SlaResolution"] = "PENDING";
fila["TotalPendingInfoResolution"] = "";
fila["TotalAmerinodeResolution"] = "";
}
fila["ResolutionDate"] = dr["ResolutionDate"];
fila["ClosureDate"] = dr["ClosureDate"];
fila["BranchID"] = dr["BranchID"];
fila["OEMID"] = dr["OEMID"];
fila["TechnologyID"] = dr["TechnologyID"];
fila["StatusID"] = dr["StatusID"];
fila["SeverityID"] = dr["SeverityID"];
fila["SolutionTypeID"] = dr["SolutionTypeID"];
fila["NetworkElementID"] = dr["NetworkElementID"];
fila["UserName"] = dr["UserName"];
fila["ProblemTitle"] = dr["ProblemTitle"];
if (Convert.ToInt32(dr["StatusID"]) == 5)
{
string note = dr["ClosureNote"].ToString();
int indexInitial = note.IndexOf("Date:");
int indexFinish = note.IndexOf("\n-");
if (indexInitial >= 0 && indexFinish >= 0)
{
string texto = note.Substring(indexInitial, indexFinish - 1);
indexInitial = texto.IndexOf("\n");
texto = texto.Substring(indexInitial);
fila["Advances"] = texto;
}
else
{
fila["Advances"] = note;
}
}
else
{
fila["Advances"] = dr["Detail"];
}
table.Rows.Add(fila);
}
return(table);
}
/// <summary>
/// 分类视频并导入
/// </summary>
/// <param name="MoviePaths"></param>
/// <param name="ct"></param>
/// <param name="IsEurope"></param>
/// <returns></returns>
public static double DistinctMovieAndInsert(List <string> MoviePaths, CancellationToken ct, bool IsEurope = false)
{
Logger.LogScanInfo(Environment.NewLine + "-----【" + DateTime.Now.ToString() + "】-----");
Logger.LogScanInfo(Environment.NewLine + $"{Jvedio.Language.Resources.ScanVideo} => {MoviePaths.Count} " + Environment.NewLine);
List <string> result1 = new List <string>();
string log1 = "";
string id = "";
VedioType vt = 0;
double totalinsertnum = 0; //总的导入数目
double unidentifynum = 0; //无法识别的数目
//检查未识别出番号的视频
foreach (var item in MoviePaths)
{
if (File.Exists(item))
{
id = IsEurope ? Identify.GetEuFanhao(new FileInfo(item).Name) : Identify.GetFanhao(new FileInfo(item).Name);
if (IsEurope)
{
if (string.IsNullOrEmpty(id))
{
vt = 0;
}
else
{
vt = VedioType.欧美;
}
}
else
{
vt = Identify.GetVedioType(id);
}
if (vt != 0)
{
result1.Add(item);
}
else
{
log1 += " " + item + Environment.NewLine;
unidentifynum++;
}
}
}
Logger.LogScanInfo(Environment.NewLine + $"【{Jvedio.Language.Resources.NotRecognizeNumber} ：{unidentifynum}】" + Environment.NewLine + log1);
//检查 重复|分段 视频
Dictionary <string, List <string> > repeatlist = new Dictionary <string, List <string> >();
string log2 = "";
foreach (var item in result1)
{
if (File.Exists(item))
{
id = IsEurope ? Identify.GetEuFanhao(new FileInfo(item).Name) : Identify.GetFanhao(new FileInfo(item).Name);
if (!repeatlist.ContainsKey(id))
{
List <string> pathlist = new List <string> {
item
};
repeatlist.Add(id, pathlist);
}
else
{
repeatlist[id].Add(item);//每个 id 对应一组视频路径，视频路径最多的视为分段视频
}
}
}
List <string> removelist = new List <string>();
List <List <string> > subsectionlist = new List <List <string> >();
foreach (KeyValuePair <string, List <string> > kvp in repeatlist)
{
if (kvp.Value.Count > 1)
{
//路径个数大于1 才为分段视频
(bool issubsection, List <string> filepathlist, List <string> notsubsection) = IsSubSection(kvp.Value);
if (issubsection)
{
subsectionlist.Add(filepathlist);
if (filepathlist.Count < kvp.Value.Count)
{
//其中几个不是分段视频
log2 += $" {Jvedio.Language.Resources.ID} ：{kvp.Key}" + Environment.NewLine;
removelist.AddRange(notsubsection);
log2 += $" {Jvedio.Language.Resources.ImportSubSection}： {filepathlist.Count} ，：{string.Join(";", filepathlist)}" + Environment.NewLine;
notsubsection.ForEach(arg =>
{
log2 += $" {Jvedio.Language.Resources.NotImport} ：{arg}" + Environment.NewLine;
});
}
}
else
{
log2 += $" {Jvedio.Language.Resources.ID}：{kvp.Key}" + Environment.NewLine;
(string maxfilepath, List <string> Excludelsist) = ExcludeMaximumSize(kvp.Value);
removelist.AddRange(Excludelsist);
log2 += $" {Jvedio.Language.Resources.ImportFile} ：{maxfilepath}，{Jvedio.Language.Resources.FileSize} ：{new FileInfo(maxfilepath).Length}" + Environment.NewLine;
Excludelsist.ForEach(arg =>
{
log2 += $" {Jvedio.Language.Resources.NotImport} ：{arg}，{Jvedio.Language.Resources.FileSize} ：{new FileInfo(arg).Length}" + Environment.NewLine;
});
}
}
}
Logger.LogScanInfo(Environment.NewLine + $"【 {Jvedio.Language.Resources.RepeatVideo}：{removelist.Count + subsectionlist.Count}】" + Environment.NewLine + log2);
List <string> insertList = result1.Except(removelist).ToList();//需要导入的视频
//导入分段视频
foreach (var item in subsectionlist)
{
insertList = insertList.Except(item).ToList();
ct.ThrowIfCancellationRequested();
string subsection = "";
FileInfo fileinfo = new FileInfo(item[0]);//获得第一个视频的文件信息
id = IsEurope ? Identify.GetEuFanhao(fileinfo.Name) : Identify.GetFanhao(fileinfo.Name);
if (IsEurope)
{
if (string.IsNullOrEmpty(id))
{
continue;
}
else
{
vt = VedioType.欧美;
}
}
else
{
vt = Identify.GetVedioType(id);
}
if (string.IsNullOrEmpty(id) | vt == 0)
{
continue;
}
//文件大小视为所有文件之和
double filesize = 0;
for (int i = 0; i < item.Count; i++)
{
if (!File.Exists(item[i]))
{
continue;
}
FileInfo fi = new FileInfo(item[i]);
subsection += item[i] + ";";
filesize += fi.Length;
}
//获取创建日期
string createDate = "";
try { createDate = fileinfo.LastWriteTime.ToString("yyyy-MM-dd HH:mm:ss"); }
catch { }
if (createDate == "")
{
createDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
Movie movie = new Movie()
{
filepath = item[0],
id = id,
filesize = filesize,
vediotype = (int)vt,
subsection = subsection.Substring(0, subsection.Length - 1),
otherinfo = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
scandate = createDate
};
DataBase.InsertScanMovie(movie);
totalinsertnum += 1;
}
//导入剩余的所有视频
foreach (var item in insertList)
{
ct.ThrowIfCancellationRequested();
if (!File.Exists(item))
{
continue;
}
FileInfo fileinfo = new FileInfo(item);
string createDate = "";
try { createDate = fileinfo.LastWriteTime.ToString("yyyy-MM-dd HH:mm:ss"); }
catch { }
if (createDate == "")
{
createDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
id = IsEurope ? Identify.GetEuFanhao(fileinfo.Name) : Identify.GetFanhao(fileinfo.Name);
if (IsEurope)
{
if (string.IsNullOrEmpty(id))
{
continue;
}
else
{
vt = VedioType.欧美;
}
}
else
{
vt = Identify.GetVedioType(id);
}
Movie movie = new Movie()
{
filepath = item,
id = id,
filesize = fileinfo.Length,
vediotype = (int)vt,
otherinfo = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
scandate = createDate
};
DataBase.InsertScanMovie(movie);
totalinsertnum += 1;
}
Logger.LogScanInfo(Environment.NewLine + $"{Jvedio.Language.Resources.TotalImport} => {totalinsertnum}，{Jvedio.Language.Resources.ImportAttention}" + Environment.NewLine);
//从 主数据库中 复制信息
//if (Path.GetFileNameWithoutExtension(Properties.Settings.Default.DataBasePath).ToLower() != "info")
//{
// try
// {
// string src = AppDomain.CurrentDomain.BaseDirectory + "DataBase\\info.sqlite";
// string dst = AppDomain.CurrentDomain.BaseDirectory + $"DataBase\\{Path.GetFileNameWithoutExtension(Properties.Settings.Default.DataBasePath).ToLower()}.sqlite"; ;
// DataBase.CopyDatabaseInfo(src, dst);
// }
// catch { }
//}
return(totalinsertnum);
}
public static double InsertWithNfo(List <string> filepaths, CancellationToken ct, Action <string> messageCallBack = null, bool IsEurope = false)
{
List <string> nfopaths = new List <string>();
List <string> vediopaths = new List <string>();
foreach (var item in filepaths)
{
if (item.ToLower().EndsWith(".nfo"))
{
nfopaths.Add(item);
}
else
{
vediopaths.Add(item);
}
}
//先导入 nfo 再导入视频，避免路径覆盖
if (nfopaths.Count > 0 && Properties.Settings.Default.ScanNfo)
{
Logger.LogScanInfo(Environment.NewLine + "-----【" + DateTime.Now.ToString() + "】-----");
Logger.LogScanInfo(Environment.NewLine + $"{Jvedio.Language.Resources.ScanNFO} => {nfopaths.Count} " + Environment.NewLine);
double total = 0;
//导入 nfo 文件
nfopaths.ForEach(item =>
{
if (File.Exists(item))
{
Movie movie = FileProcess.GetInfoFromNfo(item);
if (movie != null && !string.IsNullOrEmpty(movie.id))
{
DataBase.InsertFullMovie(movie);
total += 1;
Logger.LogScanInfo(Environment.NewLine + $"{Jvedio.Language.Resources.SuccessImportToDataBase} => {item} ");
}
}
});
Logger.LogScanInfo(Environment.NewLine + $"{Jvedio.Language.Resources.ImportNFONumber}： {total}" + Environment.NewLine);
messageCallBack?.Invoke($"{Jvedio.Language.Resources.ImportNFONumber}： {total}");
}
//导入视频
if (vediopaths.Count > 0)
{
try
{
double _num = Scan.DistinctMovieAndInsert(vediopaths, ct, IsEurope);
messageCallBack?.Invoke($"{Jvedio.Language.Resources.ImportVideioNumber}：{_num}，详情请看日志");
return(_num);
}catch (OperationCanceledException ex)
{
Logger.LogF(ex);
messageCallBack?.Invoke($"{Jvedio.Language.Resources.Cancel}");
}
}
return(0);
}
public DataTable Consultar(int id_grv)
{
return(DataBase.Select("SELECT TOP 1\r\n tb_dep_Grv.id_grv\r\n , tb_dep_Grv.id_status_operacao\r\n , tb_dep_grv.id_cliente\r\n , tb_dep_Grv.numero_formulario_grv\r\n , db_global..tb_glo_emp_empresas.nome\r\n , db_global..tb_glo_emp_empresas.inscricao_municipal\r\n , db_global..tb_glo_emp_empresas.cnpj\r\n , tb_dep_clientes.nome\r\n , tb_glo_loc_municipios.codigo_municipio_ibge\r\n , tb_dep_atendimento.nota_fiscal_nome\r\n , tb_dep_atendimento.nota_fiscal_cpf\r\n , tb_dep_atendimento.nota_fiscal_endereco\r\n , tb_dep_atendimento.nota_fiscal_numero\r\n , tb_dep_atendimento.nota_fiscal_complemento\r\n , tb_dep_atendimento.nota_fiscal_bairro\r\n , tb_dep_atendimento.nota_fiscal_municipio\r\n , tb_dep_atendimento.nota_fiscal_uf\r\n , tb_dep_atendimento.nota_fiscal_cep\r\n , tb_dep_atendimento.nota_fiscal_ddd\r\n , tb_dep_atendimento.nota_fiscal_telefone\r\n , tb_dep_atendimento.nota_fiscal_email\r\n , tb_dep_faturamento.id_faturamento\r\n , tb_dep_faturamento.data_pagamento\r\n , tb_dep_faturamento.valor_pagamento\r\n FROM tb_dep_grv\r\n JOIN tb_dep_clientes ON tb_dep_grv.id_cliente = tb_dep_clientes.id_cliente\r\n JOIN db_global..tb_glo_emp_empresas ON db_global..tb_glo_emp_empresas.id_empresa = tb_dep_clientes.id_empresa \r\n JOIN db_global..tb_glo_loc_cep ON db_global..tb_glo_loc_cep.id_cep = tb_dep_clientes.id_cep\r\n JOIN db_global..tb_glo_loc_municipios ON db_global..tb_glo_loc_municipios.id_municipio = db_global..tb_glo_loc_cep.id_municipio\r\n JOIN tb_dep_atendimento ON tb_dep_atendimento.id_grv = tb_dep_grv.id_grv\r\n JOIN tb_dep_faturamento ON tb_dep_faturamento.id_atendimento = tb_dep_atendimento.id_atendimento\r\n WHERE tb_dep_Grv.id_grv IN (" + id_grv + ")\r\n AND tb_dep_Grv.id_status_operacao = 'E'"));
}
public IActionResult List()
{
List <Product> products = DataBase.GetProducts();
return(View(products));
}
public AngajatRepository(DataBase context) : base(context)
{
}
public TransactionManager(DataBase context)
{
Context = context;
}
public IActionResult Detail(string slugLink)
{
Product product = DataBase.GetProduct(slugLink);
return(View(product));
}
/***********************************************
Returns an EmployeeVO object given a valid employeeid
*************************************************/
public EmployeeVO GetEmployee(Guid employeeid){
DbCommand command = DataBase.GetSqlStringCommand(SELECT_EMPLOYEE_BY_EMPLOYEE_ID);
DataBase.AddInParameter(command, EMPLOYEE_ID, DbType.Guid, employeeid);
return this.GetEmployee(command);
}
private void CriarBancoDados()
{
db = new DataBase();
db.CriarBancoDeDados();
}
public TableTemplateDomain(Authentication authentication, CremaTemplate templateSource, DataBase dataBase, string itemPath, string itemType)
: base(authentication.ID, dataBase.ID, itemPath, itemType)
{
this.template = templateSource;
this.view = this.template.View;
}
/************************************
Returns a List<EmployeeVO> object
**************************************/
public List<EmployeeVO> GetAllEmployees(){
DbCommand command = DataBase.GetSqlStringCommand(SELECT_ALL_EMPLOYEES);
return this.GetEmployeeList(command);
}
public CreateModel(DataBase dataBase)
{
_dataBase = dataBase;
}
static void Main(string[] args)
{
XmlConfigurator.Configure();
log.Info("Starting program");
//Loading configuration from file
try
{
config = new ConfLoader().loadConfFromFile("LMAX_sender_config.txt");
}
catch (Exception e)
{
log.Error(e.Message);
log.Debug(e.StackTrace.ToString());
log.Error("Exit program");
return;
}
random = new Random((int)DateTime.Now.Ticks / 10000);
isQuit = isRefrash = false;
Thread t = new Thread(new ThreadStart(KeyReadHandler));
t.Name = "Key handler thread";
t.Start();
syncUsers = new List <string>();
NewUsers = new List <string>();
//Create lock objects
usersLock = new Object();
errorWriteLock = new Object();
mustSyncLock = new Object();
randomLock = new Object();
newUserLock = new Object();
//Create necessary datas
BlockingCollection <Operations> blokingQueue = new BlockingCollection <Operations>();
//create sender db handler
dbHandler = new ErrorDbHandler();
//create object for manipulat with local DB
localDbHandler = new LocalDbHandler();
//Create error handler class for error solutions
ErrorHandler errorHandler = new ErrorHandler("ytsnotify", "YTS_admin password");
// Get datas from DB about users
remoteDbHandler = new DataBase();
try
{
lock (usersLock)
{
idUsers = remoteDbHandler.getConnectedUsers(dbHandler, errorHandler);
/*
* idUsers = new Dictionary<int, List<TradingClass>>();
* List<TradingClass> list1 = new List<TradingClass>();
* List<TradingClass> list2 = new List<TradingClass>();
*
* for (int i = 0; i < 2; ++i)
* {
* list.Add(new TradingClass("user_"+i,"userName_"+i,"Passwd_0"+i,"URL","userEmail",dbHandler));
* list[i].Login();
* Console.WriteLine("\tConnected users {0}", i);
* }
*
* list1.Add(new TradingClass("user_1", "userName_1", "Passwd_1", "URL", "userEmail", dbHandler));
* list2.Add(new TradingClass("user_2", "userName_2", "Passwd_2", "URL", "userEmail", dbHandler));
* list1[0].Login();
* list2[0].Login();
* idUsers.Add(10001, list1);
* idUsers.Add(10002, list2);*/
}
}
catch (Exception e)
{
log.Error(e.Message);
log.Debug(e.StackTrace.ToString());
log.Error("Exit program");
log.Info("Exit program becouse of error");
return;
}
System.Console.WriteLine("Get {0} users from DB", idUsers.Values.Count);
//Create class for user control directly after create users
externalClientManager = new ExternalClientManager();
//Create listen port
Type serviceType = typeof(ExternalClientManager);
Uri serviceUri = new Uri("http://localhost:9081/");
System.ServiceModel.ServiceHost host = new System.ServiceModel.ServiceHost(serviceType, serviceUri);
host.Open();
// Start NETlistener to get new users from DB
//NETlistener netListener = new NETlistener();
DateTime time0 = new DateTime();
DateTime oTime = new DateTime();
//Create time reader from file
DateFileWritter dateFile = new DateFileWritter();
time0 = dateFile.ReadTime();
//Create systemContainer to cach DB lastest data
systemContainer = new SystemContainer(blokingQueue, time0);
//Create sender class
SenderClass sender = new SenderClass(blokingQueue);
List <DBResult> res = new List <DBResult>();
Console.WriteLine("Loaded time value : {0}", time0.ToString("yyyy-MM-dd HH:mm:ss.fff"));
long start;
long finish;
long waitTime;
while (true)
{
if (isQuit)
{
Console.WriteLine("Buy....");
return;
}
//Створити нових фоловерів якщо вони є в списку
//CreateFromMarketFollowers(time0);
//Вирішити проблеми синхронізації
ProcessUsersSolveProblem(time0);
start = DateTime.Now.Ticks / 10000;
res = (List <DBResult>)remoteDbHandler.GetDBResult(time0);
if (res != null && res.Count > 0)
{
System.Console.WriteLine("Get results : {0}", res.Count);
oTime = time0;
time0 = res[0].DbTime;
dateFile.WriteTime(time0);
foreach (DBResult item in res)
{
systemContainer.AddElement(item);
}
systemContainer.processSystems(idUsers, oTime);
}
finish = DateTime.Now.Ticks / 10000;
waitTime = MUST_WAIT - (finish - start);
if (waitTime > 0)
{
Thread.Sleep((int)waitTime);
}
Console.WriteLine("wait in main loop");
}
//netListener.ShutDown();
sender.ShutDown();
}
public AlbumViewModel(DataBase db)
{
ArtistList = db.Artist.Select(a => new SelectViewModel {
Id = a.Id, Name = a.Name
}).ToList();
}
private void btnInqury_Click(object sender, EventArgs e)
{
//清除listView中的数据
listView.Items.Clear();
//获取用户输入的值
String search = textSearch.Text.Trim();
//判断用户输入值是否为全空
if (string.IsNullOrEmpty(search))
{
MessageBox.Show("查询项不能为空", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//连接数据库
SqlConnection conn = DataBase.Connect();
try
{
//创建一个SqlDataReader对象
SqlDataReader dr = null;
//按用户ID查询
if (radioButtonUserID.Checked == true)
{
//创建SQL查询语句，此证书编号是否存在
String strCmd = "select * from 用户重要操作历史表 where 操作用户ID = '" + search + "' order by 操作日期 DESC";
//判断操作用户ID是否存在
if (!DataBase.Inquire(strCmd, conn))
{
MessageBox.Show("操作用户ID输入错误或不存在", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//执行查询操作
DataBase.Inquire(strCmd, conn, ref dr);
//清除listView中的数据
listView.Items.Clear();
//输出结果
while (dr.Read())
{
//实例化一个ListViewItem对象
ListViewItem lv = new ListViewItem();
lv.Text = dr["操作用户ID"].ToString().Trim();//设置第一行显示的数据
//绑定剩余列的数据
lv.SubItems.Add(dr["操作日期"].ToString().Trim());
lv.SubItems.Add(dr["操作名称"].ToString().Trim());
//行数据创建完毕后添加到列表中
listView.Items.Add(lv);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
else if (radioButtonDate.Checked == true)
{
//时间数据类型转换
DateTime dt = new DateTime();
try
{
dt = DateTime.ParseExact(search, "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture);
}
catch (Exception et)
{
MessageBox.Show(et.Message + "，输入的日期格式不正确", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//创建SQL查询语句，用于按日期查询用户操作记录
String strCmd = "select * from 用户重要操作历史表 where 操作日期 >= '" + dt.ToString() + "' and 操作日期 < '" + dt.AddDays(1).ToString() + "' order by 操作日期 DESC";
//执行查询操作
DataBase.Inquire(strCmd, conn, ref dr);
//清除listView中的数据
listView.Items.Clear();
//输出结果
while (dr.Read())
{
//实例化一个ListViewItem对象
ListViewItem lv = new ListViewItem();
lv.Text = dr["操作用户ID"].ToString().Trim();//设置第一行显示的数据
//绑定剩余列的数据
lv.SubItems.Add(dr["操作日期"].ToString().Trim());
lv.SubItems.Add(dr["操作名称"].ToString().Trim());
//行数据创建完毕后添加到列表中
listView.Items.Add(lv);
}
if (!dr.IsClosed)
{
dr.Close();
}
}
else
{
MessageBox.Show("只能填写其中一项进行查询", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception e1)
{
MessageBox.Show(e1.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
DataBase.Close(conn);
}
}
protected void btOpen_Click(object sender, EventArgs e)
{
//Update the contact info on the user
string sql = "UPDATE aspnet_Users SET WorkPhone = @work, MobilePhone = @mobile, HasWhatsapp = @whats WHERE UserName = @UserName";
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@work", SqlDbType = SqlDbType.NVarChar, Value = tbWork.Text
},
new SqlParameter()
{
ParameterName = "@mobile", SqlDbType = SqlDbType.NVarChar, Value = tbMobile.Text
},
new SqlParameter()
{
ParameterName = "@whats", SqlDbType = SqlDbType.Bit, Value = chWhats.Checked
},
new SqlParameter()
{
ParameterName = "@UserName", SqlDbType = SqlDbType.NVarChar, Value = User.Identity.Name
}
};
DataBase.UpdateDB(sp, sql, "ApplicationServices");
//Send email with ticket data
string test2 = DateTime.Now.Subtract(DateTime.UtcNow).ToString();
string test3 = test2.Substring(0, test2.IndexOf(":"));
string msg = @"
<b><h3>TICKET #: " + tbTicket.Text + @"</h3></b>
<b><h3>SEVERITY: " + cbSeverity.Text + @"</h3></b>
Ticket and Contact Details: <br/><br/>
<table style = ""width: 80 %; "" border = ""2"" cellpadding = ""4"">
<tr>
<td style = ""width: 26 %; "">Creation Date and Time (local)</td>
<td style = ""width: 73 %;""> " + DateTime.Now.ToLocalTime() + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Creation Date and Time (utc)</td>
<td style = ""width: 73 %;""> " + DateTime.Now.ToUniversalTime() + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Creation Time Zone</td>
<td style = ""width: 73 %;""> " + test3 + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Customer - Branch</td>
<td style = ""width: 73 %; ""> " + tbBranch.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Creator Name</td></td>
<td style = ""width: 73 %; ""> " + tbName.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Creator Title</td>
<td style = ""width: 73 %; "" > " + tbTitle.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Creator Email</td>
<td style = ""width: 73 %; "" > " + tbEmail.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Group Emails</td>
<td style = ""width: 73 %; "" > " + glGroup.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Work Phone</td></td>
<td style = ""width: 73 %; ""> " + tbWork.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Mobile Phone</td>
<td style = ""width: 73 %; "" > " + tbMobile.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Has WhatsApp</td>
<td style = ""width: 73 %; "" > " + chWhats.Checked.ToString() + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Additional Contact Instruction</td>
<td style = ""width: 73 %; "" > " + tbContactInstructions.Text + @" </td>
</tr>
</table> ";
msg += "<br/>";
msg += "<br/>";
msg += "Site Details:<br/><br/>";
msg += @"
<table style = ""width: 80 %; "" border = ""2"" cellpadding = ""4"">
<tr>
<td style = ""width: 26 %; "">OEM</td>
<td style = ""width: 73 %;""> " + cbOEM.SelectedItem.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Technology</td>
<td style = ""width: 73 %; ""> " + cbTech.SelectedItem.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Network Elements</td>
<td style = ""width: 73 %; ""> " + cbElement.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Controller</td>
<td style = ""width: 73 %; ""> " + cbController.SelectedItem.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Controller IP Access Information</td>
<td style = ""width: 73 %; "" > " + txtControllerIP.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Site</td>
<td style = ""width: 73 %; "" > " + glSites.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "" >Site IP Access Information</td>
<td style = ""width: 73 %; "" > " + txtSiteIP.Text + @" </td>
</tr>
</table> ";
msg += "<br/>";
msg += "<br/>";
msg += "Problem Details:<br/><br/>";
msg += @"
<table style = ""width: 80 %; "" border = ""2"" cellpadding = ""4"">
<tr>
<td style = ""width: 26 %; "">Problem Title</td>
<td style = ""width: 73 %;""> " + tbProblem.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Problem</td>
<td style = ""width: 73 %; ""> " + meProblem.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Remedy</td>
<td style = ""width: 73 %; ""> " + tbRemedy.Text + @" </td>
</tr>
<tr>
<td style = ""width: 26 %; "">Software Release</td>
<td style = ""width: 73 %; ""> " + tbRelease.Text + @" </td>
</tr>
</table> ";
//saving ticket to the DB
sql = @"INSERT INTO tblTicket
(ID, CreationDate,CreationDateUtc,UserName,SeverityID,OEMID,TechnologyID,NetworkElementID,RadioControllerID
,ProblemTitle,ProblemDescription,SoftwareRelease,ContactInstructions,Remedy, SiteIP, ControllerIP, BranchID, Sites)
VALUES
(@ID, @CreationDate,@CreationDateUtc,@UserName,@SeverityID,@OEMID,@TechnologyID,@NetworkElementID,@RadioControllerID,
@ProblemTitle,@ProblemDescription,@SoftwareRelease,@ContactInstructions,@Remedy, @SiteIP, @ControllerIP, @BranchID, @Sites)";
sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ID", SqlDbType = SqlDbType.BigInt, Value = Session["Ticket"]
},
new SqlParameter()
{
ParameterName = "@CreationDate", SqlDbType = SqlDbType.DateTime, Value = DateTime.Now.ToLocalTime()
},
new SqlParameter()
{
ParameterName = "@CreationDateUtc", SqlDbType = SqlDbType.DateTime, Value = DateTime.Now.ToUniversalTime()
},
new SqlParameter()
{
ParameterName = "@UserName", SqlDbType = SqlDbType.NVarChar, Value = User.Identity.Name
},
new SqlParameter()
{
ParameterName = "@SeverityID", SqlDbType = SqlDbType.Int, Value = cbSeverity.Value
},
new SqlParameter()
{
ParameterName = "@OEMID", SqlDbType = SqlDbType.Int, Value = cbOEM.Value
},
new SqlParameter()
{
ParameterName = "@TechnologyID", SqlDbType = SqlDbType.Int, Value = cbTech.Value
},
new SqlParameter()
{
ParameterName = "@RadioControllerID", SqlDbType = SqlDbType.Int, Value = cbController.Value
},
new SqlParameter()
{
ParameterName = "@ProblemTitle", SqlDbType = SqlDbType.NVarChar, Value = tbProblem.Text
},
new SqlParameter()
{
ParameterName = "@ProblemDescription", SqlDbType = SqlDbType.NVarChar, Value = meProblem.Text
},
new SqlParameter()
{
ParameterName = "@SoftwareRelease", SqlDbType = SqlDbType.NVarChar, Value = tbRelease.Text
},
new SqlParameter()
{
ParameterName = "@ContactInstructions", SqlDbType = SqlDbType.NVarChar, Value = tbContactInstructions.Text
},
new SqlParameter()
{
ParameterName = "@Remedy", SqlDbType = SqlDbType.NVarChar, Value = tbRemedy.Text
},
new SqlParameter()
{
ParameterName = "@SiteIP", SqlDbType = SqlDbType.NVarChar, Value = txtSiteIP.Text
},
new SqlParameter()
{
ParameterName = "@ControllerIP", SqlDbType = SqlDbType.NVarChar, Value = txtControllerIP.Text
},
new SqlParameter()
{
ParameterName = "@BranchID", SqlDbType = SqlDbType.Int, Value = Session["BranchID"]
},
new SqlParameter()
{
ParameterName = "@Sites", SqlDbType = SqlDbType.NVarChar, Value = glSites.Text
}
};
//not required comboboxes
SqlParameter singleparameter = new SqlParameter()
{
ParameterName = "@NetworkElementID",
SqlDbType = SqlDbType.Int,
};
if (cbElement.Value == null)
{
singleparameter.Value = DBNull.Value;
}
else
{
singleparameter.Value = cbElement.Value;
}
sp.Add(singleparameter);
DataBase.UpdateDB(sp, sql);
//update the groups
//go through the list of selected group emails (if any)
for (int i = 0; i < glGroup.GridView.Selection.Count; i++)
{
sql = "INSERT INTO tblGroupSelection (TicketID, GroupID) VALUES (@TicketID, @GroupID)";
sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@TicketID", SqlDbType = SqlDbType.BigInt, Value = Session["Ticket"]
},
new SqlParameter()
{
ParameterName = "@GroupID", SqlDbType = SqlDbType.BigInt, Value = glGroup.GridView.GetSelectedFieldValues("ID")[i]
}
};
DataBase.UpdateDB(sp, sql);
}
//update the sites
//go through the list of selected sites (if any)
for (int i = 0; i < glSites.GridView.Selection.Count; i++)
{
sql = "INSERT INTO tblSiteSelection (TicketID, SiteID) VALUES (@TicketID, @SiteID)";
sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@TicketID", SqlDbType = SqlDbType.BigInt, Value = Session["Ticket"]
},
new SqlParameter()
{
ParameterName = "@SiteID", SqlDbType = SqlDbType.BigInt, Value = glSites.GridView.GetSelectedFieldValues("ID")[i]
}
};
DataBase.UpdateDB(sp, sql);
}
//Set up title
string queryCompanyBranch = "SELECT SUBSTRING(t2.Name, 1, 3) as company, case when CHARINDEX('-', t1.Name) > 0 then SUBSTRING(t1.Name, CHARINDEX('-', t1.Name) + 1, 3)";
queryCompanyBranch += " when len(t1.Name) = 4 then SUBSTRING(t1.Name, 1, 4) else SUBSTRING(t1.Name, 1, 3) end as branch FROM tblBranch t1 INNER JOIN tblCompany t2 ON t2.ID = t1.CompanyID WHERE t1.ID = @ID";
List <SqlParameter> parCB = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ID", SqlDbType = SqlDbType.Int, Value = Session["BranchID"]
}
};
DataTable dtCompanyBranch = DataBase.GetDT(parCB, queryCompanyBranch);
string priority = cbSeverity.Text.Split(' ').Length > 1 ? cbSeverity.Text.Split(' ')[1].Trim() : cbSeverity.Text;
string title = string.Format("{0} {1} Ticket # {2} {3} {4}", dtCompanyBranch.Rows[0]["company"].ToString().ToUpper(), dtCompanyBranch.Rows[0]["branch"].ToString().ToUpper(), tbTicket.Text, tbProblem.Text, priority);
//sending to Amerinode internally
//Notifications.add(title, msg, "*****@*****.**", "*****@*****.**", Convert.ToInt64(Session["Ticket"]));
lblMsg.Text = "Email sent to Amerinode Support at [email protected] for immediate processing.";
Email.SendEmail(title, msg, "*****@*****.**");
//sending to the tiket creator
//Notifications.add(title, msg, "*****@*****.**", tbEmail.Text, Convert.ToInt64(Session["Ticket"]));
Email.SendEmail(title, msg, tbEmail.Text);
//Sending email to selected groups
for (int i = 0; i < glGroup.GridView.Selection.Count; i++)
{
//Notifications.add(title, msg, "*****@*****.**", glGroup.GridView.GetSelectedFieldValues("GroupEmail")[i].ToString(), Convert.ToInt64(Session["Ticket"]));
Email.SendEmail(title, msg, glGroup.GridView.GetSelectedFieldValues("GroupEmail")[i].ToString());
}
lblMsg.Text += System.Environment.NewLine + "Q also sent emails to Ticket Creator: " + tbEmail.Text + " and designated groups: " + glGroup.Text;
popMsg.ShowOnPageLoad = true;
btOpen.Enabled = false;
}
protected bool InviaMail(string nomeFoglio, object siglaEntita, List <Range> export)
{
string fileNameFull = "";
string fileName = "";
try
{
Excel.Worksheet ws = Globals.ThisWorkbook.Sheets[nomeFoglio];
DataView entitaProprieta = Workbook.Repository[DataBase.TAB.ENTITA_PROPRIETA].DefaultView;
entitaProprieta.RowFilter = "SiglaEntita = '" + siglaEntita + "' AND SiglaProprieta = 'SISTEMA_COMANDI_ALLEGATO_EXCEL' AND IdApplicazione = " + Workbook.IdApplicazione;
if (entitaProprieta.Count > 0)
{
fileName = entitaProprieta[0]["Valore"] + "_VDT_" + Workbook.DataAttiva.ToString("yyyyMMdd") + ".xls";
fileNameFull = Environment.ExpandEnvironmentVariables(@"%TEMP%\" + fileName);
//fileName = @"D:\" + entitaProprieta[0]["Valore"] + "_VDT_" + Workbook.DataAttiva.ToString("yyyyMMdd") + ".xls";
Excel.Workbook wb = Globals.ThisWorkbook.Application.Workbooks.Add();
int i = 2;
foreach (Range rng in export)
{
ws.Range[rng.ToString()].Copy();
wb.Sheets[1].Range["B" + i++].PasteSpecial();
}
wb.Sheets[1].Columns["B:C"].EntireColumn.AutoFit();
wb.Sheets[1].Range["A1"].Select();
wb.SaveAs(fileNameFull, Excel.XlFileFormat.xlExcel12);
wb.Close();
Marshal.ReleaseComObject(wb);
var config = Workbook.GetUsrConfigElement("destMailTest");
string mailTo = config.Test;
string mailCC = "";
if (Workbook.Ambiente == Simboli.PROD)
{
entitaProprieta.RowFilter = "SiglaEntita = '" + siglaEntita + "' AND SiglaProprieta = 'SISTEMA_COMANDI_MAIL_TO' AND IdApplicazione = " + Workbook.IdApplicazione;
mailTo = entitaProprieta[0]["Valore"].ToString();
entitaProprieta.RowFilter = "SiglaEntita = '" + siglaEntita + "' AND SiglaProprieta = 'SISTEMA_COMANDI_MAIL_CC' AND IdApplicazione = " + Workbook.IdApplicazione;
mailCC = entitaProprieta[0]["Valore"].ToString();
}
entitaProprieta.RowFilter = "SiglaEntita = '" + siglaEntita + "' AND SiglaProprieta = 'SISTEMA_COMANDI_CODICE_MAIL' AND IdApplicazione = " + Workbook.IdApplicazione;
string codUP = entitaProprieta[0]["Valore"].ToString();
config = Workbook.GetUsrConfigElement("oggettoMail");
string oggetto = config.Value.Replace("%COD%", codUP).Replace("%DATA%", Workbook.DataAttiva.ToString("dd-MM-yyyy"));
config = Workbook.GetUsrConfigElement("messaggioMail");
string messaggio = config.Value;
messaggio = Regex.Replace(messaggio, @"^[^\S\r\n]+", "", RegexOptions.Multiline);
if (DataBase.OpenConnection())
{
Outlook.Application outlook = GetOutlookInstance();
Outlook._MailItem mail = outlook.CreateItem(Outlook.OlItemType.olMailItem);
//TODO check se manda sempre con lo stesso account...
Outlook.Account senderAccount = outlook.Session.Accounts[1];
foreach (Outlook.Account account in outlook.Session.Accounts)
{
if (account.DisplayName == "Bidding")
{
senderAccount = account;
}
}
mail.SendUsingAccount = senderAccount;
mail.Subject = oggetto;
mail.Body = messaggio;
foreach (string dest in mailTo.Split(';'))
{
if (dest.Trim() != "")
{
mail.Recipients.Add(dest.Trim());
}
}
mail.CC = mailCC;
mail.Attachments.Add(fileNameFull);
mail.Send();
File.Delete(fileNameFull);
}
else
{
string emailFolder = @"C:\Emergenza\Email\" + Simboli.NomeApplicazione;
if (!Directory.Exists(emailFolder))
{
Directory.CreateDirectory(emailFolder);
}
File.Move(fileNameFull, Path.Combine(emailFolder, fileName));
}
}
}
catch (Exception e)
{
Workbook.InsertLog(Core.DataBase.TipologiaLOG.LogErrore, "SistemaComandi.Esporta.InvioMail [" + siglaEntita + "]: " + e.Message);
System.Windows.Forms.MessageBox.Show(e.Message, Simboli.NomeApplicazione + " - ERRORE!!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
if (File.Exists(fileNameFull))
{
File.Delete(fileNameFull);
}
return(false);
}
return(true);
}
private string SumAllMember()
{
string text2 = "";
string text3 = "";
string text4 = "";
int index = 0;
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = null;
SqlDataReader reader2 = null;
DataSet set = null;
double num3 = 0;
string[] textArray = "01,11,21,31,41,总单,02,12,22,32,42,总双,03,13,23,33,43,总大,04,14,24,34,44,总小,05,15,25,35,45,06,16,26,36,46,07,17,27,37,47,08,18,28,38,48,09,19,29,39,49,10,20,30,40".Split(new char[] { ',' });
reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
DateTime time = Convert.ToDateTime(reader["kaisai"].ToString().Trim());
TimeSpan span = DateTime.Now.Subtract(time);
int num4 = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes;
if (num4 < 360)
{
object obj2 = text2;
text2 = string.Concat(new object[] { obj2, "<tr bgcolor='#FFFFFF' ><td rowspan=10>", reader["kaisai"].ToString().Split(new char[] { ' ' })[0].ToString().Trim(), "<BR>", reader["kaisai"].ToString().Split(new char[] { ' ' })[1].ToString().Trim(), "</td><td rowspan=10 align=center>", reader["qishu"], "</td>" });
text4 = reader["kaisai"].ToString();
reader.Close();
set = base3.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') where ((id>6 and id<11 )or (id>83 and id <133)) order by id asc");
for (int i = 0; i < 10; i++)
{
if (i != 0)
{
text2 = text2 + "<tr bgcolor='#FFFFFF' >";
}
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 4]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 4]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 4]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[i + 4]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text6 = text2;
text2 = text6 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text7 = text2;
text2 = text7 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 4]["id"].ToString().Trim() + "&tztype=9&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 14]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 14]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 14]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[i + 14]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text8 = text2;
text2 = text8 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text9 = text2;
text2 = text9 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 14]["id"].ToString().Trim() + "&tztype=9&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 0x18]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 0x18]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x18]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[i + 0x18]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text10 = text2;
text2 = text10 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text11 = text2;
text2 = text11 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x18]["id"].ToString().Trim() + "&tztype=9&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 0x22]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 0x22]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x22]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[i + 0x22]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text12 = text2;
text2 = text12 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text13 = text2;
text2 = text13 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x22]["id"].ToString().Trim() + "&tztype=9&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
if (i < 9)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 0x2c]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 0x2c]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x2c]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[i + 0x2c]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text14 = text2;
text2 = text14 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text15 = text2;
text2 = text15 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x2c]["id"].ToString().Trim() + "&tztype=9&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td colspan=2> </td>";
}
if (i < 4)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = text2 + "<td align=center>" + textArray[index++] + "</td>";
if (reader2.Read())
{
object obj3 = text2;
object[] objArray2 = new object[] { obj3, "<td align=center class=tznumer>", text3, " <br> <a href='tzinfo.aspx?gameid=", set.Tables[0].Rows[i]["id"].ToString().Trim(), "&tztype=", int.Parse(((i + 8) / 2).ToString()), "&marker=C'> <font color=#000088>", double.Parse(reader2["summoney"].ToString()).ToString(), "</font></a></td> </tr>" };
text2 = string.Concat(objArray2);
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td colspan=2> </td></tr>";
}
}
set.Dispose();
}
}
reader.Close();
base3.CloseConnect();
base3.Dispose();
base2.CloseConnect();
base2.Dispose();
string text16 = text2;
string[] textArray24 = new string[8];
textArray24[0] = text16;
textArray24[1] = "<tr bgcolor='#ffffff' height='25' ><td colspan=14>本页总额<b><font color=blue>";
textArray24[2] = num3.ToString();
textArray24[3] = "</font></b>元(49粒),码均<b><font color=black>";
textArray24[4] = (num3 / 49).ToString("F2");
textArray24[5] = "</font></b>元;按陪率42(12水)估算：如中到<b><font color=red>";
double num26 = (num3 * 0.88) / 7.1;
textArray24[6] = double.Parse(num26.ToString()).ToString("F2");
textArray24[7] = "</font></b>元投注额,本项目您将输彩</td></tr>";
return(string.Concat(textArray24) + "\n</table></form></body></html>");
}
/// <summary>
/// 進捗データ取得
/// </summary>
/// <param name="dpyno">伝票No</param>
/// <param name="process">工程コード</param>
/// <remarks>
/// 作成者 ： sesaki
/// 作成日 ： 2019/09/24
/// </remarks>
private void GetMgmt(string dpyno, string process)
{
DataSet dtSet = null;
DataBase dataBase = null;
try
{
dataBase = new DataBase();
List <object> paraList = new List <object>();
string sqlStr = QueryBuild.GetSappanMgmt(dpyno, ref paraList);
dataBase.ConnectDB();
dtSet = dataBase.GetDataSet(sqlStr, paraList.ToArray());
dataBase.DisconnectDB();
foreach (DataRow row in dtSet.Tables[0].Rows)
{
string cd = row["PROCESS_CD"].ToString();
bool disabled_flg = (cd != process);
switch (cd)
{
case Constants.PROCESS_SPNSEIZO:
Sappans = new Register(row, disabled_flg);
break;
case Constants.PROCESS_SPNKENSA:
Sappank = new Register(row, disabled_flg);
break;
case Constants.PROCESS_HENSHU:
switch (row["SUBPROCESS_CD"].ToString())
{
case Constants.PROCESS_SUB1:
Henshus = new Register(row, disabled_flg);
break;
case Constants.PROCESS_SUB2:
Henshuk = new Register(row, disabled_flg);
break;
default:
Henshus = new Register(row, disabled_flg);
Henshuk = new Register(row, disabled_flg);
break;
}
break;
case Constants.PROCESS_KENSA:
Kensa = new Register(row, disabled_flg);
break;
case Constants.PROCESS_GYOUMU:
Gyoumu = new Register(row, disabled_flg);
break;
}
}
}
catch (Exception ex)
{
ErrorGetMgmtMessage = Resources.TextResource.ErrorGetMgmt;
}
finally
{
if (dataBase != null)
{
dataBase.DisconnectDB();
}
if (dtSet != null)
{
dtSet.Dispose();
}
}
}
public async Task SaveUser()
{
await DataBase.CommitAsync();
}
private async void VerificaClassificadoBaseLocal()
{
if (DataBase.GetClassificado() != null)
{
try
{
var dadosSituacao = await SituacaoClassificadoService.VerificaSituacaoClassificado(DataBase.GetAppKey());
var dadosClassificadoLocal = DataBase.GetClassificado();
Situacao = dadosSituacao.situacao;
Observacao = dadosSituacao.obs;
CategoriaSelecionada = ListaCategoria.ToList().Find(c => c.categoria == dadosClassificadoLocal.categ);
SubCategoriaSelecionada = ListaSubCategoria.ToList().Find(s => s.subcategoria == dadosClassificadoLocal.subcateg);
Titulo = dadosClassificadoLocal.titulo;
Texto = dadosClassificadoLocal.texto;
Hora1Inicial = ListaHoras.ToList().Find(h => h.Horas == dadosClassificadoLocal.contato_h1.Substring(0, 5));
Hora1Final = ListaHoras.ToList().Find(h => h.Horas == dadosClassificadoLocal.contato_h1.Substring(5, 5));
Hora2Inicial = ListaHoras.ToList().Find(h => h.Horas == dadosClassificadoLocal.contato_h2.Substring(0, 5));
Hora2Final = ListaHoras.ToList().Find(h => h.Horas == dadosClassificadoLocal.contato_h2.Substring(5, 5));
Telefone = dadosClassificadoLocal.contato_tel;
Email = dadosClassificadoLocal.contato_email;
}
catch (Exception erro)
{
await App.Current.MainPage.DisplayAlert("Erro", "Erro => " + erro, "Ok");
}
}
}
/**
* Cria a relação para pontosrotulopaciente, contendo um id gerado automaticamente pelo banco como chave primária.
*/
public static void Create()
{
string query = "CREATE TABLE IF NOT EXISTS PONTOSROTULOPACIENTE (idRotuloPaciente INTEGER primary key AUTOINCREMENT,idExercicio INTEGER not null,estagioMovimentoPaciente VARCHAR (30) not null,tempoInicial REAL not null,tempoFinal REAL not null,foreign key (idExercicio) references EXERCICIO (idExercicio));";
DataBase.Create(query);
}
private void AppMain_Load(object sender, EventArgs e)
{
db = new DataBase();
timerTime.Start();
statusLabelOperator.Text = "当前操作员：" + PropertyClass.OperatorName;
}
