/// <summary>
/// ��model��ij��˱�ʶΪIdentity,Timestamp֮�������ֵ�������ݿ�
/// </summary>
/// <param name="model">��Ҫ�������ݿ��model</param>
/// <returns>Ӱ��ļ�¼��</returns>
public virtual int Insert(Model model)
{
model.GmtCreateUser = this.Operater;
model.GmtCreateDate = DateTime.Now;
model.GmtUpdateUser = this.Operater;
model.GmtUpdateDate = DateTime.Now;
ParmCollection parms = this.Table.PrepareNotIdentityParms(model);
return(Internal_DataHelper.ExecuteNonQuery(this.Table.Insert, parms));
}
/// <summary>
/// ����Key�ֶ���Ϊɾ��������model��������κ�ֵ��������Ϊɾ��������ֻ�б�ʶΪKey���ֶβŻ���Ϊɾ������
/// </summary>
/// <param name="models">��������model����</param>
/// <returns>Ӱ��ļ�¼��</returns>
public virtual int DeleteWithKeys(params Model[] models)
{
int returnCount = 0;
foreach (var model in models)
{
ParmCollection parms = this.Table.PrepareKeysParms(model);
returnCount += Internal_DataHelper.ExecuteNonQuery(string.Format(this.Table.Delete, parms.WhereSql), parms);
}
return(returnCount);
}
/// <summary>
/// ���������ֶ���Ϊɾ������
/// </summary>
/// <param name="identitys">�Զ�����ֵ����</param>
/// <returns>Ӱ��ļ�¼��</returns>
public virtual int DeleteWithIdentity(params long[] identitys)
{
int returnCount = 0;
foreach (var identity in identitys)
{
ParmCollection parm = this.Table.PrepareIdentityParm(identity);
returnCount += Internal_DataHelper.ExecuteNonQuery(string.Format(this.Table.Delete, parm.WhereSql), parm);
}
return(returnCount);
}
/// <summary>
/// ��model�������modelÿ�����˱�ʶΪIdentity,Timestamp֮�������ֵ�������ݿ�
/// </summary>
/// <param name="models">��Ҫ�������ݿ��</param>
/// <returns>Ӱ��ļ�¼��</returns>
public virtual int InsertCol(Model[] models)
{
int num = 0;
Collection <StringBuilder> sc = this.Table.PrepareInsertCol <Model, OutputModel>(models, this.Operater);
foreach (StringBuilder s in sc)
{
num += Internal_DataHelper.ExecuteNonQuery(s.ToString());
}
return(num);
}
/// <summary>
/// ������ձ���ȫ������
/// ��������־������Truncate Table ����
/// </summary>
public virtual void TruncateTable()
{
Internal_DataHelper.ExecuteNonQuery(string.Format("TRUNCATE TABLE {0}", this.Table.TableName));
}
/// <summary>
/// ɾ��ȫ����¼
/// </summary>
/// <returns>Ӱ��ļ�¼��</returns>
public virtual int DeleteAll()
{
return(Internal_DataHelper.ExecuteNonQuery(string.Format(this.Table.Delete, string.Empty)));
}