Пример #1
0
        public int Insert()
        {
            string querySql = "select 1 from AudioDownLoadInfo where GUID={0} and ShareToStetName={1}";

            if (null != Mediator.sqliteHelper.ExecuteScalar(querySql, Guid, ShareToStetName))
            {
                return(0);
            }

            string sql   = "insert into AudioDownLoadInfo select {0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16}";
            int    count = Mediator.sqliteHelper.ExecuteNonQuery(sql, Guid, StetSerialNumber, StetName, PatientType, PatientID, PatientName, Posture,
                                                                 Part, RecordTime.ToString("yyyy-MM-dd HH:mm:ss"), TakeTime.ToString(), Remark, DocName, DocDiagnose, ShareStetName, ShareToStetName, ShareTime == DateTime.MinValue ? "" : ShareTime.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));

            return(count);
        }