本文整理汇总了C#中StaffDataBase.getAllStaffDataList方法的典型用法代码示例。如果您正苦于以下问题:C# StaffDataBase.getAllStaffDataList方法的具体用法?C# StaffDataBase.getAllStaffDataList怎么用?C# StaffDataBase.getAllStaffDataList使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类StaffDataBase
的用法示例。
在下文中一共展示了StaffDataBase.getAllStaffDataList方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: setStudentBaseData
public string[] setStudentBaseData(CreateStudent StudentData)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
int CaseStatu = this.CaseStatusFunction(StudentData);
string upPhoto = "";
if (StudentData.studentPhoto != null)
{
upPhoto += " Stu[email protected], ";
}
if (StudentData.studentManualImg != null)
{
upPhoto += " [email protected], ";
}
StudentData1 oldStudentDataBase1=this.getStudentData1(StudentData.ID);
StudentHearingInformation oldStudentDataBase5 = this.getStudentHearingInfo(StudentData.ID);
#region 離會生&轉通知
if (oldStudentDataBase1.endReasonDate == "1900-01-01" && oldStudentDataBase1.endReasonDate != Chk.CheckStringFunction(StudentData.endReasonDate) && Chk.CheckStringFunction(StudentData.endReasonDate).Length > 0)
{
/*已結案轉入離會生*/
CreateStudentTracked StudentTracked = new CreateStudentTracked();
StudentTracked.sUnit = StudentData.Unit;
StudentTracked.studentID = StudentData.studentID;
StudentTracked.StudentIdentity = StudentData.studentTWID;
StudentTracked.email = StudentData.email;
StudentTracked.addressZip = StudentData.addressZip;
StudentTracked.addressCity = StudentData.addressCity;
StudentTracked.address = StudentData.address;
StudentTracked.Tel = StudentData.fPHPhone2;
StudentTracked.manualCategory1 = StudentData.manualCategory1;
StudentTracked.manualGrade1 = StudentData.manualGrade1;
StudentTracked.manualCategory2 = StudentData.manualCategory2;
StudentTracked.manualGrade2 = StudentData.manualGrade2;
StudentTracked.manualCategory3 = StudentData.manualCategory3;
StudentTracked.manualGrade3 = StudentData.manualGrade3;
StudentTracked.assistmanageR = oldStudentDataBase5.assistmanageR;
StudentTracked.brandR = oldStudentDataBase5.brandR;
StudentTracked.modelR = oldStudentDataBase5.modelR;
StudentTracked.buyingtimeR = oldStudentDataBase5.buyingtimeR;
StudentTracked.buyingPlaceR = oldStudentDataBase5.buyingPlaceR;
StudentTracked.insertHospitalR = oldStudentDataBase5.insertHospitalR;
StudentTracked.openHzDateR = oldStudentDataBase5.openHzDateR;
StudentTracked.assistmanageL = oldStudentDataBase5.assistmanageL;
StudentTracked.brandL = oldStudentDataBase5.brandL;
StudentTracked.modelL = oldStudentDataBase5.modelL;
StudentTracked.buyingtimeL = oldStudentDataBase5.buyingtimeL;
StudentTracked.buyingPlaceL = oldStudentDataBase5.buyingPlaceL;
StudentTracked.insertHospitalL = oldStudentDataBase5.insertHospitalL;
StudentTracked.openHzDateL = oldStudentDataBase5.openHzDateL;
this.createStudentTrackedDataBase(StudentTracked);
OtherDataBase oDB = new OtherDataBase();
StaffDataBase sDB = new StaffDataBase();
List<int> item = new List<int>();
//</option><option value="20">主任/教師</option><option value="21">主任/聽力師</option><option value="22">主任/社工</option></select>
item.Add(11);//主任
item.Add(20);//主任/教師
item.Add(21);//主任/聽力師
item.Add(22);//主任/社工
item.Add(17);//社工管理長
item.Add(18);//社工
int[] days = { 90, 180, 365 };
List<StaffDataList> SDL = sDB.getAllStaffDataList(item);
foreach (StaffDataList atom in SDL)
{
if (atom.sUnit == StudentData.Unit)
{
for (int i = 0; i < 3; i++)
{
CreateRemind Remind = new CreateRemind();
Remind.executionDate = Chk.CheckStringtoDateFunction(StudentData.endReasonDate).AddDays(days[i] - 5).ToShortDateString();
Remind.recipientID = atom.sID;
Remind.executionContent = StudentData.studentName + " 離會第 " + days[i].ToString() + " 天追蹤個案近況";
//cmd.Parameters.Add("@Executor", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(RemindSystemData.recipientID);
//cmd.Parameters.Add("@RemindContent", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(RemindSystemData.executionContent);
//cmd.Parameters.Add("@RemindDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(RemindSystemData.executionDate);
//cmd.Parameters.Add("@CompleteDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(RemindSystemData.fulfillmentDate);
oDB.CreateRemindSystem(Remind);
}
}
}
item.Clear(); item.Add(3);//行政組長
SDL = sDB.getAllStaffDataListRemindlist(item);
foreach (StaffDataList atom in SDL)
{
CreateRemind Remind = new CreateRemind();
Remind.executionDate = Chk.CheckStringtoDateFunction(StudentData.endReasonDate).AddDays(360).ToShortDateString();
Remind.recipientID = atom.sID;
Remind.executionContent = StudentData.studentName + " 離會第 365 天";
//cmd.Parameters.Add("@Executor", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(RemindSystemData.recipientID);
//cmd.Parameters.Add("@RemindContent", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(RemindSystemData.executionContent);
//cmd.Parameters.Add("@RemindDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(RemindSystemData.executionDate);
//cmd.Parameters.Add("@CompleteDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(RemindSystemData.fulfillmentDate);
oDB.CreateRemindSystem(Remind);
}
//.........这里部分代码省略.........