public static void InitAccount(string no, string param = "")
{
if (!DBHelper.DefaultInstance.Exist(string.Format("select 1 from master.sys.databases t where t.name='{0}'", no)))
{
throw new FinanceException(FinanceResult.RECORD_NOT_EXIST, string.Format("账套[{0}]不存在", no));
}
var idObj = DBHelper.DefaultInstance.ExecuteScalar(string.Format("select _id from _AccountCtl where _no='{0}'", no));
if (idObj == null)
{
throw new FinanceException(FinanceResult.RECORD_NOT_EXIST, string.Format("账套[{0}]未加载", no));
}
if (param.Trim() == "-k")
{
var db = DBHelper.GetInstance(new Dictionary <string, object> {
{ "Tid", (long)idObj }
});
db.ExecuteSql(@"delete from _VoucherEntryUdef; delete from _VoucherEntry; delete from _VoucherHeader;
delete from _TaskResult;delete from _OperationLog;delete from _SerialNo where _key > 0;
update _SystemProfile set _value = 0 where _category= 'Account' and _key = 'IsInited';");
}
else
{
SourceMain.Init((long)idObj);
}
}
public static void CreateAccount(string no, string name)
{
if (DBHelper.DefaultInstance.Exist(string.Format("select 1 from master.sys.databases t where t.name='{0}'", no)))
{
throw new FinanceException(FinanceResult.RECORD_EXIST, string.Format("账套[{0}]已存在", no));
}
CreateDB(no);
if (DBHelper.DefaultInstance.Exist(string.Format("select 1 from _AccountCtl where _no='{0}'", no)))
{
DBHelper.DefaultInstance.ExecuteSql(string.Format("delete from _AccountCtl where _no='{0}'", no));
}
long id = 1;
var maxId = DBHelper.DefaultInstance.ExecuteScalar("select max(_id) from _AccountCtl");
if (maxId != null)
{
if (long.TryParse(maxId.ToString(), out id))
{
id++;
}
}
DataManager.GetInstance(null).Insert(new AccountCtl {
connstr = BuildConnectString(no), id = id, no = no, name = name, createTime = DateTime.Now
});
SourceMain.Init(id);
}
public static void InitData()
{
CreateDB("demo");
var defaultConnectString = ConfigHelper.XmlReadConnectionString("Finance.exe.config", "default");
var demoConnectString = BuildConnectString("demo");
DataManager.GetInstance(null).Insert(new AccountCtl {
connstr = demoConnectString, id = 0, no = "demo", name = "演示账套", createTime = DateTime.Now
});
DataManager.GetInstance(null).Insert(new AccountUser {
id = 0, no = "admin", name = "管理员", pwd = "E10ADC3949BA59ABBE56E057F20F883E", lastLoginTime = DateTime.Now
});
SourceMain.Init(0);
}