/// <summary>
/// Create Bank Account
/// </summary>
/// <param name="accounttype">enum AccountType</param>
/// <param name="amount">double amount</param>
/// <returns>returns the account number</returns>
public Guid CreateBankAccount(string personName, AccountType accounttype, decimal amount = 0)
{
var personId = CreateOrReturnPerson(personName);
Account a;
var id = Guid.NewGuid().ToString();
switch (accounttype)
{
case AccountType.CheckingsAcccount:
InsertOrUpdate.CheckingsAccount(personId, amount);
var checkings = Get.CheckingsAccount(personId);
a = new CheckingsAccount(checkings.AccountId, checkings.Amount);
_accounts.Add(a);
return(a.AccountNumber);
case AccountType.SavingsAccount:
InsertOrUpdate.SavingsAccount(personId, amount);
var savings = Get.SavingsAccount(personId);
a = new SavingsAccount(savings.AccountId, savings.Amount, savings.Interest);
_accounts.Add(a);
return(a.AccountNumber);
default:
return(Guid.Empty);
}
}
public override int GetHashCode()
{
int hash = 1;
if (operationCase_ == OperationOneofCase.Insert)
{
hash ^= Insert.GetHashCode();
}
if (operationCase_ == OperationOneofCase.Update)
{
hash ^= Update.GetHashCode();
}
if (operationCase_ == OperationOneofCase.InsertOrUpdate)
{
hash ^= InsertOrUpdate.GetHashCode();
}
if (operationCase_ == OperationOneofCase.Replace)
{
hash ^= Replace.GetHashCode();
}
if (operationCase_ == OperationOneofCase.Delete)
{
hash ^= Delete.GetHashCode();
}
hash ^= (int)operationCase_;
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public void MergeFrom(Mutation other)
{
if (other == null)
{
return;
}
switch (other.OperationCase)
{
case OperationOneofCase.Insert:
if (Insert == null)
{
Insert = new global::Google.Cloud.Spanner.V1.Mutation.Types.Write();
}
Insert.MergeFrom(other.Insert);
break;
case OperationOneofCase.Update:
if (Update == null)
{
Update = new global::Google.Cloud.Spanner.V1.Mutation.Types.Write();
}
Update.MergeFrom(other.Update);
break;
case OperationOneofCase.InsertOrUpdate:
if (InsertOrUpdate == null)
{
InsertOrUpdate = new global::Google.Cloud.Spanner.V1.Mutation.Types.Write();
}
InsertOrUpdate.MergeFrom(other.InsertOrUpdate);
break;
case OperationOneofCase.Replace:
if (Replace == null)
{
Replace = new global::Google.Cloud.Spanner.V1.Mutation.Types.Write();
}
Replace.MergeFrom(other.Replace);
break;
case OperationOneofCase.Delete:
if (Delete == null)
{
Delete = new global::Google.Cloud.Spanner.V1.Mutation.Types.Delete();
}
Delete.MergeFrom(other.Delete);
break;
}
_unknownFields = pb::UnknownFieldSet.MergeFrom(_unknownFields, other._unknownFields);
}
public FrmSalesMasterPop(InsertOrUpdate iu, string id)
{
InitializeComponent();
InsertOrUpdate = Convert.ToInt32(iu);
SalesID = id;
}
public FrmSalesMasterPop(InsertOrUpdate iu)
{
InitializeComponent();
InsertOrUpdate = Convert.ToInt32(iu);
}
public FrmShiftPop(InsertOrUpdate iu, string id)
{
InitializeComponent();
InsertOrUpdate = Convert.ToInt32(iu);
ShiftCode = id;
}
/// <summary>
/// SqlSugar的功能介绍
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
//设置执行的DEMO
string switchOn = "select";
IDemos demo = null;
switch (switchOn)
{
/****************************基本功能**************************************/
//查询
case "select": demo = new Select(); break;
//删除
case "delete": demo = new Delete(); break;
//插入
case "insert": demo = new Insert(); break;
//插入或者更新
case "insertorupdate": demo = new InsertOrUpdate(); break;
//更新
case "update": demo = new Update(); break;
//基层函数的用法
case "ado": demo = new Ado(); break;
//事务
case "tran": demo = new Tran(); break;
//创建实体函数
case "createclass": demo = new CreateClass(); break;
//T4生成 http://www.cnblogs.com/sunkaixuan/p/5751503.html
//日志记录
case "log": demo = new Log(); break;
//枚举支持
case "enum": demo = new EnumDemo(); break;
/****************************实体映射**************************************/
//自动排除非数据库列
case "ignoreerrorcolumns": demo = new IgnoreErrorColumns(); break;
//别名表
case "mappingtable": demo = new MappingTable(); break;
//别名列
case "mappingcolumns": demo = new MappingColumns(); break;
//通过属性的方法设置别名表和别名字段
case "attributesmapping": demo = new AttributesMapping(); break;
/****************************业务应用**************************************/
//过滤器
case "filter": demo = new Filter(); break;
//过滤器2
case "filter2": demo = new Filter2(); break;
//流水号功能
case "serialnumber": demo = new SerialNumber(); break;
//配置与实例的用法
case "initconfig": demo = new InitConfig(); break;
//读写分离
case "masterslave": demo = new MasterSlave(); break;
/****************************支持**************************************/
//公开函数数
case "pubmethod": demo = new PubMethod(); break;
//设置ToJson的日期格式
case "serializerdateformat": demo = new SerializerDateFormat(); break;
/****************************测试用例**************************************/
case "test": demo = new Test(); break;
default: Console.WriteLine("switchOn的值错误，请输入正确的 case"); break;
}
//执行DEMO
demo.Init();
//更多例子请查看API
//http://www.cnblogs.com/sunkaixuan/p/5654695.html
Console.WriteLine("执行成功请关闭窗口");
Console.ReadKey();
}
/// <summary>
/// Persist (insert or update) an entity.
/// </summary>
/// <param name="entity">The entity to be persisted.</param>
public void Persist(object entity)
{
var EntityType = entity.GetType();
var ClassName = EntityType.FullName;
Log.Debug("Persist " + ClassName);
qGen.IStatement InsertOrUpdate;
var ClassMetadata = this.MetadataFactory.GetMetadataForClass(EntityType);
var PrePersistEvt = ClassMetadata.Events.GetByType(EventTypes.PrePersist);
if (PrePersistEvt != null)
{
PrePersistEvt.MethodInfo.Invoke(entity, null);
}
if (ClassMetadata.ObjectInfo.IdentifierHasValue(entity))
{
InsertOrUpdate = new qGen.Update(ClassMetadata.TableName);
InsertOrUpdate.WhereClause = new qGen.Where();
foreach (var Col in ClassMetadata.Columns.GetIdColumns())
{
InsertOrUpdate.WhereClause.AddWithValue(Col.Name, ClassMetadata.ObjectInfo.GetColumnValue(entity, Col));
}
}
else
{
InsertOrUpdate = new qGen.Insert(ClassMetadata.TableName);
}
foreach (var Col in ClassMetadata.Columns)
{
if (Col.GeneratedValueStategy == GeneratedValueStategies.None)
{
object ColValue;
if (Col.AssociationMetada != null && Col.AssociationMetada.AssociationType != AssociationTypes.None)
{
// Association column. Get value from property on the other side
object OtherEndEntity = ClassMetadata.ObjectInfo.GetColumnValue(entity, Col);
if (OtherEndEntity == null)
{
ColValue = null;
}
else
{
ColValue = Col.AssociationMetada.OtherEndClass.ObjectInfo.GetColumnValue(OtherEndEntity, Col.AssociationMetada.OtherEndColumn);
}
}
else
{
// Regular member-to-column value
ColValue = ClassMetadata.ObjectInfo.GetColumnValue(entity, Col);
}
InsertOrUpdate.ColumnValues.AddWithValue(Col.Name, ColValue);
}
}
Log.Debug(InsertOrUpdate.ToString());
this.Connection.ExecuteNonQuery(InsertOrUpdate);
if (InsertOrUpdate is qGen.Insert)
{
foreach (var Col in ClassMetadata.Columns)
{
if (Col.GeneratedValueStategy == GeneratedValueStategies.DbGenerated)
{
var Id = this.Connection.GetLastInsertId();
ClassMetadata.ObjectInfo.SetColumnValue(entity, Col, Id);
Log.Debug("Last insert id: " + Id.ToString());
break;
}
}
}
var PostPersistEvt = ClassMetadata.Events.GetByType(EventTypes.PostPersist);
if (PostPersistEvt != null)
{
PostPersistEvt.MethodInfo.Invoke(entity, null);
}
}
public FrmMaterialCostPop(InsertOrUpdate iu, string id)
{
InitializeComponent();
InsertOrUpdate = Convert.ToInt32(iu);
MCCode = id;
}
public FrmMaterialCostPop(InsertOrUpdate iu)
{
InitializeComponent();
InsertOrUpdate = Convert.ToInt32(iu);
}
