public override bool UpdateStudent(DS.Plugins.Student.StudentAllInfo info)
{
if (info != null && this.dataAccess != null)
{
#region sqlserver测试
/*
* string sql = "insert into students(id_card,name,sex,birthday) values('" +
* Fm.DAL.DALSecurityTool.TransferInsertField(info.IdCard)+"','"+
* Fm.DAL.DALSecurityTool.TransferInsertField(info.Name) + "','"+
* Fm.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "','"+
* Fm.DAL.DALSecurityTool.TransferInsertField(info.Birthday) + "')";
*/
#endregion
#region 顺景
/*
* string sql = "update Member set UserName='******',sex='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "',Birth='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.Birthday) + "',Nationality='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.NationString) + "', Uaddress='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.RegAddress) + "',Taddress='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.ConnAddress) + "',Phone='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.Phone1) + "',Zip='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.PostCode) + "',RegDate='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.RegDate) + "',Grade='" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.CarTypeCode) + "',Receivables=" +
* FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee) + " where Card='" +
*
* FT.DAL.DALSecurityTool.TransferInsertField(info.IdCard) + "'";
*/
#endregion
#region 珠海万里
string sql = "update jc_student set stuname='',sex,signupdate,signupstyle,alreadydlcode,nowdlcode,idno,telno) values('" +
FT.DAL.DALSecurityTool.TransferInsertField(info.Name) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.RegDate != null && info.RegDate.Length > 0 ? info.RegDate : System.DateTime.Now.ToString("yyyy-MM-dd")) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.LearnType == "初学" ? "初驾" : "增驾") + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.OldCarType) + "'," +
FT.DAL.DALSecurityTool.TransferInsertField(info.CarTypeCode) + "'," +
// FT.DAL.DALSecurityTool.TransferInsertField(info.IdCardTypeString == "居民身份证" ? "身份证" : info.IdCardTypeString) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.IdCard) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.Phone2) + "','" +
//FT.DAL.DALSecurityTool.TransferInsertField(info.Recommender) + "','" +
// FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee)
")";
#endregion
return(true);
// return this.dataAccess.ExecuteSql(sql);
}
return(false);
}
public override bool AddStudent(DS.Plugins.Student.StudentAllInfo info)
{
if (info != null && this.dataAccess != null)
{
#region sqlserver测试
/*
* string sql = "insert into students(id_card,name,sex,birthday) values('" +
* Fm.DAL.DALSecurityTool.TransferInsertField(info.IdCard)+"','"+
* Fm.DAL.DALSecurityTool.TransferInsertField(info.Name) + "','"+
* Fm.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "','"+
* Fm.DAL.DALSecurityTool.TransferInsertField(info.Birthday) + "')";
*/
#endregion
#region 顺景
/*
* string sql = "insert into Member(UserName,sex,Birth,Nationality,Card"
+ ",Uaddress,Taddress,Phone,Zip,RegDate,Grade,Receivables) values('" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Name) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Birthday) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.NationString) + "','" +
+ // FT.DAL.DALSecurityTool.TransferInsertField(info.IdCardTypeString == "居民身份证" ? "身份证" : info.IdCardTypeString) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.IdCard) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.RegAddress) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.ConnAddress) + "','" +
+ //FT.DAL.DALSecurityTool.TransferInsertField("同上") + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Phone1) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.PostCode) + "','" +
+ //FT.DAL.DALSecurityTool.TransferInsertField(info.Recommender) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.RegDate!=null&&info.RegDate.Length>0?info.RegDate:System.DateTime.Now.ToString("yyyy-MM-dd")) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.CarTypeCode) + "'," +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee) + ")";
*/
#endregion
#region 珠海万里
string sql1 = "select isnull(max(stucode),0)+1 from jc_student";
object obj = this.dataAccess.SelectScalar(sql1);
int id = (int)obj;
string sql = "insert into jc_student(zdjlflag,zdjl2flag,jyflag,txflag,fzflag,feestandard,feefact,free22,stucode,stuname,sex,signupdate,signupstyle,alreadydlcode,nowdlcode,idno,telno)"
+ " values(0,0,0,0,0," +
FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee) + "" + "," +
FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee) + "" + ",'" +
FT.DAL.DALSecurityTool.TransferInsertField(info.RegAddress) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(id.ToString().PadLeft(8, '0')) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.Name) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.RegDate != null && info.RegDate.Length > 0 ? info.RegDate : System.DateTime.Now.ToString("yyyy-MM-dd")) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.LearnType == "初学"?"初驾":"增驾") + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.OldCarType) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.CarTypeCode) + "','" +
// FT.DAL.DALSecurityTool.TransferInsertField(info.IdCardTypeString == "居民身份证" ? "身份证" : info.IdCardTypeString) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.IdCard) + "','" +
FT.DAL.DALSecurityTool.TransferInsertField(info.Phone2) + "'" +
//FT.DAL.DALSecurityTool.TransferInsertField(info.Recommender) + "','" +
// FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee)
")";
#endregion
#region 珠海柏宁
/*
* string sql1 = "select isnull(max(编号),0)+1 from student";
* object obj = this.dataAccess.SelectScalar(sql1);
* int id = (int)obj;
* string sql = "insert into student (已发证,状态,已审核,ck_id,地址,编号,姓名,性别,报名日期,报考车型,教练,身份证号,手机,办公电话,住址)"
+ " values(0,'正常',0,0,'" +
+
+ FT.DAL.DALSecurityTool.TransferInsertField(info.RegAddress) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(id.ToString().PadLeft(6, '0')) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Name) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Sex) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.RegDate != null && info.RegDate.Length > 0 ? info.RegDate : System.DateTime.Now.ToString("yyyy-MM-dd")) + "','" +
+ // FT.DAL.DALSecurityTool.TransferInsertField(info.LearnType == "初学" ? "初驾" : "增驾") + "','" +
+ // FT.DAL.DALSecurityTool.TransferInsertField(info.OldCarType) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.CarTypeCode) + "','','" +
+
+ // FT.DAL.DALSecurityTool.TransferInsertField(info.IdCardTypeString == "居民身份证" ? "身份证" : info.IdCardTypeString) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.IdCard) + "','" +
+
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Phone1) + "','" +
+ FT.DAL.DALSecurityTool.TransferInsertField(info.Phone2) + "','" +
+
+ FT.DAL.DALSecurityTool.TransferInsertField(info.ConnAddress) + "'" +
+
+ //FT.DAL.DALSecurityTool.TransferInsertField(info.Recommender) + "','" +
+
+
+ // FT.DAL.DALSecurityTool.TransferInsertField(info.Fee == string.Empty ? "0" : info.Fee)
+ ")";
*/
#endregion
return(this.dataAccess.ExecuteSql(sql));
}
return(false);
}
public override bool DeleteStudent(DS.Plugins.Student.StudentAllInfo info)
{
throw new Exception("The method or operation is not implemented.");
}