public DataTable GetSubjectListWithTopicID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@TopicID", ID)
};
return(DBOperate.GetDataTable("usp_GetSubjectByTopicId", parameter));
}
catch
{
throw;
}
}
public DataTable GetMcqListwithPaperID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@PaperID", ID)
};
return(DBOperate.GetDataTable("usp_GetMcqByPaperId", parameter));
}
catch
{
throw;
}
}
public void DeleteCourseDetail(int id)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@CourseID", id)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_DeleteCourse", parameter);
}
catch
{
throw;
}
}
public DataTable GetTopicsWithSubjectID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@SubjectID", ID)
};
return(DBOperate.GetDataTable("usp_GetTopicBySubjectId", parameter));
}
catch
{
throw;
}
}
public DataTable CheckAccess(string session)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@Session", session)
};
return(DBOperate.GetDataTable("usp_CheckAccess", parameter));
}
catch
{
throw;
}
}
public DataTable GetCourseListWithID(int ID)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@CourseID", ID)
};
return(DBOperate.GetDataTable("usp_GetCourseById", parameter));
}
catch
{
throw;
}
}
public DataTable GetCountryCode(int country)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@countryId", country)
};
return(DBOperate.GetDataTable("usp_GetCountryCode", parameter));
}
catch
{
throw;
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
string sql = "select*from tb_Employee";
SqlDataAdapter sda = null;
DataSet ds = new DBOperate().GetDataSet(sql, "tb_Employee", ref sda);
AddPrizeAndPunishment = new AddPrizeAndPunishment();
foreach (DataRow dr in ds.Tables[0].Rows)
{
ComboBoxItem cbi = new ComboBoxItem();
cbi.Content = (string)dr["员工编号"];
cbi.Selected += Cbi_Selected;
AddPrizeAndPunishment.comboBox1.Items.Add(cbi);
}
AddPrizeAndPunishment.Show();
}
public void DisablePaperDetail(int id, string flag)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@PaperID", id),
new SqlParameter("@DisableFlag", flag)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_DisablePaper", parameter);
}
catch
{
throw;
}
}
public void UpdateProductType(int id, int type)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ProductID", id),
new SqlParameter("@IsSample", type)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateProductType", parameter);
}
catch
{
throw;
}
}
public List <CoetLogInfoEntity> GetLog(string startDateTime, string endDateTime, string logType)
{
try
{
string execSql = string.Empty;
string typeWhereTemplate = string.Empty;
string sqlTemplate = @"select Type, JsonInfo, SendIP, SendName, Createdt
from {0} where Createdt between @startDateTime and @endDateTime";
if (logType == "ALL")
{
typeWhereTemplate = "and 1 = 1";
}
else
{
typeWhereTemplate = string.Format("and Type = '{0}'", logType);
}
sqlTemplate = string.Format("{0} {1}", sqlTemplate, typeWhereTemplate);
DateTime sDate = Convert.ToDateTime(startDateTime);
DateTime eDate = Convert.ToDateTime(endDateTime);
if (sDate.Year != eDate.Year || sDate.Month != eDate.Month)
{
string stableName = LogTable.GetLogTName(sDate);
string etableName = LogTable.GetLogTName(eDate);
execSql = string.Format("{0} union {1}",
string.Format(sqlTemplate, stableName),
string.Format(sqlTemplate, etableName));
}
else
{
string tableName = LogTable.GetLogTName(sDate);
execSql = string.Format(sqlTemplate, tableName);
}
return(DBOperate.ExecuteDataList <CoetLogInfoEntity>(execSql, new { startDateTime = startDateTime, endDateTime = endDateTime }));
}
catch (Exception ex)
{
CoetLocalLog.Error(ex.ToString());
return(new List <CoetLogInfoEntity>());
}
}
/// <summary>
/// 清空数据和客户端
/// </summary>
private void ClearDataAndService()
{
// 先记录一下日志
OperateLog.Instance.RecordAll();
//如果服务列表存在则清空
if (Resources.GetRes().Services.Count > 0)
{
// 清空前先把日志保存掉
Resources.GetRes().Services.Clear();
}
// 清空数据
if (DBOperate.GetDBOperate().IsDataReady)
{
DBOperate.GetDBOperate().ClearData();
}
}
/// <summary>
/// 委托实现：发送邮件
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
bool delegate_SendMail(MessageEntity msg)
{
try
{
SMessage.SendMail(msg);
DBOperate.SaveMessageLog(msg, Enum_MessageType.Mail.ToString(), null);
SLog.WriteLogWithDefaultTime(msg.EMails + "发送成功");
return(msg.IsSended);
}
catch (Exception ex)
{
DBOperate.SaveMessageLog(msg, Enum_MessageType.Mail.ToString(), ex.Message);
SLog.WriteLogWithDefaultTime(string.Format("发送失败：{0} 出现问题：{1}", msg.EMails, ex.Message));
return(false);
}
}
public void AddGradeDetail(GradeMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@Grade", obj.Grade),
// new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@Description", obj.Description),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_AddGrade", parameter);
}
catch
{
throw;
}
}
public void AddTopicDetail(TopicMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@SubjectID", obj.SubjectID),
new SqlParameter("@Name", obj.Name),
// new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@Description", obj.Description),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_AddTopic", parameter);
}
catch
{
throw;
}
}
public void UpdateUserDetail(UserMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@UserId", obj.UserId),
new SqlParameter("@UserName", obj.UserName),
new SqlParameter("@EmailID", obj.Email),
new SqlParameter("@AccountStatus", obj.AccountStatus),
new SqlParameter("@ValidFrom", obj.ValidFrom),
new SqlParameter("@ValidUpto", obj.ValidTo)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateUserStatus", parameter);
}
catch
{
throw;
}
}
public void AddTestimonialDetail(TestimonialMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@AuthorName", obj.AuthorName),
new SqlParameter("@Photo", obj.Photo),
// new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@Contents", obj.Contents),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_AddTestimonial", parameter);
}
catch
{
throw;
}
}
public void UpdateSubCourseDetail(SubCourseMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@SubCourseID", obj.SubCourseID),
new SqlParameter("@Name", obj.Name),
new SqlParameter("@CourseID", obj.CourseID),
//new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateSubCourse", parameter);
}
catch
{
throw;
}
}
public void AddAnswerDetail(AnswerMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@McqID", obj.McqID),
new SqlParameter("@SN", obj.SN),
new SqlParameter("@AnswerType", obj.AnswerType),
new SqlParameter("@Answer", obj.Answer),
new SqlParameter("@AnswerImage", obj.AnswerImage),
new SqlParameter("@IsVisible", obj.IsVisible),
new SqlParameter("@Correct", obj.Correct)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_AddMcqAnswer", parameter);
}
catch
{
throw;
}
}
public void AddDiscountDetail(DiscountMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@Name", obj.Name),
new SqlParameter("@Description", obj.Description),
new SqlParameter("@Percentage", obj.Percentage),
new SqlParameter("@ValidFrom", obj.ValidFrom),
new SqlParameter("@ValidUpto", obj.ValidTo),
// new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_AddDiscount", parameter);
}
catch
{
throw;
}
}
private void ModifyButton_Click(object sender, RoutedEventArgs e)
{
if (dataGrid.SelectedItem == null)
{
return;
}
ModifyPrizeAndPunishment = new ModifyPrizeAndPunishment();
DataRowView drv = dataGrid.SelectedItem as DataRowView;
if (drv != null)
{
ModifyPrizeAndPunishment.ID = (int)drv.Row["编号"];
string userID = (string)drv.Row["员工编号"];
ModifyPrizeAndPunishment.comboBox2.Text = (string)drv["奖/罚"];
ModifyPrizeAndPunishment.textBox1.Text = (string)drv["员工姓名"];
ModifyPrizeAndPunishment.textBox2.Text = (string)drv["所属部门"];
ModifyPrizeAndPunishment.textBox3.Text = (string)drv["奖罚内容"];
ModifyPrizeAndPunishment.textBox4.Text = (string)drv["奖励金额"];
ModifyPrizeAndPunishment.textBox5.Text = (string)drv["罚款金额"];
ModifyPrizeAndPunishment.datePicker1.DisplayDate = Convert.ToDateTime((string)drv["奖罚日期"]);
ModifyPrizeAndPunishment.datePicker2.DisplayDate = Convert.ToDateTime((string)drv["撤销日期"]);
string sql = "select*from tb_Employee";
SqlDataAdapter sda = new SqlDataAdapter();
DataSet ds = new DBOperate().GetDataSet(sql, "tb_Employee", ref sda);
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
ComboBoxItem cbi = new ComboBoxItem();
cbi.Content = (string)dr1["员工编号"];
cbi.Selected += Cbi_Selected1;
if ((string)cbi.Content == userID)
{
cbi.IsSelected = true;
}
ModifyPrizeAndPunishment.comboBox1.Items.Add(cbi);
}
}
ModifyPrizeAndPunishment.Show();
}
public int SaveLog(List <CoetLogInfoEntity> logInfoList)
{
try
{
string tableName = LogTable.GetCurrentLogTName();
int executeCount = 0;
int levelCount = 200;
int partCount = 1;
if (logInfoList.Count > levelCount)
{
partCount = logInfoList.Count / levelCount;
}
List <List <CoetLogInfoEntity> > partList = CoetArry.splitList(logInfoList, partCount);
foreach (var part in partList)
{
StringBuilder sb = new StringBuilder();
foreach (var item in part)
{
sb.AppendFormat(@"insert into {0}(Type, JsonInfo, SendIP, SendName, IdentificationId, Createdt) value('{1}', '{2}', '{3}', '{4}', '{5}', now());",
tableName, item.Type, item.JsonInfo, item.SendIP, item.SendName, Guid.NewGuid().ToString());
}
executeCount += DBOperate.ExecuteNonQuery(sb.ToString(), new { });
}
return(executeCount);
}
catch (Exception ex)
{
CoetLocalLog.Error(ex.ToString());
return(0);
}
}
/// <summary>
/// 发送邮件提醒，并更新消息状态
/// </summary>
public void SendMail()
{
List <MessageEntity> messages = DBOperate.LoadAlertMessage(Enum_MessageType.Mail.ToString());
//Parallel.ForEach(messages, msg =>
//{
// delegate_SendMail(msg);
//});
//异步发送
foreach (MessageEntity msg in messages)
{
delegate_SendMail(msg);
////带返回值
//SendMailDelegate fh = new SendMailDelegate(this.delegate_SendMail);
//IAsyncResult ar = fh.BeginInvoke(msg, null, fh);
//while (!ar.IsCompleted)
//{
// Thread.Sleep(100);
//}
//msg.IsSended = fh.EndInvoke(ar);
}
//DBOperate.UpdateMessageStatus(messages);
}
public void UpdateMcqDetail(McqMaster obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@McqID", obj.McqID),
new SqlParameter("@TopicwisePaperID", obj.TopicwisePaperID),
new SqlParameter("@YearwisePaperID", obj.YearwisePaperID),
new SqlParameter("@QuestionText1", obj.QuestionText1),
new SqlParameter("@QuestionImageLink", obj.QuestionImageLink),
new SqlParameter("@QuestionImage2", obj.QuestionImage2),
new SqlParameter("@QuestionAudioLink", obj.QuestionAudioLink),
new SqlParameter("@CommonAnswerImage", obj.CommonAnswerImage),
new SqlParameter("@QuestionText2", obj.QuestionText2),
new SqlParameter("@HintText", obj.HintText),
new SqlParameter("@HintImageLink", obj.SolutionImageLink),
new SqlParameter("@HintAudioLink", obj.SolutionAudioLink),
new SqlParameter("@VideoLink", obj.VideoLink),
new SqlParameter("@VideoUrl", obj.VideoUrl),
new SqlParameter("@SupportedDocumentLink", obj.SupportedDocumentLink),
new SqlParameter("@SupportedDocumentLink2", obj.SupportedDocumentLink2),
new SqlParameter("@SupportedDocumentLink3", obj.SupportedDocumentLink3),
new SqlParameter("@Marks", obj.Marks),
new SqlParameter("@TimeToSolve", obj.TimeToSolve),
// new SqlParameter("@IsVisible",obj.IsVisible.Equals(true)?1:0),
new SqlParameter("@CreatedBy", obj.CreatedBy),
new SqlParameter("@UpdatedBy", obj.UpdatedBy)
};
DBOperate.ExecuteProcedureWithOutReturn("usp_UpdateMcq", parameter);
}
catch
{
throw;
}
}
private void TreeViewItem_Selected(object sender, RoutedEventArgs e)
{
TreeVItem = sender as TreeViewItem;
if (TreeVItem != null)
{
HeaderName = TreeVItem.Header.ToString();
string sql;
switch (HeaderName)
{
case "所有部门":
sql = "select*from tb_Employee";
break;
default:
sql = "select*from tb_Employee where EmployeeDept='" + HeaderName + "'";
break;
}
DS = new DBOperate().GetDataSet(sql, HeaderName, ref sda);
dataGrid.DataContext = DS.Tables[HeaderName];
label.Content = HeaderName + "员工：" + DS.Tables[HeaderName].Rows.Count.ToString() + "人";
//此处终于让我对于路由事件有了深刻的认识！这里也可以选用PreGotFocus事件，效果等效。
e.Handled = true;
}
}
/// <summary>
/// ȡ����Ϣ�����е���Ϣ�б�
/// </summary>
/// <param name="TargetUser">��Ϣ������</param>
/// <param name="JobList">�û���Ӧ��ְλ�б�</param>
/// <param name="IsDel">��Ϣ״̬</param>
/// <param name="DateFromTo">��Ϣ��ʼʱ��</param>
/// <param name="DateTo">��Ϣ����ʱ��</param>
/// <param name="txtTitle">����</param>
/// <param name="HandleType">��Ϣ���</param>
/// <param name="TableName">����</param>
/// <param name="PageSize"></param>
/// <param name="CurrentPageIndex"></param>
/// <param name="OrderBy"></param>
/// <param name="TotalNum"></param>
/// <param name="ShowType">��ȡ�������˻��Ѱ�����ģ��.��ʾ���͡�1������ʾ���죬ֻ��ʾ���˵Ĵ������ˣ�2��ֻ��ʾ����ģ�����ʾ���˵Ĵ������ˣ�3�����˺ʹ�����Ա�Ķ���ʾ</param>
/// <returns></returns>
public DataView WaitHandle_PageView(string TargetUser, string JobList, int IsDel, string DateFromTo, string DateTo, string txtTitle, string MessageType, string HandleType, string TableName, string CurrentStepName, string ClientIdentifier, int PageSize, int CurrentPageIndex, string OrderBy, string ArchiveNo, int ShowType, out int TotalNum, string PType)
{
if (TargetUser == "")
TargetUser = "******";
Boolean IsOracle = DatabaseOperate.IsOracle("Messages_ConnectionString");
string sql = " where SendMode=4 and IsShow = 1 and IsDel= " + IsDel + " ";
if (IsDel == 0)
{
if (TableName.ToLower() == "Messages_Center".ToLower())
sql += " and IsNoHandle=0 and DoneDate is null ";
else if (IsDel == 0)
sql += " and DoneDate is not null ";
}
//�ж�JobList�Ƿ�Ϊ�գ������Ϊ�գ�˵��������ְλ����
string CanShowInType = "";
if (TableName.ToLower() == "Messages_Center".ToLower())
CanShowInType = " CanShowInWaitHandle ";
else
CanShowInType = " CanShowInWaitHandleDone ";
String PartitionTag = "";
if (TargetUser.Length > 0)
PartitionTag = TargetUser.Substring(0, 1);
//PartitionTag='" + PartitionTag + "' and
sql += " and ( ";
if (ShowType == 1)
sql += " ( TargetUser = '******' ) ";
else if (ShowType == 2)
{
sql += " ( " + this.GetSQLForCommissionSet(TargetUser, CanShowInType, false) + " ) ";
}
else if (ShowType == 3)
{
sql += " ( " + this.GetSQLForCommissionSet(TargetUser, CanShowInType) + " ) ";
}
else
sql += " ( 1=2 ) ";
if (JobList != "")
sql += " or ( JobGuid in ( SELECT JobGuid FROM Frame_Job WHERE BelongUserGuid='" + TargetUser + "')) ";
sql += " ) ";
if (DateFromTo != "")
{
if (IsOracle)
sql += " and GenerateDate >= TO_DATE('" + DateFromTo + "','YYYY-MM-DD HH24:MI:SS') ";
else
sql += " and GenerateDate >= '" + DateFromTo + "' ";
}
if (DateTo != "")
{
if (IsOracle)
sql += " and GenerateDate <= TO_DATE('" + DateTo + " 23:59:59','YYYY-MM-DD HH24:MI:SS') ";
else
sql += " and GenerateDate <= '" + DateTo + " 23:59:59' ";
}
if (txtTitle != "")
sql += "and Title like '%" + SQLOperate.ReplaceSql(txtTitle) + "%'";
if (HandleType != "")
sql += "and HandleType = '" + SQLOperate.ReplaceSql(HandleType) + "'";
if (CurrentStepName != "")
sql += "and BeiZhu = '" + SQLOperate.ReplaceSql(CurrentStepName) + "'";
if (ClientIdentifier != "!" && ClientIdentifier != "")
{
ClientIdentifier = ClientIdentifier.TrimEnd(';');
ClientIdentifier = SQLOperate.ReplaceSql(ClientIdentifier);
if (ClientIdentifier.StartsWith("!"))
{
ClientIdentifier = ClientIdentifier.Substring(1);
if (ClientIdentifier.IndexOf(":") > 0)
sql += " and ClientIdentifier not in ('" + ClientIdentifier.Replace(":", "','") + "') ";
else
sql += " and ClientIdentifier <> '" + ClientIdentifier + "' ";
}
else
{
if (ClientIdentifier.IndexOf(":") > 0)
sql += " and ClientIdentifier in ('" + ClientIdentifier.Replace(":", "','") + "') ";
else
sql += " and ClientIdentifier = '" + ClientIdentifier + "' ";
}
}
if (ArchiveNo != "")
sql += "and ArchiveNo like '%" + SQLOperate.ReplaceSql(ArchiveNo) + "%'";
if (MessageType != "")
{
if (MessageType == "����")
sql += "and MessageType = '����' ";
else
sql += "and MessageType = '" + SQLOperate.ReplaceSql(MessageType) + "' ";
}
//�˴�Ҫ�������
//if (PType == "1")//Ĭ�ϵ�Ҫ��ʾOA��һЩ����
//{
// //sb.Append(" (and ProcessGuid='' or ");
sql += " and ( PTYPE='" + PType + "') ";
//}
//else
//{ sql += " and ( ProcessGuid='qt' or ProcessGuid in (" + GetProcessGuidByType(PType) + ") ) "; }
//if (PType != "4")
//{
// sql += GetProcessGuidByType(PType);
//}
if (OrderBy == "")
OrderBy = " order by GenerateDate desc ";
DBOperate DBOper = new DBOperate();
DBOper.ConnectionStringName = DatabaseOperate.GetConnectionStringName("Messages_ConnectionString");
DataView dv = DBOper.GetData_Page(
" * ",
PageSize,
CurrentPageIndex,
TableName,
"Row_ID",
sql,
OrderBy,
out TotalNum
).DefaultView;
return dv;
}
/// <summary>
///// �ֻ����ż���
///// ��д���ڣ�2007-9-3
///// ��д�ˣ��ް���
/// </summary>
/// <param name="FromValue">��ʼʱ��</param>
/// <param name="ToValue">����ʱ��</param>
/// <param name="Content">����</param>
/// <param name="UserGuid">�����û�UserGuid</param>
/// <param name="PageSize"></param>
/// <param name="CurrentPageIndex"></param>
/// <param name="isSend">�Ƿ���״̬.0:δ���ͣ�1���ѷ��ͣ�9������</param>
/// <param name="TotalNum">TotalNum</param>
/// <returns>DataView</returns>
public DataView GetReceiveSmsView(string FromValue, string ToValue, string Content, string UserGuid, int PageSize, int CurrentPageIndex, out int TotalNum)
{
Boolean IsOracle = DatabaseOperate.IsOracle("Messages_ConnectionString");
String PartitionTag = "";
if (UserGuid.Length > 0)
PartitionTag = UserGuid.Substring(0, 1);
//PartitionTag='" + PartitionTag + "' and
string strWhere = " where SendMode=1 and TargetUser = '******' ";
if (Content != "")
strWhere += " and Content like '%" + SQLOperate.ReplaceSql(Content) + "%'";
if (FromValue != "")
{
if (IsOracle)
strWhere += " and ScheduleSendDate >= TO_DATE('" + FromValue + "','YYYY-MM-DD HH24:MI:SS') ";
else
strWhere += " and ScheduleSendDate >= '" + FromValue + "' ";
}
if (ToValue != "")
{
if (IsOracle)
strWhere += " and ScheduleSendDate <= TO_DATE('" + ToValue + " 23:59:59','YYYY-MM-DD HH24:MI:SS') ";
else
strWhere += " and ScheduleSendDate <= '" + ToValue + " 23:59:59' ";
}
string TableName = "";
string OrderStr = " order by Row_ID desc ";
string UnitField = "Row_ID";
TableName = "Messages_Center_Histroy";
DBOperate DBOper = new DBOperate();
DBOper.ConnectionStringName = DatabaseOperate.GetConnectionStringName("Messages_ConnectionString");
return DBOper.GetData_Page(
" * ",
PageSize,
CurrentPageIndex,
TableName,
UnitField,
strWhere,
OrderStr,
out TotalNum
).DefaultView;
}
/// <summary>
/// �ֻ����ż���
/// ��д���ڣ�2007-9-3
/// ��д�ˣ��ް���
/// </summary>
/// <param name="FromValue">��ʼʱ��</param>
/// <param name="ToValue">����ʱ��</param>
/// <param name="Content">����</param>
/// <param name="UserGuid">�����û�UserGuid</param>
/// <param name="PageSize"></param>
/// <param name="CurrentPageIndex"></param>
/// <param name="isSend">�Ƿ���״̬.0:δ���ͣ�1���ѷ��ͣ�9������</param>
/// <param name="TotalNum">TotalNum</param>
/// <returns>DataView</returns>
public DataView GetSmsDatePageView(string FromValue, string ToValue, string Content, string UserGuid, String SendUserName, String ReceiveMobile, int PageSize, int CurrentPageIndex, int isSend, Boolean isShowAll, out int TotalNum)
{
Boolean IsOracle = DatabaseOperate.IsOracle("Messages_ConnectionString");
string strWhere = " where SendMode=1 ";
if (IsOracle)
strWhere += " and nvl(IsDel,0)=0 ";
else
strWhere += " and ISNULL(IsDel,0)=0 ";
if (!isShowAll)
strWhere += " and FromUser = '******' ";
if (Content != "")
strWhere += " and Content like '%" + SQLOperate.ReplaceSql(Content) + "%'";
if (SendUserName != "")
strWhere += " and FromDispName like '%" + SQLOperate.ReplaceSql(SendUserName) + "%'";
if (ReceiveMobile != "")
strWhere += " and MessageTarget like '%" + SQLOperate.ReplaceSql(ReceiveMobile) + "%'";
if (FromValue != "")
{
if (IsOracle)
strWhere += " and ScheduleSendDate >= TO_DATE('" + FromValue + "','YYYY-MM-DD HH24:MI:SS') ";
else
strWhere += " and ScheduleSendDate >= '" + FromValue + "' ";
}
if (ToValue != "")
{
if (IsOracle)
strWhere += " and ScheduleSendDate <= TO_DATE('" + ToValue + " 23:59:59','YYYY-MM-DD HH24:MI:SS') ";
else
strWhere += " and ScheduleSendDate <= '" + ToValue + " 23:59:59' ";
}
string TableName = "";
string OrderStr = " order by Row_ID desc ";
string UnitField = "Row_ID";
if (isSend == 0)//���
TableName = "Messages_Center";
else if (isSend == 1)//�ѷ���
TableName = "Messages_Center_Histroy";
//else
//{
// OrderStr = " order by GenerateDate desc,Row_ID desc,MessageItemGuid ";
// TableName = "V_Messages_AllMSG";
// //UnitField = "MessageItemGuid";
//}
DBOperate DBOper = new DBOperate();
DBOper.ConnectionStringName = DatabaseOperate.GetConnectionStringName("Messages_ConnectionString");
return DBOper.GetData_Page(
" * ",
PageSize,
CurrentPageIndex,
TableName,
UnitField,
strWhere,
OrderStr,
out TotalNum
).DefaultView;
}
public DEmployee(string SqlConn)
{
this.SystemSqlConn = SqlConn;
operate = new DBOperate(SystemSqlConn);
}
public int ModifyClinicalComplaints(ClinicalComplaints obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
//new SqlParameter("@ChronicDiseaseID",obj.ChronicDiseaseID),
new SqlParameter("@CustomerID", obj.CustomerID),
//new SqlParameter("@DiabetesChronDis",obj.DiabetesChronDis),
//new SqlParameter("@HypertensionChronDis",obj.HypertensionChronDis),
//new SqlParameter("@CardiacDisorders",obj.CardiacDisorders),
//new SqlParameter("@KidneyDisorders",obj.CardiacDisorders),
//new SqlParameter("@LeverDisorders",obj.LeverDisorders),
//new SqlParameter("@OtherChronicDiseases",obj.OtherChronicDiseases),
//new SqlParameter("@FollowedParticularDietForProb",obj.FollowedParticularDietForProb),
new SqlParameter("@GastProbID", obj.GastProbID),
new SqlParameter("@Heartburn", obj.Heartburn),
new SqlParameter("@Bloating", obj.Bloating),
new SqlParameter("@Gas", obj.Gas),
new SqlParameter("@Diarrhoea", obj.Diarrhoea),
new SqlParameter("@Vomiting", obj.Vomiting),
new SqlParameter("@Constipation", obj.Constipation),
new SqlParameter("@LaxativeAntacide", obj.LaxativeAntacide),
new SqlParameter("@HomeRemedy", obj.HomeRemedy),
new SqlParameter("@GastroOthers", obj.GastroOthers),
new SqlParameter("@MedicationID", obj.MedicationID),
new SqlParameter("@TakeVitaminSup", obj.TakeVitaminSup),
new SqlParameter("@VitaminSupDet", obj.VitaminSupDet),
new SqlParameter("@TakeMineralSup", obj.TakeMineralSup),
new SqlParameter("@MineralSupDet", obj.MineralSupDet),
new SqlParameter("@OralDrugDType", obj.OralDrugDType),
new SqlParameter("@OralDrugDet", obj.OralDrugDet),
new SqlParameter("@MedicationOthers", obj.MedicationOthers),
new SqlParameter("@ClinicCompID", obj.ClinicCompID),
new SqlParameter("@ClinicCompGastProbID", obj.ClinicCompGastProbID),
new SqlParameter("@ClinicCompChronDisID", obj.ClinicCompChronDisID),
new SqlParameter("@ClinicCompMedicationID", obj.ClinicCompMedicationID),
new SqlParameter("@ClinicComplaintsNotes", obj.ClinicComplaintsNotes),
new SqlParameter("@ReturnVal", SqlDbType.Int)
};
return(DBOperate.ExecuteProcedure("usp_ModifyClinicalComplaints", parameter));
}
catch
{
throw;
}
}
public PrisonMigrate(PolygonSelectService polyService, DBOperate dbOper)
{
this.polyService = polyService;
this.dbOper = dbOper;
}
/// <summary>
/// 检测KEY
/// </summary>
/// <param name="IsFirt"></param>
private void CheckKey(bool IsInstall = false, bool IsIgnoreData = false, bool IsFirt = true)
{
//如果都没发现,那就直接跳过检测
if (IsFind == false)
{
FindKey();
if (IsFind == false)
{
IsCheck = false;
IsOpen = false;
IsInitialTime = false;
return;
}
}
//检测
bool Result = true; // return CheckKey()
if (Result)
{
IsCheck = true;
if (IsOpen == false)
{
//如果是安装版忽略打开
if (!IsInstall)
{
if (!Resources.GetRes().IsCreateMainCheckThread)
{
return;
}
// 检查
if (!Check())
{
System.Environment.Exit(0);
return;
}
// 打开前先检查是否过期
IsExpired();
if (Resources.GetRes().IsExpired == 1)
{
Request();
GetUid();
}
else
{
Open();
if (IsOpen)
{
Resources.GetRes().KEY_NAME_0 = GetName(Key.GetKeys().LANG_TYPE_0);
Resources.GetRes().KEY_NAME_1 = GetName(Key.GetKeys().LANG_TYPE_1);
Resources.GetRes().KEY_NAME_2 = GetName(Key.GetKeys().LANG_TYPE_2);
GetPass();
GetCount();
GetUid();
//GetKey();
// 获取剩余时间
CalculateLeftDays();
// 不忽略数据时重新获取数据
if (!IsIgnoreData && !DBOperate.GetDBOperate().IsDataReady)
{
//获取数据(之所以打算在新线程运行, 是因为怕第二次KeyCheck请求因为获取数据时会堵住. 但也之所以去掉是因为(貌似数据还没准备好这个错误不是很友好, 所以已在KeyCheck加入了锁)
//Task.Factory.StartNew(() =>
//{
DBOperate.GetDBOperate().LoadData();
//});
}
}
else
{
IsCheck = false;
}
}
}
}
}
else
{
IsCheck = false;
IsFind = false;
IsOpen = false;
IsInitialTime = false;
if (IsFirt)
{
CheckKey(IsInstall, IsIgnoreData, false);
}
}
}
public DRecord(string SqlConn)
{
this.SystemSqlConn = SqlConn;
operate = new DBOperate(SystemSqlConn);
}
