public void Save(WorkingDataBase db) { String selectSql = "Select [DBID] from [WorkDataBase] Where [DBName]='" + db.Name + "' And [DBYear]='" + db.Year + "' And [DBNo]<>'" + db.Code + "' "; if (new SqlCon().GetTable(selectSql).Rows.Count > 0) { throw new Exception("无法保存登录设置,保存会与现有登录冲突"); } EncryptionClass entry = new EncryptionClass(db.PassWord); // user.pwd1 = entry.EncrKey; // user.pwd2 = entry.EnIndex; // user.pwd3 = entry.IV; // user.pwd4 = entry.IvIndex; // user.pwd5 = entry.EncryString; String updateSql = @"UPDATE [WorkDataBase] SET [DBName] = '" + db.Name + @"' ,[DBYear] ='" + db.Year + @"' ,[DBSysName] ='" + db.SysName + @"' ,[IsActive] = '" + System.Convert.ToInt32(db.IsActive) + @"' ,[pwd1] = " + ByteToString(entry.EncrKey) + @" ,[pwd2] = " + ByteToString(entry.EnIndex) + @" ,[pwd3] = " + ByteToString(entry.IV) + @" ,[pwd4] =" + ByteToString(entry.IvIndex) + @" ,[pwd5] = '" + entry.EncryString + @"' ,[UserName] = '" + db.UserName + @"' ,[CompanyName] = '" + db.CompanyName + @"' ,[ServerIp]='" + db.ServerIp + @"' ,[IsLocal]='" + System.Convert.ToInt32(db.IsLocal) + @"' WHERE [DBNo]='" + db.Code + "'"; new SqlCon().ExcuteSql(updateSql); }
public void Delete(WorkingDataBase db) { String deleteSql = "DELETE [WorkDataBase] WHERE [DBNo]='" + db.Code + "'"; new SqlCon().ExcuteSql(deleteSql); //using (Soway.DB.Manage.DBDataDataContext connect = Soway.DB.Manage.DBDataDataContext.Instance) //{ // var q = from dbs in connect.WorkDataBases // where dbs.DBNo == db.Code // select dbs; // if (q.Count() > 0) // { // connect.WorkDataBases.DeleteOnSubmit(q.First()); // connect.SubmitChanges(); // } //} }
public BOFac(String code) { this.db = new WorkDataBaseFactory().ALLList().FirstOrDefault(p => p.Code == code); }
public DataBaseSourceFactory(String DBCode) { this.Db = new WorkDataBaseFactory().ALLList().FirstOrDefault(p => p.Code == DBCode); }
/// <summary> /// 年终结转 /// </summary> /// <param name="WorkDataBase">要结转的数据库</param> /// <param name="DisWorkDataBase">B</param> /// <param name="IsBFDB">大宗物料库</param> public void CarryForward(WorkingDataBase WorkDataBase, WorkingDataBase DisWorkDataBase, bool IsBFDB) { throw new System.NotImplementedException(); }
/// <summary> /// 将一个大宗物料的数据库转化成自动过磅数据库 /// </summary> /// <param name="DataBase">将一个大宗物料的数据库转化成自动过磅数据库</param> public void ConvertToAutoDataBase(WorkingDataBase DataBase) { throw new System.NotImplementedException(); }
/// <summary> /// 创建数据库 /// </summary> public void CreateDataBase(WorkingDataBase DataBase) { throw new System.NotImplementedException(); }
public void Create(WorkingDataBase db) { //using (DBDataDataContext contect = DBDataDataContext.Instance) //{ String selectSql = "Select [DBID] from [WorkDataBase] Where [DBName]='" + db.Name + "' And [DBYear]='" + db.Year + "'"; if (new SqlCon().GetTable(selectSql).Rows.Count > 0) { throw new Exception("不能创建名称,年度相同的帐套"); } else { var NoSql = "Select Max(DBNo) from [WorkDataBase]"; var noTable = new SqlCon().GetTable(NoSql); var topno = noTable.Rows[0][0]; String dbNo; if (topno == null || (topno is DBNull)) { dbNo = "01"; } else { dbNo = (System.Convert.ToInt32(topno.ToString()) + 1).ToString().PadLeft(2, '0'); } EncryptionClass entry = new EncryptionClass(db.PassWord); //user.pwd1 = entry.EncrKey; //user.pwd2 = entry.EnIndex; //user.pwd3 = entry.IV; //user.pwd4 = entry.IvIndex; //user.pwd5 = entry.EncryString; String InsertSql = @"INSERT INTO [WorkDataBase] ([DBName] ,[DBYear] ,[DBSysName] ,[IsActive] ,[DBNo] ,[pwd1] ,[pwd2] ,[pwd3] ,[pwd4] ,[pwd5] ,[UserName] ,[CompanyName] ,[ServerIp]) VALUES ('" + db.Name + @"' ,'" + db.Year + @"' ,'" + db.SysName + @"' ,'" + System.Convert.ToInt32(db.IsActive).ToString() + @"' ,'" + dbNo + @"' ," + ByteToString(entry.EncrKey) + @" ," + ByteToString(entry.EnIndex) + @" ," + ByteToString(entry.IV) + @" ," + ByteToString(entry.IvIndex) + @" ,'" + entry.EncryString + @"' ,'" + db.UserName + @"' ,'" + db.CompanyName + @"' ,'" + db.ServerIp + @"')"; new SqlCon().ExcuteSql(InsertSql); } // WorkDataBase user = new WorkDataBase(); // var q = from db1 in contect.WorkDataBases // where db1.DBName == db.Name // && db.Year == db1.DBYear // select db1 ; // if (q.Count() > 0) // { // throw new Exception("不能创建名称,年度相同的帐套"); // } // var q2=contect.WorkDataBases ; // if (q2.Count() > 0) // { // user.DBNo = (System.Convert.ToInt32(q2.Max(p => p.DBNo ))+1).ToString().PadLeft(2, '0'); // } // else // user.DBNo = "01"; // user.UserName = db.UserName; // user.DBYear = db.Year; // user.DBSysName = db.SysName; // user.IsActive = db.IsActive; // user.DBName = db.Name; // EncryptionClass entry = new EncryptionClass(db.PassWord); // user.pwd1 = entry.EncrKey; // user.pwd2 = entry.EnIndex; // user.pwd3 = entry.IV; // user.pwd4 = entry.IvIndex; // user.pwd5 = entry.EncryString; // contect.WorkDataBases.InsertOnSubmit(user); // contect.SubmitChanges(); // } }